oracle - ORA 12154 - unable to connect from toad/SQLplus -


when try connect database in tnsnames.ora file sqlplus throws 

ora-12154: tns not resolve service name

i've checked stuff:

tns_admin environment variable defined "c:\oraclexe\app\oracle\product\10.2.0\server\network\admin"    "c:\oraclexe\app\oracle\product\10.2.0\server\network\admin\tnsnames.ora" located    following connect descriptor found my_db in tnsnames.ora file    my_db=     (description=       (address=         (protocol=tcp)         (host=local.db)         (port=1521)       )       (connect_data=         (sid=scmprod)       )     )    "c:\oraclexe\app\oracle\product\10.2.0\server\network\admin\sqlnet.ora" located    names.directory_path specifies tnsnames in sqlnet.ora file

the question is:

what missing?

update

now on sqlplus using the usr/pwd@selftest connection string works

in can't error on server because on old pc still accept connection company works on it.

the tnsname.ora

selftest=   (description=     (address=       (protocol=tcp)       (host=10.100.2.7)       (port=1521)     )     (connect_data=       (server=dedicated)       (service_name=goldtest)     )   )

the problem still exist trying connect toad oracle...

ora-12154: tns not resolve service name

my_db=     (description=       (address=         (protocol=tcp)         (host=local.db)         (port=1521)       )       (connect_data=         (sid=scmprod)       )     )

the error incorrect service name. see tnsnames.ora doesn't have service_name, rather have mentioned sid. cause of error.

you edit tnsnames.ora as:

scmprod =  (description =     (address_list =      (address = (protocol = tcp)(host = localhost)(port = 1521))    )  (connect_data =    (service_name = scmprod)  ) )

assuming, scmprod service_name.


Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more