Home » Developer & Programmer » JDeveloper, Java & XML » Unkown service name
Unkown service name [message #366738] Fri, 17 November 2000 12:29 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: Unkown service name [message #366741 is a reply to message #366738] Mon, 20 November 2000 13:17 Go to previous messageGo to next message
Nicholas Gray
Messages: 13
Registered: November 2000
Junior Member
if your able to connect to your database with
svrmgr then you've got two chances to find your SID.

1. do a 'SELECT name FROM v$database' (in svrmgr)
2. check your registry
'HKEY_LOCAL_MACHINE\Software\Oracle' ... look for
the ORACLE_SID entry (location depends on Oracle
version, so might be in a HOME0 sub-folder)

Sayonara
Re: Unkown service name [message #366744 is a reply to message #366741] Tue, 21 November 2000 04:34 Go to previous messageGo to next message
Larry Ellison
Messages: 6
Registered: November 2000
Junior Member
Thank you for answering.

I know my Oracle SID, but I do not find it in the 'tsnames.ora' file.

What I am lookin for is the 'SERVICE NAME'.

Regards,
Re: Unkown service name [message #366758 is a reply to message #366744] Tue, 28 November 2000 06:44 Go to previous message
Nicholas Gray
Messages: 13
Registered: November 2000
Junior Member
Oh ... ok ... let's have another try then.

1. Navigate to Start Oracle Network Administration Net8 Configuration Assistant.
2. Choose Local Net Service Name Configuration, then choose Next.
3. Choose Modify and you should be offered a number of existing local Service Names
(or create a new service name ...)

---
Configuring and Locating an ODBC Data Source
Programs that use ODBC to connect to remote databases must have a way to identify the database to which they wish to connect. This is accomplished through an ODBC Data Source, which associates a name with some database connection information. In the case of Oracle, the database connection information is simply the name of the Net8 Service you set up during the Oracle Client Configuration.

Click Start->Settings->Control Panel

Double-click ODBC Data Sources (On some systems this icon may be named ODBC or ODBC Data Sources (32-bit)) In Windows 2000, this is in a separate folder. If you are using Windows 2000, double click on the Administrative Tools folder. Within the Administrative Tools folder, click on ODBC Data Sources.

At the top of the ODBC Data Source Administrator window, click the tab labeled System DSN

Click the Add... button on the right

Click on Oracle ODBC Driver in the list and then click Finish

Enter the following information in the Oracle ODBC for Oracle Setup window:
(The examples listed will create an Oracle ODBC Data Source for the OED1 database on durga.uits.indiana.edu)

Field:
Data Source Name

User-specified name by which you will refer to this ODBC Data Source

Example:
durga_oed1

Field:
Description

Not required; Just a phrase reminding you why you created this ODBC Data Source Oracle ODBC for OED1 Database on durga.uits.indiana.edu

Field:
Service Name

The Net8 Service Name you created for the database to which you want to connect

Example:
oed1.world for an 8i database
oed1 for an 8 database

Field:
User Name

Usually left blank; You will be prompted for this later.
Click OK

You'll see the durga_oed1 ODBC Data Source appear in your System DSN list.
Click OK to finish your ODBC Configuration.

PS: all this can also be found in more detail at:
http://www.indiana.edu/~dms/databases/oracle/install_instructions.html

Sayonara
Previous Topic: JDBC Connection failed
Next Topic: loading java source files
Goto Forum:
  


Current Time: Tue Aug 03 21:56:41 CDT 2021