Shutdown Hangup Scenario

If Shutdown normal or shutdown immediate hangs and you try to connect as sys, it would get you connected either as idle instance or simply connected which is in reality a fake connection. In a particular scenario, I changed ORACLE_HOME from EM and then issued simple “SHUTDOWN” command which took a long time to complete. [...]

Continue reading »

Reconfiguring Oracle EM

Article taken from arjudba blogspot An Stack of Problems while creating Repository using emca In my database I tried to create repository and stopped several times while creating repository. I spend a significant amount of time to create repository and after analysis I got the following. A)Manually Resolve 1)If you fail after invoking command emca [...]

Continue reading »

Oracle Network Issues Link

Network DBA This link contains common network issues for Oracle Connectivity along with brief description of network files. NETWORK DBA  1. LISTENER.ORA file It is a server side file and contains information regarding network configuration parameters. It can be found in the ORACLE_HOME/network/admin directory on the server. Sample File SID_LIST_LISTENER =   (SID_LIST =     [...]

Continue reading »