Home » RDBMS Server » Server Administration » ORACLE SERVICES
ORACLE SERVICES [message #230376] Wed, 11 April 2007 13:01 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have oracle single instance running on 10.2.0.1. I created the services but its not registered with the listener. When I try to connect from the client using the service_name i created, am getting...
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

When I did lsnrctl services...its not showing all the services.
Can anyone tell me what could be the problem?
Thanks,
GK
Re: ORACLE SERVICES [message #230378 is a reply to message #230376] Wed, 11 April 2007 13:05 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
Entry is not exist in tnsnames.ora
Re: ORACLE SERVICES [message #230379 is a reply to message #230376] Wed, 11 April 2007 13:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
lsnrctl deals with listener services.
First configure your listner (edit listener.ora).
Register the database to use a lister ( listen to a particular port).
Then Edit tnsnames.ora to add tns service.
If you do not want to use tnsnames.ora or listener and if the database is local, set your ORACLE_SID explicityly and login.
set ORACLE_SID (windows)
export ORACLE_SID (windows)
sqlplus user/pass
Re: ORACLE SERVICES [message #230426 is a reply to message #230376] Wed, 11 April 2007 23:32 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
When I try to connect from the client using the service_name i created, am getting...

Oracle Server and client on Some Machine. if yes then you have to configure Oracle Server TNSNAMES.ORA file also.


or
Change listerer registration from dynamic to static.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
(SID_DESC = 
(SID_NAME = orcl)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_1) )
)

C:\>LSNRCTL stop
C:\>REM WAIT FEW SECONDS
C:\>LSNRCTL start





Regards
Taj
Previous Topic: ODBC setting for oracle
Next Topic: Deletion of records from big table
Goto Forum:
  


Current Time: Wed Dec 07 16:22:58 CST 2016

Total time taken to generate the page: 0.16077 seconds