OraFAQ Forum: Networking and Gateways » Oracle Net & Failsafe on Oracle 10G MS clusters

Home » RDBMS Server » Networking and Gateways » Oracle Net & Failsafe on Oracle 10G MS clusters

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

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!

Report message to a moderator

Re: Oracle Net & Failsafe on Oracle 10G MS clusters [message #168329 is a reply to message #168094]

Wed, 19 April 2006 15:25

markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada

Senior Member

Load balansing?
If one time it connects, another does not, may it is MS Cluster NLB does not switch properly?

PS/ there is no difference, do you use cmd line sqlplus or gui sqlplusw, or ODBC/OLEDB or .NET. All work via oracle client dlls the same way.

[Updated on: Wed, 19 April 2006 15:26]

Report message to a moderator

Re: Oracle Net & Failsafe on Oracle 10G MS clusters [message #168333 is a reply to message #168329]

Wed, 19 April 2006 16:13

matthews
Messages: 4
Registered: April 2006

Junior Member

It is not an intermitent problem. It never works in the manner I mentioned.

The listener IP used is the Cluster Group IP.

Do I have any hope for resolving the issue.

Report message to a moderator

Re: Oracle Net & Failsafe on Oracle 10G MS clusters [message #168341 is a reply to message #168333]

Wed, 19 April 2006 20:47

markmal
Messages: 113
Registered: April 2006
Location: Toronto, Canada

Senior Member

questions
1. what is your oracle version?
2. what is "windows" SQLPLUS icon/menu points to?
3. how many oracle homes do you have?
4. is env variable ORACLE_HOME set in SYstem Control Panel?
5. Show here your PATH variable.

Report message to a moderator

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,

Report message to a moderator

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

Previous Topic:	Connection problem
Next Topic:	ora 12560

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:38:42 CDT 2025