Home » SQL & PL/SQL » SQL & PL/SQL » idle instance with / but working instance with full string
idle instance with / but working instance with full string [message #249619] Thu, 05 July 2007 03:59 Go to next message
dreimon
Messages: 1
Registered: July 2007
Junior Member
With Oracle 10g RAC.
When I try to connect using:
sqlplus / as sysdba

I always get:
Connected to an idle instance.

But if i use all the conection string:

sqlplus sys/pepito@pepito as sysdba
I get:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL>

I also can connect to:
sqlplus sys/pepito@pepito1 as sysdba and
sqlplus sys/pepito@pepito2 as sysdba


So the database is up and running.

My env is:
ORA_ASM_HOME=/oracle/asm/asm10.2
ORACLE_SID=pepito1
ORACLE_BASE=/oracle
ORACLE_HOME=/oracle/pepito/bd10.2

The same with rman
rman target / catalog rman/rman@catalogrman fails to connect
with
rman target sys/pepito@pepito catalog rman/rman@catalogrman
rman target sys/pepito@pepito1 catalog rman/rman@catalogrman
rman target sys/pepito@pepito2 catalog rman/rman@catalogrman
I can connect without problems.

What i'm missing?
What is the definition of "/"
Re: idle instance with / but working instance with full string [message #249629 is a reply to message #249619] Thu, 05 July 2007 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What i'm missing?

You are not trying to connect to the same database.

Quote:
What is the definition of "/"

Current user if SQL*Plus or SYSDBA if RMAN. In both case, it means LOCAL database.

Regards
Michel

[Updated on: Thu, 05 July 2007 06:33]

Report message to a moderator

Re: idle instance with / but working instance with full string [message #249676 is a reply to message #249619] Thu, 05 July 2007 09:34 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Better change your password now!
Re: idle instance with / but working instance with full string [message #249690 is a reply to message #249676] Thu, 05 July 2007 09:58 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Previous Topic: View
Next Topic: Search Result Page query
Goto Forum:
  


Current Time: Sat Dec 10 16:53:52 CST 2016

Total time taken to generate the page: 0.05229 seconds