Home » RDBMS Server » Backup & Recovery » ORA-01033
icon9.gif  ORA-01033 [message #109869] Tue, 01 March 2005 10:09 Go to next message
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 Go to previous message
Frank Naude
Messages: 4579
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

Previous Topic: Get an EXP-00024 error while running exp script
Next Topic: 9i Recover database with redo log files
Goto Forum:
  


Current Time: Thu Mar 28 04:51:41 CDT 2024