| 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. If still error persists recreate all the indexes on the
table(s). |
| 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. |
| ERROR
CODE |
ORA-00600 Internal error
code, arguments: [string], [string], [string], [string],
[string],
[string], [string], [string] OR
ORA-01578 ORACLE data block corrupted (file #
string, block # string) |
| REMEDY
|
Run Utilcap.exe and re-index of the tables which are
involved in the operation that caused this error. If
still problem persists contact Shilpi Support Office. |
| ERROR
CODE |
ORA-01652 Unable to extend
temp segment in tablespace 'SYSTEM' or 'TEMP' |
| REMEDY
|
First check the free space in the
drive where oracle is installed at server. There will be
sufficient hardisk free space. If it is not then create
free space in that If still problem persists then add
datafile to the tablespace indicated. |
| |
|
