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)
Connect sys@my_tns as sysdba, fail (ora-1031) [message #412720] Fri, 10 July 2009 15:11 Go to next message
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!
Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412722 is a reply to message #412720] Fri, 10 July 2009 15:15 Go to previous messageGo to next message
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.
Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412740 is a reply to message #412720] Sat, 11 July 2009 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412914 is a reply to message #412722] Mon, 13 July 2009 06:53 Go to previous messageGo to next message
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
Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412936 is a reply to message #412914] Mon, 13 July 2009 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This does not change my answer just the link.

Regards
Michel
Re: Connect sys@my_tns as sysdba, fail (ora-1031) [message #412938 is a reply to message #412740] Mon, 13 July 2009 08:20 Go to previous message
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
Previous Topic: user authentication while using database link
Next Topic: How i can prevent login as os authintication
Goto Forum:
  


Current Time: Thu Mar 28 23:45:08 CDT 2024