Multiple Instances .. Listener Problem - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 27 of 27

Thread: Multiple Instances .. Listener Problem

  1. #21
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Do the following on the server...

    1. login into insa database

    select * from v$database;

    select * from v$instance;

    2. login into insb database

    select * from v$database;

    select * from v$instance;

    Paste the result of the above here.

    HTHU.

  2. #22
    Join Date
    Jan 2002
    Posts
    78
    [oracle@ciberdb oracle]$ env | grep ORACLE_SID
    ORACLE_SID=insa
    [oracle@ciberdb oracle]$ sqlplus system/ora987

    SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 03:43:42 2003

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


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    SQL> select * from v$database;

    DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
    ---------- --------- --------- ----------------- ---------
    PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
    ----------------------- --------- ------------ ------------------
    ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
    --------------- ------- --------- --------------------- -------------------
    CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE
    --------- ----------- --------- ----------
    2935114683 INSA 17-APR-03 1 17-APR-03
    0 NOARCHIVELOG 344217
    343372 CURRENT 17-APR-03 29883 344217
    23-APR-03 NOT ALLOWED 17-APR-03 READ WRITE


    SQL> select * from v$instance;

    INSTANCE_NUMBER INSTANCE_NAME
    --------------- ----------------
    HOST_NAME
    ----------------------------------------------------------------
    VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
    ----------------- --------- ------- --- ---------- ------- -----------
    LOGINS SHU DATABASE_STATUS INSTANCE_ROLE
    ---------- --- ----------------- ------------------
    1 insa
    mydb
    8.1.6.1.0 23-APR-03 OPEN NO 1 STOPPED
    ALLOWED NO ACTIVE PRIMARY_INSTANCE

    [oracle@ciberdb oracle]$ ORACLE_SID=insb;export ORACLE_SID
    [oracle@ciberdb oracle]$ env | grep ORACLE_SID
    ORACLE_SID=insb
    [oracle@ciberdb oracle]$ sqlplus system/manager

    SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 03:45:58 2003

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


    Connected to:
    Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production

    SQL> select * from v$database;

    DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
    ---------- --------- --------- ----------------- ---------
    PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#

    ----------------------- --------- ------------ ------------------
    ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
    --------------- ------- --------- --------------------- -------------------
    CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE
    --------- ----------- --------- ----------
    1910859409 INSB 21-APR-03 1 21-APR-03
    0 NOARCHIVELOG 191431
    191086 CURRENT 21-APR-03 7012 191613
    22-APR-03 NOT ALLOWED 21-APR-03 READ WRITE


    SQL> select * from v$instance;

    INSTANCE_NUMBER INSTANCE_NAME
    --------------- ----------------
    HOST_NAME
    ----------------------------------------------------------------
    VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
    ----------------- --------- ------- --- ---------- ------- -----------
    LOGINS SHU DATABASE_STATUS INSTANCE_ROLE
    ---------- --- ----------------- ------------------
    1 insb
    mydb
    8.1.6.1.0 22-APR-03 OPEN NO 1 STOPPED
    ALLOWED NO ACTIVE PRIMARY_INSTANCE

  3. #23
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Ya, that looks OK.

    Well, one more thing, create a tnsnames.ora on the server and connect to both databases using the tnsnames.ora on the server.

    sqlplus system/ora987@insa

    sqlplus system/manager@insb

    If you succeed, copy this tnsnames.ora to the client and check from there.

    HTH.

  4. #24
    Join Date
    Jan 2002
    Posts
    78
    i tried by creating the tnsnames.ora at server - Its not working properly - Giving the problem.

  5. #25
    Join Date
    Feb 2002
    Posts
    70
    Hello,
    Did you tried by restarting the Listener? You can reload the Listener.
    Give listener stats and check whether there are any service handlers for your databases.

    Thanks,
    ________________
    ShanDJ

  6. #26
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Originally posted by Sekhar
    i tried by creating the tnsnames.ora at server - Its not working properly - Giving the problem.
    You mean, connecting to the databases at the server using tnsnames.ora is not working?

    Post the errors you are getting at the server when you use tnsnames.ora. What problem are you getting?

    HTHU

  7. #27
    Join Date
    Jan 2002
    Posts
    78
    [oracle@ciberdb admin]$ sqlplus system/passwordA@INSA

    SQL*Plus: Release 8.1.6.0.0 - Production on Thu Apr 24 08:26:39 2003

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

    ERROR:
    ORA-01017: invalid username/password; logon denied


    But the Same is connecting if I am giving

    sqlplus system/passwordB@INSB - But Connecting to instance B.

    BTB, I tried all the options with listener ( restarting, reloading)

    The listener status is

    INSA has 1 service handler(s)
    INSA has 1 service handler(s)
    INSB has 1 service handler(s)
    INSB has 1 service handler(s)

    If the same is showing 1 Service Handler only like ( for this I am stopping and again restarting the listener)
    INSA has 1 service handler(s)
    INSB has 1 service handler(s)

    Then They are connecting properly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width