OraFAQ Forum: Security » Connect sys@my_tns as sysdba, fail (ora-1031)

Home » RDBMS Server » Security » Connect sys@my_tns as sysdba, fail (ora-1031) (Database 11g E/E Rel-11.1.0.6.0 - 64bit for Linux)

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

Connect sys@my_tns as sysdba, fail (ora-1031) [message #412720]

Fri, 10 July 2009 15:11

unixwrld
Messages: 3
Registered: July 2009
Location: Argentina

Junior Member

I'm learning to create one database manually, through console by using sqlplus program.
I have created the database, listener entry and tnsnames entry.
I can connect with system user using follow statement:
connect system/manager@my_tns -- It work fine.
But I try do that same with sys user, and it don't work:
connect sys/change_on_install@my_tns as sysdba -- This same instruction work with one database created by wizard (dbca program).
How I can do to work fine, too?

PS: Sorry, my grammar is very bad!

Report message to a moderator

Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412722 is a reply to message #412720]

Fri, 10 July 2009 15:15

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

sqlplus
/ as sysdba
select * from v$version
exit

CUT lines above & PASTE into command window

CUT & PASTE commands & results back here.

Report message to a moderator

Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412740 is a reply to message #412720]

Sat, 11 July 2009 00:32

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It is a FAQ.
Please search BEFORE posting.
Please read Database Concepts there are full of stuffs on authentication and autorization. Read about password file...

Regards
Michel

Report message to a moderator

Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412914 is a reply to message #412722]

Mon, 13 July 2009 06:53

unixwrld
Messages: 3
Registered: July 2009
Location: Argentina

Junior Member

This is my oracle version:

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Linux: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

thanks

Report message to a moderator

Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412936 is a reply to message #412914]

Mon, 13 July 2009 08:11

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This does not change my answer just the link.

Regards
Michel

Report message to a moderator

Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412938 is a reply to message #412740]

Mon, 13 July 2009 08:20

unixwrld
Messages: 3
Registered: July 2009
Location: Argentina

Junior Member

You're right!!!
I'm a beginning, and I'm learning!
I haven't got password file created. Wizard builded it for my other database instances, and I didn't know.
I have created password file through orapwd, and it work fine, now!

NOTE: "Without password file, non priviliged users YES can connect through TNS, but not SYS."

Thank you for help me!

Regards

Report message to a moderator

Previous Topic:	user authentication while using database link
Next Topic:	How i can prevent login as os authintication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 10:22:48 CDT 2025