Thursday, February 21, 2019

ORA-12154: TNS Connection error when tried via Easy Connect

Symptoms:
For Oracle Retail products, such as Store Inventory Management (SIM), for data-seeding it uses the groovy library and sqlplus connections to load demo data from another database source.
If you perform the step that requires Sqlplus connection underneath, but it returns and error that you can see on the logs.

eg:
$ ./startDataSeedCli.sh -a 1 -s localhost -p 1521 -d SIMDB

cat ../log/data_seed_common.log
START processing verify_db_conn.sql
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Cause: 
The connection with the database via Sqlplus is used the Easy Connect option and it is required to be enabled to perform via Easy Conenct.

Solution:
The simple solution is adding/appending the parameter names.directory_path, the value "ezconnect" on the sqlnet.ora.

eg:
names.directory_path = (tnsnames,ezconnect)



No comments:

Post a Comment

Configure the Oracle DB Access Control List to avoid error like ORA-24247: network access denied

Symptoms:  You try to make external connections from the Oracle Database and receive erros like ORA-24247: network access denied by access c...