Oracle RAC network grief ruins OID installer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle RAC network grief ruins OID installer

Hybrid View

  1. #1
    Join Date
    May 2005
    Posts
    129

    Oracle RAC network grief ruins OID installer

    I have instances named asdb1,asdb2,asd3. The collective instance name is asdb. None of the asdbx.domain.com service names work. If you want to log in use the short name and any instance will comply.

    This totally hoses the OID install, preventing 20 app servers from registering to the OID.

    New to RAC, anybody have a clue ?

    Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Quote Originally Posted by roadwarriorDBA
    I have instances named asdb1,asdb2,asd3. The collective instance name is asdb. None of the asdbx.domain.com service names work. If you want to log in use the short name and any instance will comply.

    This totally hoses the OID install, preventing 20 app servers from registering to the OID.

    New to RAC, anybody have a clue ?

    Thanks

    can you post your tnsnames and sqlnet files?
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    May 2005
    Posts
    129
    Listener seems a bit light:

    LISTENER_CO3INFRA1 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521)(IP = FIRST))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.98.117.21)(PORT = 1521)(IP = FIRST))
    )
    )

    TNS:

    LISTENERS_ASDB =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    )

    LISTENERS_DB1INFRA =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    )

    DB1INFRA3 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = db1infra.rqinet.com)
    (INSTANCE_NAME = db1infra3)
    )
    )

    DB1INFRA2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = db1infra.rqinet.com)
    (INSTANCE_NAME = db1infra2)
    )
    )

    DB1INFRA1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = db1infra.rqinet.com)
    (INSTANCE_NAME = db1infra1)
    )
    )

    ASDB =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = asdb.rqinet.com)
    )
    )

    DB1INFRA =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = db1infra.rqinet.com)
    )
    )

    ASDB3 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra3-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = asdb.rqinet.com)
    (INSTANCE_NAME = asdb3)
    )
    )

    ASDB2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra2-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = asdb.rqinet.com)
    (INSTANCE_NAME = asdb2)
    )
    )

    ASDB1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = co3infra1-vip.rqinet.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = asdb.rqinet.com)
    (INSTANCE_NAME = asdb1)
    )
    )

  4. #4
    Join Date
    May 2005
    Posts
    129
    Infra was a failed setup, it worked with RAC but not with OID as it lacked Ultrasearch ( now on companion CD ).

    So the relevant stuff here is ASDB.

    Service Name : asdb.rqinet.com

    Local logins are successful as follows:

    Yes sqlplus system/rqinet@asdb
    Yes sqlplus system/rqinet@asdb1
    Yes sqlplus system/rqinet@asdb2
    Yes sqlplus system/rqinet@asdb3
    No sqlplus system/rqinet@asdb.rqinet.com

    Successful local logins donít work when applied to install OUI and especially 'asdb.rqinet.com' which should work and should be put into the OUI OID installer.

    Thanks for looking at this. Need to get it going so that 20 app servers can get setup and installed on this RAC'd OID.

  5. #5
    Join Date
    May 2005
    Posts
    129
    The FQDN tns alias was easily solved and the OID installer still could not connect.

    The manual says to use the following:
    co3infra1-vip.rqinet.com:1521, co3infra2-vip.rqinet.com:1521, co3infra3-vip.rqinet.com:1521

    That does not work even with spaces removed.

    What does work is this:

    co3infra1-vip.rqinet.com:1521^co3infra2-vip.rqinet.com:1521^co3infra3-vip.rqinet.com:1521

    I dont ever recall working with '^' in Oracle before.

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