Getting this error after install:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Has anyone been able to successfully connect Aris to an Oracle rac db?
2 Replies
-
Hello Ellen,
did you find a way to solve this problem ? This is happening with our instalattion. Could you help me ?
Thanks in advance.
Eduardo.
-
Hi all,
To solve the problem I have installed the aris pointing to the first node of RAC database and after the installation I change the external service to point to rac-scanlistener/SERVICENAME of the RAC database. After that the aris have worked in RAC environment sucessfully.
Ex:
RAC Environment
ORACLE_SID RAC node 1 = ARIS1
ORACLE_SID RAC node 2 = ARIS2
DATABASE RAC SERVICE NAME= ARIS
SCAN-LISTENER OF THIS DATABASE ON RAC = scanlistener.example.comMake installation pointing to the database host to scanlistener.example.com and ORACLE_SID to ARIS1.
After sucessfull instalation in Aris Cloud Controller "acc" stop all runnables with command "stopall".
Start only zookeeper runnable with command "start zoo_s, zoo_m or zoo_l" depending size of your installation.
Execute the command "list external services" in acc to get external service name. Ex. external service name db0000000000.
Update de external service with the following command in acc:
update external service db0000000000 url="jdbc:oracle:thin:@scanlistener.example.com/ARIS" driverClassName="oracle.jdbc.OracleDriver" username="arisinstanceuser" password="arisuserpassword" maxIdle=15 maxActive=100 maxWait=10000 removeAbandoned=false logAbandoned=true defaultAutoCommit=false rollbackOnReturn=true jmxEnabled=true host="scanlistener.example.com"
After change external service you can run "startall" command in "acc" to start all stopped runnables.
Best Regards,
Marcelo Sampaio