Troubleshooting(Oracle)

Troubleshooting(Oracle)

ERROR CODE ORA-01033 Oracle Initialization or Shutdown in Progress
REMEDY On server machine Goto Control Panel>>Administrative tools>> Services. Double click on the oracle service of your database. For Example if your database name is nse9798 then double click On OracleServiceNse9798. This will open a window. Set startup Type as Manual and then restart the machine. When machine restarts again Goto Services and right click on OracleServiceNse9798 and click on start. And set startup type as Automatic. Now check your problem. If problem still persists , your Database is corrupted. Call at Shilpi Office for Backup restore.
ERROR CODE ORA-12224 No Listener
REMEDY Goto Control Panel>>Administrative Tools>>Services. Find OracleOrahome81TNSListener . Right click on it then Click on start. Then check the problem. If you changed the IP address of the machine then open the File Listener.ora in notepad from the location: ‘oracle\ora81\network\admin\’ and find the old IP address or machine name whichever you changed and replace with the new machine name or IP address. Do the same thing in the file tnsnames.ora in the same location. It will solve the problem.
ERROR CODE ORA-12560 TNS Protocol Adapter Error
REMEDY If this is occurring on client machine then it is not pinging to the Server machine or to itself. If its on server machine then its not Pinging to itself.
ERROR CODE ORA-01041 Target or Host definition does not exist
REMEDY If this is occurring on client machine then it is not pinging to the Server machine or to itself. If its on server machine then its not Pinging to itself. OR the machine name or IP address in the file Tnsnames.ora is incorrect. Correct it.
ERROR CODE ORA-12500 TNS Listener failed to start a Dedicated Server Process.
REMEDY Service for the database is not started. To start the service goto Control panel >> administrative >> tools >> services then right click on database service. For example if database name is Nse9798 then right click on oracleservicense9798 and click On start. Problem will be solved.
ERROR CODE Maximum Number of Processes #59 Exceeded.
REMEDY Goto oracle\admin\dbname\pfile and open init.ora in notepad And find the word ‘processes’ and set its value to 200. save And close the file. Problem will be solved.
ERROR CODE Oracle Instance Terminated, Disconnection Forced
REMEDY It causes database to be corrupted. Call at Shilpi Office forBackup restore.
ERROR CODE EXP-00037 Export views not compatible with database version
REMEDY This error occurs during backup from client machine when Oracle version on client machine is higher than oracle version On server machine.
ERROR CODE Export views not installed
REMEDY This error usually occurs at node during backup. To solve this Problem copy oravsn8.dll from server machine from the location Oracle\ora81\bin and paste it to the same location at client Machine.
ERROR CODE ORA-12571 TNS Packet writer failure.
REMEDY This error occurs usually occurs at node because of blocking of Local Area Network. Reinstalling LAN Card may solve this Problem.
ERROR CODE ORA-3113 TNS: End of Communication Channel
REMEDY Check the ping to the server and also check the self ping.
ERROR CODE ORA-01466 Unable to read data- table definition has changed
REMEDY This error usually occurs during backup. To solve this problem Check the system date, it should match current date & time OR If a transaction is in progress then wait until it end then take Backup.
ERROR CODE ORA-01653 Unable to extend table ‘Table_name’ in Tablespace ‘Tablespace Name’
REMEDY Check the free space in the drive where Oracle resides If there is enough free space in disk then add Datafile.