Unable to Connect to DB

[mrvajrala]

Hello All,
I am having a database running on UNIX, when I am trying to do SVRMGRL , i couldnt connect , it is saying me that ORACLE is not available , I have changed the ORACLE_SID to 'PROD' , i did see that through $echo ORACLE_SID... ( PROD is the database, which is running on this UNIX machine )
and everything seems to be alright , but I am unable to connect , but the datbase is running.

Anybody have some voice ????

[magskn]

Is your oracle home set correctly and your other environment variables?

[mallard]

Is your listener up and running?

[mrvajrala]

Listener is running
exported the ORACLE_HOME to a right path and ORACLE_SID
to PROD, the database to which i would like to talk to

But still unable to connect , any idea ???

[SANJAY_G]

Are you able to get into svrmgrl prompt? Post the error meassage you get when you issue connect.

Sanjay

[NDT]

Originally posted by mrvajrala
Listener is running
exported the ORACLE_HOME to a right path and ORACLE_SID
to PROD, the database to which i would like to talk to

But still unable to connect , any idea ???

try tnsping PROD to verify the database is running if you can't then you should look at the entries in TNSNAMES.ORA file or maybe your listener use the wrong tnsnames.ora file

[anandkl]

are u able to connect to svrmgrl as internal...

[mrvajrala]

ps -ef | grep ora_smon | grep -v grep
Gives me oracle 1034 1 0 Feb 14 ? 1:35 ora_smon_prod

echo $ORACLE_SID
gives me DFLT

echo $ORACLE_HOME
/db01/app/oracle/product/8.1.7 ( Actual Home )

lsnrctl status
prod has 1 service handler(s)

did the following

export ORACLE_SID=PROD
echo $ORACLE_SID
PROD

tnsping PROD

TNS Ping Utility for Solaris: Version 8.1.7.2.0 - Production on 19-FEB-2002 09:15:00

(c) Copyright 1997 Oracle Corporation. All rights reserved.

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=aauxci03)(PORT=1521))
OK (10 msec)


aauxci03:/db01/app/oracle> svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production
With the Partitioning option
JServer Release 8.1.7.2.0 - Production

SVRMGR> connect internal;
Connected.
SVRMGR> select * from v$database;
select * from v$database
*
ORA-01034: ORACLE not available
SVRMGR>



I think I have tried to answer all of the above questions, and you can see the ERROR, which i am getting in the process.

Everything is alright , but i am unable to connect to database,
would anybody help me to connect to my puppy???

Thanks,
Madhu

[aarroyob]

echo $ORACLE_SID
gives me DFLT

The database running is not prod it is DFLT :-)

Maybe if you startup the prod database ...

Regards

Angel

[Tarry]

I have nil exp in unix, but i think .....
1. your instance is in nomount stage
or
2. your db creation script didin't have the catalog.sql or catproc.sql.. the data dictionary views....

cheers...

tarry