SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G SCOPE=BOTH SID=’*’.You can also set the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE initialization parameters to setup a flash recovery area to a running/open database. To setup the flash recovery area in your existing database, you need to set below mentioned required parameters in the database parameter file (PFILE) and also database needs a bounce or restart. = Setting FRA SIZE or disabling it /profile setup: Ñ Check that there are no more processes running Ñ Find out all the processes belonging to the database still running ORA-01102: cannot mount database in EXCLUSIVE mode
I received this error message when I was trying to mount the primary database in my dataguard configuration. = ORA-01102: cannot mount database in EXCLUSIVE mode SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=PERF01-ORA01)(PORT=1521))))’ Local_listener string (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=NODE1-vip)(PORT=1521)))) If itís pointing to one of vip nameís (NODE1-vip or NODE2-vip), change it to RAC name (RAC01) Then look at database parameter local_listener. ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATAĪnd both LISTENER and LISTENER_SCAN1 are ok. If after the installation of Oracle RAC 11gR2, when you try to connect remotely you have the following error:Ĭonnecting on both nodes of RAC you have the following error: = ORA-12545: Connect failed because target host or object does not existĮrror remote connection to SCAN after Oracle RAC 11gR2 installation $ lsnrctl stat (IT SHOULD SHOW SERVICE REGISTERED NOW ) This should probably work. SQL> alter system set local_listener = ‘(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))’ scope = both ORA-12505, TNS:listener does not currently know of SID given in connect descriptor sqlplus system/oracle as sysdba (4) SQL DEVELOPER Connectivity issue listener
(3) For Archive log issue, delete files from archive logs / # df -kh (2) Drop unwanted user by taking the backup using expdp and keep the backup on the same server In Oracle 11g Default path for Alter log files is:Įx: /u01/app/oracle/diag/rdbms/db01/db001/trace/alert_db001.log For Issues:Įx: /u01/app/oracle/diag/rdbms/db01/db001/trace/alert_db001.log Orapwd file=orapwXE PASSWORD=oracle force=y entries=3 $ orapwd file =orapwDYAXPROD PASSWORD=oracle force=y entries=3 It will reflect new values once the database is restarted.= Login / Oracle Space Issue Core_dump_dest=/u01/app/oracle/admin/test/cdumpĭb_create_file_dest="/u01/app/oracle/oradata"ĭb_create_online_log_dest_2=/u01/app/oracle/oradataĭb_create_online_log_dest_1=/u01/app/oracle/oradataĪudit_file_dest="/u01/app/oracle/admin/test/adump"Ĭontrol_files='/u01/app/oracle/oradata/test/test_control_01.ctl','/u01/app/oracle/oradata/test/test_control_02.ctl'Īfter changing the SGA_MAX_SIZE and SGA_TARGET parameter in pfile, We have to stop the database and start the database using a modified pfile to reflect new values of SGA_MAX_SIZE and SGA_TARGET.