Null Pointer error in RAC Scan connector operation

Document created by pete_mccoy1.3055586893899446E12 Employee on Sep 23, 2013
Version 1Show Document
  • View in full screen mode
Attempting to setup Oracel connector/operation for Oracle 11g RAC Scan and receiving errors.
The syntax for the RAC Scan URL should look like this:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db1.myco.com)(PORT=1604))
(ADDRESS=(PROTOCOL=TCP)(HOST=tst-db2.myco.com)(PORT=1604)))
(CONNECT_DATA=SERVICE_NAME=mydb1.myco.com)(SERVER=DEDICATED)))

Actually, just copy the tnsentries from your tnsnames.ora

Or if your DBAs have set up OID, the best way to set your thin connect URL is with the following syntax:


jdbc:oracle:thin:@ldap://<OID server name>:<OID port>/<DB SID or Service Name>,cn=OracleContext,dc=<yourdomain>

So in this case, if "oid" were the DNS-resolvable name of the OID server at your company, and it used port 5000, it would be:

jdbc:oracle:thin:@ldap://oid:5000/mydb1,cn=OracleContext,dc=myco,dc=com

you can use scan ip in oracle 11g r2 instead of your nodes ip:
  testi=(DESCRIPTION = 
(ADDRESS_LIST= 
 (ADDRESS= (PROTOCOL = TCP)(HOST = scan-ip-or-name)(PORT = 1521))
 (FAILOVER = on)
 (LOAD_BALANCE = on)
)   
(CONNECT_DATA=
 (SERVICE_NAME = testi)
) )

Attachments

    Outcomes