SQL> conn sys/1234@ORCLTEST as sysdbaI am giving wrong password here ..
I made some changes in my tnsnames.ora and listener.oraIt bothers me that the tnsnames.ora file specifies SERVICE_NAME while listener.ora specifies SID.
IMO, both should use the same; either both use SID or both use SERVICE_NAME.
Once again please clear my doubt sbMy problem is solved. but i can't understand clearly why first time i can't connect ?
*$ lsnrctl status*Some additional information about my new listener
Good Morning sb;
My problem is solved. but i can't understand clearly why first time i can't connect ?see: [url http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/] Help! I can’t connect to my database
I made some changes ( listener name modified , service_name modified , even both database also newly created just now)
Thanks sb and Mark .Powell and sharma
Yesterday i saw following thread; What can go wrong? => Really i wonder when reading ..Re: TNS:listener does not currently know of service requested in connect
My doubt is ( in your blogs also . service name is not like database global_name)
http://edstevensdba.wordpress.com/2011/02/09/sqlnet_overview/- service name mentioned as curely
969352 wrote:"not workable" is 100% & totally devoid of any actionable detail.what i believeIf we make service name is database globalname we can't connect database"
This is not workable ( if service_name is database global_name)
You should *NOT* be connecting "as sysdba" across the network.SQL> conn sys/password@net_service_name as sysdba
TSharma wrote:Not even close ;)
I think you guys are going to make a record with maximum number of posts in a single thread ;)
oracle 11696 1 0 16:31 ? 00:00:00 /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr LISTener_ORcl -inherit
i red following thread ..Listener status shows 2 instances when only 1 exists
Uwe Hesse saidREADY means listener knows this because PMON of that instance told him so (dynamic registration)
when i am checking my listener$ lsnrctl status
when static registration required and dynamic registration required (listener) ?I feel panic continuously asking here ..
its coming because of listener you have entry with this name GLOBAL_DBNAME
Instance "orclprod", status UNKNOWN, has 1 handler(s) for this service...
(SID_DESC = (GLOBAL_DBNAME=orclprod) (ORACLE_HOME = / / / / /db_1) (SID_NAME = orclprod) )
Instance "orclprod", status READY, has 1 handler(s) for this service...its coming because of listener you have entry with this name SID_NAME
UNKNOWNdue to pmon register based on db_name,service_names plus db_domain parameter in spfile and pmon registers in every 60 seconds
or manually you may have tried alter system register;