 Oracle Net & Failsafe on Oracle 10G MS clusters [message #168094] |
Tue, 18 April 2006 14:42  |
matthews
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
I have failsafe implemented on a MS-Cluster of 2 Oracle-DB servers running Oracle 10G.
I have tried to login to the SQLPLUS thro windows programs and it fails with error ORA-12154.
However what I tried later was thro the command windows as
"sqplus system/manager @connect_string as sysdba" it works fine and I am able to access the DB.
Could you let me know what is the reason for this error and how can I rectify it.
Thanks in Advance!
|
|
|
|
|
|
|
|
|
|
| Re: Oracle Net & Failsafe on Oracle 10G MS clusters [message #168719 is a reply to message #168329] |
Fri, 21 April 2006 15:20  |
matthews
Messages: 4
Registered: April 2006
|
Junior Member |
|
|
In fact this is my first exposure to windows 2003 clusters with oracle 10G failsafe.
I have mostly worked only on single oracle servers running 9i / 8i.
I understand that there is a virtual listener address which the Failsafe uses.
I know that listner works because there is a critical 24x7 application running thro it. I am worried to mess things there by experimenting on it.
As I told you I am able to logon to sqlplus/sqlplusw using sys as sysdba. but not a normal user.
What could be the issue.
do you think I need to create a windows user for OEM called system/sys. I dont think I am using the Active Directory for oracle net services. How can I be sure of that ?
Thanks a ton for your responses
Thanks and regards,
|
|
|
|
| Re: Oracle Net & Failsafe on Oracle 10G MS clusters [message #168723 is a reply to message #168719] |
Fri, 21 April 2006 16:16 |
markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada
|
Senior Member |
|
|
| matthews wrote on Fri, 21 April 2006 16:20 |
...
As I told you I am able to logon to sqlplus/sqlplusw using sys as sysdba. but not a normal user.
|
1. could you show how did you try to connect and the error?
sqplus "system/manager@connect_string as sysdba"
sqplus system/manager@connect_string
2. what is connect_string from tnsnames.ora ?
3. what you have in sqlnet.ora ?
4. do you connect from server or from another machine?
5. do you have one or several oracle homes on the machine where you connect from?
| matthews wrote on Fri, 21 April 2006 16:20 |
do you think I need to create a windows user for OEM called system/sys. I dont think I am using the Active Directory for oracle net services. How can I be sure of that ?
|
You do not need to create system/sys in Windows.
I am not sure about AD.
[Updated on: Fri, 21 April 2006 16:16] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
