Forum Stats

  • 3,826,113 Users
  • 2,260,598 Discussions
  • 7,896,790 Comments

Discussions

Listener port number

124»

Answers

  • 725039
    725039 Member Posts: 637
    edited Apr 18, 2010 2:06AM
    >
    Phiri... testdb and orcl were working fine even when TWO_TASK was set earlier. This server works fine after every restart... but after a few days the problem araises... I suspect that port is keep on increasing the value when reaches threshold the connection cant able establish. Please look at the log file in the first post. I feel some thing is terribly wrong with the setting.
    >

    So I did not see this post; did you finally manage to resolve this?

    >
    16-APR-2010 13:00:56 * (CONNECT_DATA=(SERVICE_NAME=testdb)(CID=([email protected])(HOST=integ)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.92.5.37)*(PORT=34487))* * establish * testdb * 12514
    TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

    TESTDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = integ)(PORT = 1522))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = testdb)
    )
    )

    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

    >

    That error will continue as long as you do not have testdb being listened to by your listener.

    Regards,
    Phiri
  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    khaja(DBA) wrote:
    Hey DBA84,

    He is trying to connect the database locally.Then no concerned with listener here.

    Even if the listener is down also,he can able to connect to the database.

    Listener comes into picture when you are connecting remotely.
    Listener CAN com into the picture on the same server:
    sqlplus /  
    sqlplus / as sysdba
    sqlplus scott/tiger
    will use bequeath connections and not require the listener
    sqlplus scott/[email protected]
    will use the listener, whether local or remote.

    KSG:set the oracle_sid & try to connect.


    Regards,
    khaja
  • EdStevens
    EdStevens Member Posts: 28,778 Gold Crown
    phiri wrote:
    >
    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
    BZZZT! Wrong answer!

    You can very well have two databases with a single oracle home. And along with those two databases, you'd have two instances.

    Instance and database are not the same thing. An instance is the memory and processes. The database is the files. The distinction becomes clear when you start dealing with RAC: 1 database, multiple instances managing that database.
    >
    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
  • 725039
    725039 Member Posts: 637
    Yes indeed Ed, thanks for spotting that one as well; Hans actually corrected me.

    >
    sqlplus /
    sqlplus / as sysdba
    sqlplus scott/tiger
    >

    The above were all making use of the listener because the OP had TWO_TASK variable set.

    Regards,
    Phiri
This discussion has been closed.