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.