| Unable to connect as sysdba [message #152538] |
Fri, 23 December 2005 13:51  |
vang
Messages: 8
Registered: October 2005
|
Junior Member |
|
|
Received error: ORA-01033: ORACLE initializaton or shutdown in process
Trying to recover the database by shutting down and recover datafile. As a result, trying to log onto Database (sqlplus) but cannot.
I have attempted to log on using "connect /as sysdba" and "connect system/manger as sysdba" but am getting ora-01031: insufficient priviledge"
Any suggestion on how to shutdown database and startup - or in the event of a datafile recovery?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Unable to connect as sysdba [message #153096 is a reply to message #152538] |
Thu, 29 December 2005 00:59  |
wwllzpz
Messages: 11
Registered: December 2005
Location: shanghai china
|
Junior Member |
|
|
| vang wrote on Sat, 24 December 2005 03:51 |
Received error: ORA-01033: ORACLE initializaton or shutdown in process
Trying to recover the database by shutting down and recover datafile. As a result, trying to log onto Database (sqlplus) but cannot.
I have attempted to log on using "connect /as sysdba" and "connect system/manger as sysdba" but am getting ora-01031: insufficient priviledge"
Any suggestion on how to shutdown database and startup - or in the event of a datafile recovery?
|
maybe the following article can resolve your problem.
书签 转到末尾
文档 ID: 注释:69642.1
主题: UNIX: Checklist for Resolving Connect AS SYSDBA Issues
类型: TROUBLESHOOTING
状态: PUBLISHED
内容类型: TEXT/X-HTML
创建日期: 20-APR-1999
上次修订日期: 07-JUL-2005
[Edit: Metalink bulletins are copyrighted material by Oracle. You may not publish them freely on the web. Removed contents of bulletin 69642.1]
[Updated on: Thu, 29 December 2005 01:13] by Moderator Report message to a moderator |
|
|
|
| Re: Unable to connect as sysdba [message #153426 is a reply to message #153096] |
Mon, 02 January 2006 04:48 |
matrik02
Messages: 64
Registered: November 2005
|
Member |
|
|
Try connect the database using default password and username
Username : scott
password : tiger
host string : <your database instance >
Then after you succesfull connect the default password and username,then try connect with this command
SQLPLUS> connect system/manger as sysdba
or SQLPLUS> connect sys/change_on_install as sysdba
make sure that you have the valid password.The example i give you is a default password for sys and system user.
Thanks hope it help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
