Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

startup upgrade

user587133Mar 9 2010 — edited Mar 9 2010
Hi I have applied fixpack 10.2.0.4 to 10.2.0.1 database .

while tying to start database it shows the following error.
error log file showed to startup in upgrade process .
Now when i startup in upgrade pocess i am able to connect only using sys user but not other users .


SQL> startup
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1298160 bytes
Variable Size 171966736 bytes
Database Buffers 432013312 bytes
Redo Buffers 7090176 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 612368384 bytes
Fixed Size 1298160 bytes
Variable Size 171966736 bytes
Database Buffers 432013312 bytes
Redo Buffers 7090176 bytes
Database mounted.
Database opened.



SQL> conn scott/tiger
ERROR:
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilege


Warning: You are no longer connected to ORACLE.
SQL>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2010
Added on Mar 9 2010
5 comments
2,367 views