OraFAQ Forum: Server Administration » Connectiong as sysdba

Home » RDBMS Server » Server Administration » Connectiong as sysdba

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connectiong as sysdba [message #248798]

Mon, 02 July 2007 01:03

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,

Report message to a moderator

Re: Connectiong as sysdba [message #248901 is a reply to message #248798]

Mon, 02 July 2007 11:02

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

WHATS THE VALUE OF THIS PARAMETER IN SQLNET.ORA

#sqlnet.authentication_services = ????

Report message to a moderator

Re: Connectiong as sysdba [message #248957 is a reply to message #248798]

Mon, 02 July 2007 22:41

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Use

>connect / as sysdba

Report message to a moderator

Re: Connectiong as sysdba [message #248971 is a reply to message #248798]

Tue, 03 July 2007 00:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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

Regards
Taj

Report message to a moderator

Re: Connectiong as sysdba [message #249268 is a reply to message #248798]

Tue, 03 July 2007 20:04

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

Report message to a moderator

Re: Connectiong as sysdba [message #249296 is a reply to message #249268]

Wed, 04 July 2007 00:27

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

Report message to a moderator

Previous Topic:	insufficient privs at database creation time
Next Topic:	Data Cache

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 09:25:48 CST 2024