Profile picture for user bkahlee

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?

 

by Carlos Eduardo
Posted on Tue, 01/06/2015 - 13:52

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.

0
by Marcelo Sampaio
Posted on Mon, 11/27/2017 - 13:42

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.com

Make 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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock