Error in Alert Log Sun Nov 25 02:14:17 2018Unable to allocate memory for new incident error in file E:ORACLE12Cdiagrdbmsicictraceic_m001_6448.trc:ORA-04030: out of process memory when trying to allocate 20520 bytes (pga …
Category:
Oracle
-
-
1. Identify your SQL ID of SQL Query which need to trace. SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_textFROM v$sqlWHERE sql_text like ‘SQL QUERY%’;2. Enable the trace of SQL with using SQLID …
-
Configure the Shared Single Client Access Name (SCAN) Single Client Access NameIn release 11g, SCAN is introduced, In SCAN act as cluster alias,you does not need to change the …
-
OracleRac
Change network interface and subnet address by OIFCFG command in RAC Environment
by tuanlpby tuanlpOracle Clusterware requires that each node is connected through a private network. You can also called cluster interconnect. It used for established communication between all the nodes present in the …
-
1. Stop all the services running on the Node srvctl stop service -db database_name -service “service_name_list” -node node_name–Examplesrvctl stop service -db grid -service “sales,oltp” -node NODE1 2. Check the VIP …
-
-
OracleTroubleshoot
ORA-01154: database busy. Open, close, mount, and dismount not allowed
by tuanlpby tuanlpNormal database environment If database is giving following message then you can use shutdown abort and startup it again. If not fixed then you can use shutdown abort commandShutdown abort …
-
-
OracleTroubleshoot
ORA-16018: cannot use LOG_ARCHIVE_DEST with LOG_ARCHIVE_DEST_n
by tuanlpby tuanlpError: When i tried to set the log_archive dest value then i got the following error:SQL> ALTER SYSTEM SET log_archive_dest=’D:oraclexe’;ALTER SYSTEM SET log_archive_dest=’D:oraclexe’*ERROR at line 1:ORA-02097: parameter cannot be modified …
-
OracleTroubleshoot
ORA-00257: archiver error. Connect internal only, until freed.
by tuanlpby tuanlpError: On checking the alert log we found the following error in alert log: ORA-00257: archiver error. Connect internal only, until freed.ORORA-19809: limit exceeded for recovery filesORA-19804: cannot reclaim 904507904 …