Multiple database configuration for scan ip.
Hi All,
I am planning to implement 11gR2.
Grid infrastructure is already done. Now i need to create 4 database in the same oracle home.
There is a separate listener for each database with different port.
As i scan ip is configured using 1521 port.
My question is will my scan vip will work to connect to the database remotely if will give tnsstring with scan ip.
For e.g
for database 1, we are using port 1522
MYDB
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=t24db-scan)(PORT=1522))
(CONNECT_DATA=(SERVICE_NAME=master)))
for database 2, port is 1523
MYDB
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=mydb-scan.ORACLE.COM)(PORT=1523))
(CONNECT_DATA=(SERVICE_NAME=master))
Please suggest ,
Thanks and Regards,
jatin