OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORACLE SERVICES

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORACLE SERVICES [message #230376]

Wed, 11 April 2007 13:01

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

Report message to a moderator

Re: ORACLE SERVICES [message #230378 is a reply to message #230376]

Wed, 11 April 2007 13:05

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

Entry is not exist in tnsnames.ora

Report message to a moderator

Re: ORACLE SERVICES [message #230379 is a reply to message #230376]

Wed, 11 April 2007 13:06

Mahesh Rajendran
Messages: 10707
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

Report message to a moderator

Re: ORACLE SERVICES [message #230426 is a reply to message #230376]

Wed, 11 April 2007 23:32

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

Report message to a moderator

Previous Topic:	ODBC setting for oracle
Next Topic:	Deletion of records from big table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 00:35:07 CDT 2024