| Unkown service name [message #366738] |
Fri, 17 November 2000 12:29  |
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  |
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 #366758 is a reply to message #366744] |
Tue, 28 November 2000 06:44 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
