Home » RDBMS Server » Server Administration » logging to multiple DB on same server (ORACLE 11gR2,RHEL 5)
logging to multiple DB on same server [message #601362] Wed, 20 November 2013 01:41 Go to next message
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


Re: logging to multiple DB on same server [message #601364 is a reply to message #601362] Wed, 20 November 2013 02:10 Go to previous messageGo to next message
John Watson
Messages: 4082
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>
Re: logging to multiple DB on same server [message #601385 is a reply to message #601362] Wed, 20 November 2013 07:39 Go to previous messageGo to next message
EdStevens
Messages: 132
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
Re: logging to multiple DB on same server [message #601387 is a reply to message #601362] Wed, 20 November 2013 07:42 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
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
Re: logging to multiple DB on same server [message #601422 is a reply to message #601387] Wed, 20 November 2013 14:42 Go to previous messageGo to next message
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"
Re: logging to multiple DB on same server [message #601423 is a reply to message #601422] Wed, 20 November 2013 15:39 Go to previous messageGo to next message
joy_division
Messages: 4454
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 Go to previous messageGo to next message
Jack14
Messages: 453
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 Go to previous messageGo to next message
BlackSwan
Messages: 21949
Registered: January 2009
Senior Member
>ORACLE_SID = [] ? orcl

I said this FOUR days ago!
Re: logging to multiple DB on same server [message #601716 is a reply to message #601715] Sun, 24 November 2013 15:17 Go to previous message
Jack14
Messages: 453
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:
  


Current Time: Sun Apr 20 00:10:29 CDT 2014

Total time taken to generate the page: 0.10021 seconds