-
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
-
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
-
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)
)
)
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|