|
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. |
|
|
|