OraFAQ Forum: Server Administration » logging to multiple DB on same server

Home » RDBMS Server » Server Administration » logging to multiple DB on same server (ORACLE 11gR2,RHEL 5)

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

logging to multiple DB on same server [message #601362]

Wed, 20 November 2013 01:41

zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan

Junior Member

Sir,

I deployed 2 oracle 11gR2 databases through DBCA on same(single) linux (RHEL 5.4) machine.

Instance 1: PrimaryDB
Instance 2: PrimaryDB1

How i connect to PrimaryDB1?

I passed these parameters
option-1
sqlplus>sys@primarydb1 as sysdba
ORA-01031: insufficiant privileges

option-2
sqlplus>sys/sysdba@primarydb1
ORA-01017: invalid username/password; logon denied

Regards,
Zeeshan DBA

Report message to a moderator

Re: logging to multiple DB on same server [message #601364 is a reply to message #601362]

Wed, 20 November 2013 02:10

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

Please can you show what you are actually doing, using copy/paste and enclosing the copy with tags as described here, How to use [code] tags and make your code easier to read

I know that what you have posted is NOT a copy/paste. If it were, the error would be

sqlplus>
sqlplus>sys@primarydb1 as sysdba
SP2-0734: unknown command beginning "sys@primar..." - rest of line ignored.
sqlplus>
sqlplus>

Report message to a moderator

Re: logging to multiple DB on same server [message #601385 is a reply to message #601362]

Wed, 20 November 2013 07:39

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

zeeshan007 wrote on Wed, 20 November 2013 01:41

Sir,

I deployed 2 oracle 11gR2 databases through DBCA on same(single) linux (RHEL 5.4) machine.

Instance 1: PrimaryDB
Instance 2: PrimaryDB1

How i connect to PrimaryDB1?

I passed these parameters
option-1
sqlplus>sys@primarydb1 as sysdba
ORA-01031: insufficiant privileges

option-2
sqlplus>sys/sysdba@primarydb1
ORA-01017: invalid username/password; logon denied

Regards,
Zeeshan DBA

As John pointed out, your "option-1" does not produce the error message you claim, (neither does 'option-2) so there must be something else going on you haven't shown. Did you transcribe this instead of copying and pasting from the terminal session? And in such transcribing, perhaps leave out the actual sqlplus command ... "connect" ??

For your "option-2", oracle is too dumb to lie about such things. Believe the error message. I seriously doubt that "sysdba" is the password of user SYS.

You might want to check the value of REMOTE_LOGIN_PASSWORD_FILE

Report message to a moderator

Re: logging to multiple DB on same server [message #601387 is a reply to message #601362]

Wed, 20 November 2013 07:42

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

zeeshan007 wrote on Tue, 19 November 2013 23:41

Sir,

I deployed 2 oracle 11gR2 databases through DBCA on same(single) linux (RHEL 5.4) machine.

Instance 1: PrimaryDB
Instance 2: PrimaryDB1

How i connect to PrimaryDB1?

I passed these parameters
option-1
sqlplus>sys@primarydb1 as sysdba
ORA-01031: insufficiant privileges

option-2
sqlplus>sys/sysdba@primarydb1
ORA-01017: invalid username/password; logon denied

Regards,
Zeeshan DBA

SQL*Net (@primarydb1) is NEVER required to connect to any local DB.

export ORACLE_SID=primarydb1
sqlplus
/ as sysdba

above should connect to the desired DB

Report message to a moderator

Re: logging to multiple DB on same server [message #601422 is a reply to message #601387]

Wed, 20 November 2013 14:42

alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California

Senior Member

You left out the work "connect " before the "sys@primarydb1 as sysdba"

Report message to a moderator

Re: logging to multiple DB on same server [message #601423 is a reply to message #601422]

Wed, 20 November 2013 15:39

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

alan.kendall@nfl.com wrote on Wed, 20 November 2013 15:42

You left out the work "connect " before the "sys@primarydb1 as sysdba"

Well...not totally accurate. John pointed out that the whole picture was not there as the error messages could not have been produced by the input. We really don't know if OP typed connect or was just paraphrasing what they think they did.

[Updated on: Wed, 20 November 2013 15:39]

Report message to a moderator

Re: logging to multiple DB on same server [message #601713 is a reply to message #601423]

Sun, 24 November 2013 14:29

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

Sir,

I deployed 2 oracle 11gR2 databases through DBCA on same(single) linux (RHEL 5.4) machine.

Instance 1: PrimaryDB
Instance 2: PrimaryDB1

How i connect to PrimaryDB1?

Use . oraenv utility to login to desired database in same machine.

$ . oraenv
ORACLE_SID = [] ? orcl

[Updated on: Sun, 24 November 2013 14:30]

Report message to a moderator

Re: logging to multiple DB on same server [message #601715 is a reply to message #601713]

Sun, 24 November 2013 14:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>ORACLE_SID = [] ? orcl

I said this FOUR days ago!

Report message to a moderator

Re: logging to multiple DB on same server [message #601716 is a reply to message #601715]

Sun, 24 November 2013 15:17

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,

You are one of the expert in oracle technology in orafaq forum.That everyone in orafaq is pretty aware of it.

I answered Zeeshan question thinking instead of setting export ORACLE_SID and export ORACLE_HOME every time login with different DB, it would be easy for everyone to use . oraenv utility to login to desired DB in same machine.

Now let Zeeshan decides which one he prefers to login to database.I used the term 'oraenv' since Zeeshan is using multiple databases in same machine.

I hope i am not wrong

Thanks

[Updated on: Sun, 24 November 2013 15:17]

Report message to a moderator

Previous Topic:	Oracle Client 11.2.0.3 not working
Next Topic:	Database not working when network is offline

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:32:56 CST 2024