Home » RDBMS Server » Server Utilities » An unknown service name
An unknown service name [message #368337] Fri, 17 November 2000 11:54 Go to next message
Larry Ellison
Messages: 6
Registered: November 2000
Junior Member
Hi there!

I've got a software that places an Oracle database when installing. I would like to manage this DB via Java Server Pages (JSP), but I do not know the service name.

I've serched in the listener.ora, tsnames.ora and files like these, but the unique strange thing I find is: 'extproc'. There is no clue of my DB Oracle SID.

I am able to access the DB via SVRMGR (browsing users, tablenames, ...) because I know the SYSTEM USER name and password, and internal password too.

+) How could I access my DB via ODBC (or JDBC)?
+) Shall I be able to find my DB service name?

Thanks in advance,
Re: An unknown service name [message #368345 is a reply to message #368337] Fri, 24 November 2000 12:32 Go to previous message
Messages: 6
Registered: November 2000
Junior Member

In Listener.ora the new service called extproc is add Oracle8 onwords to give new feature that external procedures.

If you want to find out your Service type the following in your server

lsnrctl80 stat

It will give you the status of Oracle Services

I hope above solution will solve your problem.


Previous Topic: Re: Line Breaks while uploading the data using SQL*Loader
Next Topic: Internal password
Goto Forum:

Current Time: Thu Dec 09 08:09:04 CST 2021