Forum Stats

  • 3,825,157 Users
  • 2,260,473 Discussions
  • 7,896,430 Comments

Discussions

Listener port number

24

Answers

  • 725039
    725039 Member Posts: 637
    >
    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
    Hans Forbrich Member Posts: 11,543 Gold Trophy
    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
    725039 Member Posts: 637
    >
    Which is why I asked for 'set | grep -i ora' earlier.
    >

    Yes indeed. :)

    Regards,
    Phiri
  • KSG
    KSG Member Posts: 802
    edited Apr 16, 2010 9:24AM
    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
    725039 Member Posts: 637
    >
    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
    KSG Member Posts: 802
    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
    725039 Member Posts: 637
    edited Apr 16, 2010 9:49AM
    >
    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
    KSG Member Posts: 802
    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
    725039 Member Posts: 637
    edited Apr 16, 2010 10:36AM
    >
    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
    KSG Member Posts: 802
    The same result... Not connecting...

    I suspect port level issue...

    Thanks a ton
    KSG
This discussion has been closed.