| An unknown service name [message #368337] |
Fri, 17 November 2000 11:54  |
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  |
Alagu
Messages: 6
Registered: November 2000
|
Junior Member |
|
|
Hi,
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.
Thanks
alagappan.N
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
