| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Help for Newbies - Install and Config pO8i on Win98
Two Tips for Newbies:
1) This newsgroup is useless. Look elsewhere for help.
2) Configuring Personal Oracle 8i (8.1.5) on Win98
The Personal Oracle 8i installation does not do everything necessary for you to be able to log in to the database (using SQL Plus) or connect from a VB application. You'll need the following information and take the following steps to be able to conveniently work with the database from VB, PowerBuilder, whatever.
Default User ID/Password combinations:
scott/tiger : default user system/manager : to grant priveleges, e.g. to have other users besides scott/tiger sys/change_on_install : dba authority - not recommended unlessyou know what you're doing
Creating new net service names:
There is a default net service name created on installation,
somthing like "EXTPROC_CONNECTION_DATA". A net service name is
essentially the name of the database - it is what you provide as
the "Host String" when you login with SQL Plus and what you give
as the data source for OLE DB and the server for ODBC. To create
your own use the Net8 Easy Config program
(Start->Programs->Oracle OraHome8i->Network Administration->Net8
Easy Config. Before running this program, however, you'll need to
know what your computer's name is (as far as TCP/IP is
concerned). You can find this by going to the Network Control
Panel (Start->Settings->Control Panel->Network) and looking on
the Identification tab for your Computer Name. Now run Net8 Easy
Config. Select the Create Action and fill in the new Net Service
Name (e.g. PROD) and click Next. On the following page (2 of 5)
select TCP/IP from the list to use as the protocol and click
Next. On the following page (3 of 5), enter your computer name
(which you looked up in the Network Control Panel) as the Host
Name. Leave the port setting at 1521. On the next page (4 of 5),
select Oracle 8i release 8.1 and enter "oracle" (with no quotes)
as the service name. Click Next. On the last page (5 of 5) is a
test button. Unfortunately the test will fail until you complete
the next steps. Click Next and then Finish. Reboot the computer.
Once the computer has restarted, go to the DOS Prompt (or
Start->Run) and enter this command: LSNRCTL START. This starts
the Listener program which intercepts TCP/IP requests to see if
someone is trying to access the database. You can close the DOS
window after it completes running. Test your new net service name
by running SQL Plus (Start->Programs->Oracle
OraHome8i->Application Development->SQL Plus). Enter scott and
tiger for the User and Password, respectively, and your new net
service name as the host string. You should be able to log on.
Creating ODBC DSNs:
There are generally two choices for Oracle ODBC driver - from
Microsoft or from Oracle. The latest version of the Microsoft
driver is version number 2.5etc. If you have an older version you
may want to consider installing the latest Microsoft Data Access
Components (MDAC) which is distributed as a single exe file
called MDAC_TYP.EXE. The current version (June 2000) is 2.5.
(MDAC is available free on the Microsoft web site). The Oracle
driver is installed when you install Personal Oracle. The latest
version is 8.0etc. The Microsoft driver is reported to work
better so I'll cover creating a DSN for that driver here. System
DSNs (as opposed to User DSNs) are also supposed to be more
reliable so we'll create one of those here.
Go to the ODBC control panel (Start->Settings->Control Panel->ODBC Data Sources (32 Bit). Click Add. Select the MS ODBC for Oracle driver from the list and click Finish. There will be a lag as a connection is established. In the box that pops up, give a data source name of your choosing. The description is essentially a comment. User Name is any working Oracle log in name (e.g. scott). The Server is the Net Service Name you created. Click OK and close the control panel. You should now be able to connect to the database from VB (note that unlike connecting to a typical Access database, you will also need to provide a password to open a connection - either set the Password property of the Connection object before using the Open method, or pass the password as one of the .Open method's arguments - see Help).
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Fri Jun 30 2000 - 00:00:00 CDT
 |
 |