Listener port number

725039

>
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 2 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
>

Which SID are you trying to connect to? Is it testdb or orcl?


>
orcl:/glods1/oracle11g/app/oracle/product/11.1.0/db_1:N
testdb:/glods1/oracle11g/app/oracle/product/11.1.0/db_1:N
>

Looks to me like you have two Oracle Databases installed. If you would like to user testdb, you are going to have to start it up first.

Regards,
Phiri

Hans Forbrich

phiri wrote:
Looks to me like you have two Oracle Databases installed. If you would like to user testdb, you are going to have to start it up first.

Or at least set the ORACLE_SID and ORACLE_HOME properly before starting 'sqlplus / as sysdba'

Which is why I asked for 'set | grep -i ora' earlier. ;-)

725039

>
Which is why I asked for 'set | grep -i ora' earlier.
>

Yes indeed.

Regards,
Phiri

KSG

I set it manually

echo $ORACLE_HOME
/glods1/oracle11g/app/oracle/product/11.1.0/db_1

echo $PATH
/glods1/oracle11g/app/oracle/product/11.1.0/db_1/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/glods1/oracle/bin:/usr/bin/X11:/sbin:.

echo $ORACLE_SID
testdb

sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 16 18:44:30 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified



sqlplus "sys/[email protected] as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 16 18:44:58 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name:

Still it's not getting connected. Please read my first post, in listener.log file... testdb port no is pointing to different at different time... I think there is block in the port... If the server is rebooted then there is no problem the connectivity...
Please help me to investigate further..

Thanks
KSG

Edited by: KSG on Apr 16, 2010 6:53 PM (typo)

725039

>
Still it's not getting connected. Please read my first post, in listener.log file... testdb port no is pointing to different at different time... I think there is block in the port... If the server is rebooted then there is no problem the connectivity...
Please help me to investigate further..
>

start your database.

sqlplus /nolog

startup

Regards,
Phiri

KSG

sqlplus /nolog

SQL*Plus: Release 11.1.0.6.0 - Production on Fri Apr 16 19:09:11 2010

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL> startup
ORA-12154: TNS:could not resolve the connect identifier specified
SQL>

725039

>
orcl:/glods1/oracle11g/app/oracle/product/11.1.0/db_1:N
testdb:/glods1/oracle11g/app/oracle/product/11.1.0/db_1:N
>

What is the SID of your database? Looks to me like you have orcl and testdb pointing to the same ORACLE_HOME.

How many times have you installed Oracle Database on your machine?

Regards,
Phiri

Edited by: phiri on 16-Apr-2010 15:49

KSG

Yes Phiri... There are two databases running in the server with same oracle home.

I can able to connect to orcl database

But, I cant able to connect to testdb database. Which I have posted in my earlier postings..

Thanks
KSG

725039

>
Yes Phiri... There are two databases running in the server with same oracle home.

I can able to connect to orcl database

But, I cant able to connect to testdb database. Which I have posted in my earlier postings..
>

Two instances, not databases, you can only have one database software installation in an Oracle Home

Very well then; do the following and let us know what happens.

. oraenv

The when prompted for SID, use testdb.

Regards,
Phiri

Edited by: phiri on 16-Apr-2010 16:32

KSG

The same result... Not connecting...

I suspect port level issue...

Thanks a ton
KSG