Troubleshooting
Problem
Getting the below error, when the user tries to run the Database Component Configurator (DCC).
Where can one change the SID?
-bash-3.2$ ./dbConfigurator.sh -a create -d oracle -c OneDataMetadata -v latest -l jdbc:wm:oracle://SERVER_NAME:1527;serviceName=PPMDM -u onedata_md -p Welcome_123 -fv 10 -tsdata ETL_DATA -tsindex ETL_DATA
**********************************
* Executing action
* Action : create
* Database : Oracle
* Component(s) : OneDataMetadata
* Component(s) version : latest
* URL : jdbc:wm:oracle://SERVER_NAME:1527
* User : null
**********************************
**********************************
* create Database Component: ComponentTracker CTR
**********************************
* Versions
* Version: oracle 25.0
* Scripts create
* Script(1): /appinfprd/onedata/ond1/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql
* Script(2): /appinfprd/onedata/ond1/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql
* Script(3): /appinfprd/onedata/ond1/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql
* Script(4): /appinfprd/onedata/ond1/common/db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql
* Script(5): /appinfprd/onedata/ond1/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql
-----------------------------------
* Database Connection error: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-12505 Connection refused, the specified SID (ORCL) was not recognized by the Oracle server.
Document Location
Worldwide
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
20 March 2025
UID
ibm17199465