Home » RDBMS Server » Server Administration » Database upgrade problem
Database upgrade problem [message #539053] Wed, 11 January 2012 03:12 Go to next message
morad_dba
Messages: 93
Registered: June 2008
Member

Dear all,

I have a database in Linux 5.3 in oracle database 10g. I Just remove oracle software (not database) after shutting down database.

I installed the oracle 10g software again and tried to start the database..

After mounting database...It says that .. Database must be started in upgrade mode..

Then I startd database issuing the command..

startup upgrade

Now database has been started in upgrade mode.

When I tried to connect to Database using schema name and password

It returns errors like

SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 1.0737E+10 bytes
Fixed Size 2038592 bytes
Variable Size 1593836736 bytes
Database Buffers 9126805504 bytes
Redo Buffers 14737408 bytes
Database mounted.
Database opened.
SQL> conn t24/t24
ERROR:
ORA-39710: only connect AS SYSDBA is allowed when OPEN in UPGRADE mode


Warning: You are no longer connected to ORACLE.


Now how can i connect to database using my schema name and password..

Thanks..



Re: Database upgrade problem [message #539057 is a reply to message #539053] Wed, 11 January 2012 03:24 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restart in normal mode (not upgrade one).
Why did you start with "upgrade" option?

Regards
Michel
Previous Topic: ORA-06544: PL/SQL: internal error, arguments: [ph2_cly out of bounds in PH2POP.], [0], [1240], [], [
Next Topic: ORA-39726: unsupported add/drop column operation on compressed tables
Goto Forum:
  


Current Time: Fri Mar 29 06:13:16 CDT 2024