ORA-12154: TNS:could not resolve the connect identifier specified

posted Jun 9, 2011, 6:47 AM by Sachchida Ojha

Before

SQL> sho parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string LISTENER_TESTDB1
remote_listener string
SQL>

After

SQL> show parameter listener
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string      (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=orac01)(PORT=1521))))
remote_listener                      string      orac.thexchange.com:1521


TESTDB1.__db_cache_size=2147483648
TESTDB1.__java_pool_size=536870912
TESTDB1.__large_pool_size=536870912
TESTDB1.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
TESTDB1.__pga_aggregate_target=45097156608
TESTDB1.__sga_target=8589934592
TESTDB1.__shared_io_pool_size=0
TESTDB1.__shared_pool_size=10200547328
TESTDB1.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/TESTDB/adump'
*.cluster_database_instances=2
*.cluster_database=TRUE
*.compatible='11.2.0'
*.control_files='+DATA/testdb1_ctl01.ctl','+FRA/testdb1_ctl02.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATA'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='STGTDB'
*.db_recovery_file_dest='+DATA'
*.db_recovery_file_dest_size=2G
*.diagnostic_dest='/u01/app/oracle'
TESTDB1.instance_name='TESTDB1'
TESTDB1.instance_number=1
TESTDB2.instance_number=2
*.job_queue_processes=10
*.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=orac01)(PORT=1521))))'
*.log_checkpoints_to_alert=TRUE
*.memory_max_target=107374182400
*.memory_target=53687091200
*.pga_aggregate_target=100M
*.processes=4096
*.recyclebin='OFF'
*.remote_listener='orac.thexchange.com:1521'
*.remote_login_passwordfile='exclusive'
*.sessions=6180
STGTDB2.thread=2
TESTDB1.thread=1
*.undo_management='AUTO'
TESTDB1.undo_tablespace='UNDOTBS1'
TESTDB2.undo_tablespace='UNDOTBS2'
Comments