topic Re: sqlplus system/manager in Operating System - HP-UX

sqlplus system/manager

Enrico Venturi — Tue, 01 Jun 2004 02:54:46 GMT

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?

Re: sqlplus system/manager

Joseph Loo — Tue, 01 Jun 2004 03:02:41 GMT

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.

Re: sqlplus system/manager

Nicolas Dumeige — Tue, 01 Jun 2004 03:17:48 GMT

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

Re: sqlplus system/manager

Eric Antunes — Tue, 01 Jun 2004 03:23:18 GMT

Try:

On Unix:

$sqlplus '/ as sysdba';

On Win:

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

Are you using password files?

Re: sqlplus system/manager

Sanjay Kumar Suri — Tue, 01 Jun 2004 03:27:22 GMT

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

Re: sqlplus system/manager

Yogeeraj_1 — Tue, 01 Jun 2004 03:33:19 GMT

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

Re: sqlplus system/manager

Joseph Loo — Tue, 01 Jun 2004 04:11:28 GMT

hi,

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

regards.

Re: sqlplus system/manager

Eric Antunes — Tue, 01 Jun 2004 04:25:53 GMT

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

Re: sqlplus system/manager

Enrico Venturi — Tue, 01 Jun 2004 04:27:58 GMT

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