Setting Up Oracle Client 8 - Teradata
OLE-DB
With
Oracle to Teradata
Configuration
&
Operation
(Crib Sheet)
06-19-2000
[pic]
By,
Scott Allen
Teradata Systems Group
NCR Corp.
Setting Up Oracle Client 8.1.5.0.0
This Crib Sheet was developed to document how to establish an Oracle to Teradata OLE-DB process from an NT Workstation. The process is straight forward but some details needed to be documented to assist others and hope this can save other PS associates time. Please feel free to update and share with others.
1) After the program files for Oracle Client have been copied to the computer during install a screen will pop-up that will ask the user to setup Net8. Hit cancel to exit this utility.
2) Go to Start ( Programs ( Oracle-OraHome81 ( Network Administration ( Net8 Easy Config:
3) A window that resembles the following will appear:
4) In the New Net Service Name field enter the name of the server that you would like to connect to, in this example we will use scott.world (Please note that it is important that the .world extension follow the net service name).
5) Click the next button after the name has been entered. The following screen will appear:
6) Make sure that the correct network communication protocol is selected…in this example we will use ‘TCP/IP (Internet Protocol)’ is selected and click next.
7) Under ‘Host Name:’ enter the IP address of the computer to which you would like to connect. (i.e. 234.56.789.10) In most cases the ‘Port Number:’ field will not need to be changed, as 1521 is the Oracle default. Click next.
8) Select ‘Oracle8i release 8.0 or Previous:’ and enter the ‘Database SID:’ (The Database SID will be the ‘Net Service Name’ from window one without the .world extension. Click next.
9) The following screen will appear. Press the ‘Test:’ button.
10) The following will appear:
11) The user id and password must be changed. Click on change login, and the following will appear:
12) Type the correct values into the ‘Username’ and ‘Password’ fields and hit ok. The test screen will then appear again.
13) Click test. If the communication is valid the following screen will appear:
14) Click close and then next at the test screen. Click finished to save the changes that you made.
15) Now you must edit the file tnsnames.ora, which will be found in the ‘c:\oracle\ora81\network\admin’ directory.
16) Open the file with wordpad…it should resemble the following:
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
SCOTT.WORLD. =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 234.56.789.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = scott)
)
)
17) In some cases the network may add an extension to the above file after the , such as ‘.’ above.
18) Delete the extension if there is one, so that the file resembles the following:
# C:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:C:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle Net8 Assistant
SCOTT.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 234.56.789.10)(PORT = 1521))
)
(CONNECT_DATA =
(SID = scott)
)
)
19) Save the changes to this file (if any), and close wordpad.
20) OLE DB is now configured to communicate with Oracle.
21) If you need to add additional servers, please repeat the steps above.
22) Open OLE DB, select ‘Microsoft OLE DB Provider for Oracle (“MSDAORA”)’, and click on connection and you will see the following:
23) Enter the ‘User Name:’, ‘Password’, and ‘Server’ for the database that you wish to log into and hit ‘OK’. (Note that the server name, in most cases, will be the ‘Net Service Name’ from Step 4)
24) If everything is configured properly, the tables should appear on the left, and the columns within the selected table on the right.
-----------------------
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- oracle imaging and process management services
- tennessee state government
- setting up oracle client 8 teradata
- introduction the official website of the state
- nemis home
- upgrade instructions for acorde oracle help center
- market basket analysis and its prominence in strategic
- types of accounts
- general services administration gsa advantage
- ut oracle client installation in
Related searches
- oracle client download
- oracle client 19c windows
- oracle client 19 3
- oracle client download 32 bit
- oracle client download 64 bit
- download oracle client 12 2
- install oracle client windows
- oracle client 64 bit install
- download oracle client 12c windows
- oracle client tools 64
- oracle client 11 2 0
- oracle client tools download