 ORA-01033 [message #109869] |
Tue, 01 March 2005 10:09  |
TramSA
Messages: 1
Registered: March 2005
Location: Greece
|
Junior Member |
|
|
Hello,
When ORACLE instance starts, I get an ORA-01033 error and a message that data file 6 is corrupted. The service is started and the database is mounted as well but I cannot open it.
When I try to connect as sysdba I get ORA-12560 error (TNS protocol adapter error). I have checked the TNSNAME.ORA file and changed the port but nothin happens.
Can u help PLEASE????
Thank U.
|
|
|
|
| Re: ORA-01033 [message #109874 is a reply to message #109869] |
Tue, 01 March 2005 10:32  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
Try to connect locally without going through SQL*Net (without specifying the @descriptor part).
Windows/NT example:
1. set ORACLE_SID=orcl
2. sqlplus "sys/oracle as sysdba"
If you still get errors, check the following:
1. Verify that the instance is running
2. Ensure your user belong to the ORA_DBA group
3. Set "sqlnet.authentication_services=NTS" in sqlnet.ora
4. Set "remote_login_passwordfile=exclusive" in your INIT.ORA file
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
