| Database upgrade problem [message #539053] |
Wed, 11 January 2012 03:12  |
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..
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
