Operating System - HP-UX
1748223 Members
4943 Online
108759 Solutions
New Discussion юеВ

Re: sqlplus system/manager

 
SOLVED
Go to solution
Enrico Venturi
Super Advisor

sqlplus system/manager

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?
8 REPLIES 8
Joseph Loo
Honored Contributor

Re: sqlplus system/manager

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.
what you do not see does not mean you should not believe
Nicolas Dumeige
Esteemed Contributor

Re: sqlplus system/manager

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
All different, all Unix
Eric Antunes
Honored Contributor

Re: sqlplus system/manager

Try:

On Unix:

$sqlplus '/ as sysdba';

On Win:

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

Are you using password files?
Each and every day is a good day to learn.
Sanjay Kumar Suri
Honored Contributor

Re: sqlplus system/manager

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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Yogeeraj_1
Honored Contributor
Solution

Re: sqlplus system/manager

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Joseph Loo
Honored Contributor

Re: sqlplus system/manager

hi,

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

regards.
what you do not see does not mean you should not believe
Eric Antunes
Honored Contributor

Re: sqlplus system/manager

Is there any reason for the blank pwd for system? I think it should be set...
Each and every day is a good day to learn.
Enrico Venturi
Super Advisor

Re: sqlplus system/manager

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