Home » RDBMS Server » Server Administration » Connectiong as sysdba
Connectiong as sysdba [message #248798] Mon, 02 July 2007 01:03 Go to next message
Binils
Messages: 2
Registered: July 2007
Junior Member
Hello Friends,
I have a production server running on windows2000 server with 9i
Its running for the last one year smoothly..

Suddenlty I found that I am unable to login as sys.
1)
SQL> connect sys/<password> as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
2)
SQL> connect sys/ as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges

No body has changed password. I tried setting the password by logging in as system from EM, Its been able to set but still cannot login.

Currently unable to login as sysdba. I am suppose to login as sysdba using any user from the server because of Login user authentication. It is the same user<Administrator> who is in ORA_DBA group. How can I solve it .

any ideas will be helpfull ....Please help me.
Regards,
Re: Connectiong as sysdba [message #248901 is a reply to message #248798] Mon, 02 July 2007 11:02 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
WHATS THE VALUE OF THIS PARAMETER IN SQLNET.ORA

#sqlnet.authentication_services = ????
Re: Connectiong as sysdba [message #248957 is a reply to message #248798] Mon, 02 July 2007 22:41 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Use
>connect / as sysdba
Re: Connectiong as sysdba [message #248971 is a reply to message #248798] Tue, 03 July 2007 00:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
YOu should RECREATE your PASSWORD file.
through ORAPWD utility.


Regards
Taj
Re: Connectiong as sysdba [message #249268 is a reply to message #248798] Tue, 03 July 2007 20:04 Go to previous messageGo to next message
Binils
Messages: 2
Registered: July 2007
Junior Member
Thanks for the helps,

1)
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

2)
#sqlnet.authentication_services = ????

>>>SQLNET.AUTHENTICATION_SERVICES= (NTS)
Inside the file E:\oracle\ora92\network\admin\sqlnet.ora

3) What is the risk of creating password file ?
I have password file exists in E:\oracle\ora92\database\PWDora816.ora

I need to create new one or over write it ?
Its bit confusing ........

Thanks & Regards
Re: Connectiong as sysdba [message #249296 is a reply to message #249268] Wed, 04 July 2007 00:27 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

I need to create new one or over write it ?
Its bit confusing ........

You should recreate your password.
No risk...
Must use "FORCE=Y" Keyword with create password file statements.


ORAPWD FILE=$ORACLE_HOME/DBS/PWD<SID>.ORA PASSWORD=PWD ENTRIES=XXX FORCE=Y

REGARDS
taj
Previous Topic: insufficient privs at database creation time
Next Topic: Data Cache
Goto Forum:
  


Current Time: Tue Dec 03 08:27:02 CST 2024