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!
|
|
|
|
|
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
|
|
|
|
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
|
|
|