Posts

Image
Oracle User's Password When It Has Expired , Also Make Profile Default and avoid future expire of passwords. 1. Export your database and login to the SQL Plus interface: export ORACLE_SID=YourDB sqlplus /nolog connect sys as sysdba 2. Modify the default user profile to set the password policies to ' UNLIMITED ': ALTER PROFILE DEFAULT LIMIT COMPOSITE_LIMIT UNLIMITED PASSWORD_LIFE_TIME UNLIMITED PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME UNLIMITED PASSWORD_GRACE_TIME UNLIMITED FAILED_LOGIN_ATTEMPTS UNLIMITED; 3. Check the password expiration and status of the user account associated with the Mobility Suite's ' /usr/local/nukona/etc/settings.cfg ' file: SELECT EXPIRY_DATE from dba_users where username = 'YourUser' ; SELECT RESOURCE_NAME,LIMIT FROM DBA_PROFILES WHERE PROFILE= 'DEFAULT' AND RESOURCE_NAME IN ( 'FAILED_LOGIN_ATTEMPTS' ...
Post a Comment
Read more

Oracle MTSRecovery Service not found Issue

Image
Oracle MTSRecovery Service not found Issue I was installing an Oracle 11g database for one of the client in the server , and came out of this error , which said  OracleMTSRecoveryService was not found.  Initially got confused , later understood that there is an Oracle software already installed in the same server and I was trying to install that again , due to which we encountered this error , Initial investigations , 1. Try retry and check once , if did not work , 2, Check for the location of old software installation , and New software installation both and check if omtsreco.exe file is present or not. 3. Once after that , go and check the registry , here is the main challenge Now install the oracle. If you already installed the oracle once. It should taken some path like below. In my system it took " E:\app\product\11.2.0\dbhome_1... " If you are installing second time installation will take path, " E:\app\product\11.2.0\dbho...
Post a Comment
Read more
Recently We had an requirement for restoring an old database , Scenario :   We just have an old database rman backup and do not have anything,      1. Do not know weather spfile and controlfile backed up or not,      2. Do not know weather archive files included or not ,      3. Do not know weather the backup is consistent or not, Client just provided the backup on the same server and asked us to restore the database, Rman restore can be done in 2 ways, 1 . Rman Cloning using Duplicate command 2 . Complete Restore - with procedure , 1st case : Clonning :-    To do this we need to have both Source and target database with up and running or one on the mounted state , most of all the target will be mounted ,  But our scenario has just backup and no database is up and running , This case we had no other choice than the 2nd case. 2nd Case : Complete restore  Here is how we followed the steps, ...
Post a Comment
Read more
ORA-00845: MEMORY_TARGET not supported on this system There is always something that gets in the way. One problem I regularly stumble upon when installing a new Oracle 11g R2 installation is the following error when I try to start the database: SQL> startup nomount; ORA-00845: MEMORY_TARGET not supported on this system So I keep this post mainly for my own reference when installing a new database on a Linux system. This error comes up because you tried to use the  Automatic Memory Management (AMM)   feature  of Oracle 11g R2. Well done, but it seems that your shared memory filesystem (shmfs) is not big enough. So let’s look at the steps necessary to enlarge your shared memory filesystem to avoid the error above. First of all, login as root and have a look at the filesystem: [root@oracle-em oracle]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_oracleem-lv_root 93G 19G 69G 22% / tmpfs ...
Post a Comment
Read more
Space_Count **   select user_bytes/1024/1024 from dba_data_files         where tablespace_name='<tbs_name>'; ** select sum(user_bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';            This will give us the space used in a particular datafile..... Tablespace_Size ** select bytes/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>'; ** select sum(bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';             This command will give the tablespace size what size is the tablespace created of..
Post a Comment
Read more
Renaming Database Well Rename your database in a very easy way..without affecting the DBID or to the SID... Step 1 :  Backup Controlfile to text Step 2:  Create  a pfile of your database Step 3:  Edit your controlfile with database name...keeping only resetlogs Step 4:  Edit pfile with dbname and controlfile parameter.. Step 5:  Startup with nomount option with the updated pfile.. Step 6:  Create a new controlfile Step 7:  Update the new controlfile in pfile and Startup with that pfile Step 8:  Create a new Spfile from the updated Pfile....               Thats it Database is renamed.......... Sql > alter database backup controlfile to trace as '/home/oracle/control.txt [ oracle@localhost :~ ]  vi control.txt CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Post a Comment
Read more
Recovery Catalog Step 1: Create a user to own Recovery Catalog..and grant him the necessary privilage   **   create user recovery identified by recovery;   **   grant connect,resource,recovery_catalog_owner to recovery... Step 2 : Create a default tablespace for the recovery owner..      **   create tablespace recovery             datafile "....................path............." size 50m autoextend on; Step 3: Make the user use the default tablespace which is created      **  Alter user recovery default tablespace recovery; Step 4: Creating catalog In the other screen just connect rman catalog..        **    rman catalog username/password                 ex: rman catalog recovery/recovery later inside rman   rman > create catalog;              ---> Thi...
Post a Comment
Read more