sqlplus system/manager

[Enrico Venturi]

Hello colleagues,
I try to connect ORACLE by sqlplus as system/manager, it's ok

I repeat the attempt on another system (maybe configured in another way) but it fails there

The databases are created in the same way, no password is provided for the system user

In the second case the error is:

ERROR: ORA-01034 ORACLE non available


If I repeat the command on the 2nd machine by using the "non admnistrator" user / password then it works fine

Where do I have to look for differences between the two systems?
What's the possible problem?

[Joseph Loo]

hi,

r these your steps:

oracle $ export ORACLE_SID=
oracle $ sqlplus "/ as sysdba"

SQL> start
SGA info
Database mounted

also, please:

oracle $ ps -ef|grep pmon
any of the instance running.

regards.

[Nicolas Dumeige]

Hello,

Do you provide the SID when logging or do you rely on the ORACLE_SID variable ? This is a possible source of error.
You could also log as the normal user, then try :
connect system/manager
and see if it's work then.

Cheers

Nicolas

[Eric Antunes]

Try:

On Unix:

$sqlplus '/ as sysdba';

On Win:

connect as "non administrator" and after that:
conn / as sysdba;

Are you using password files?

[Sanjay Kumar Suri]

Oracle offers following explanation for this error:

01034, 00000, "ORACLE not available"
// *Cause: Oracle was not started up. Possible causes include the following:
//The SGA requires more space than was allocated for it.
//The operating-system variable pointing to the instance is improperly defined.

// *Action: Refer to accompanying messages for possible causes and correct the problem mentioned in the other messages. If Oracle has been initialized, then on some operating systems, verify that Oracle was linked correctly. See the platform specific Oracle documentation.

Also check Alert_SID.log file for this instance for any clues.

sks

[Yogeeraj_1 · Accepted solution]

hi,

can you check if you can connect using a similar connection string:
connect system/manager@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=)))

this can help us in understanding what is reall happening.

regards
yogeeraj

[Joseph Loo]

hi,

may i know if your problem has been solve? if it has, which solution help?

regards.

[Eric Antunes]

Is there any reason for the blank pwd for system? I think it should be set...

[Enrico Venturi]

Thanks to Yogeeraj
the problem has been solved by using
sqlplus system/manager@@(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP )(HOST = albh16 )(PORT = 1521))(CONNECT_DATA =(SID = dbsyml))

i.e. the full connection string

Thanks again