SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Connecting to Oracle 8i

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Connecting to Oracle 8i
Author Message
Tom Pridham



Joined: 16 Jan 2000
Posts: 3

Post Connecting to Oracle 8i Reply with quote

What is the correct Host syntax to connect to an Oracle 8i database?

Tue Mar 07, 2000 12:50 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Re: Connecting to Oracle 8i Reply with quote

For the Host string enter your Oracle service name as it is specified in your TNSNAMES.ORA file. For more info please see "How to connect to your database" topic in the on-line help system

: What is the correct Host syntax to connect to an Oracle 8i database?

Tue Mar 07, 2000 1:02 pm View user's profile Send private message
Tom Pridham



Joined: 16 Jan 2000
Posts: 3

Post Re: Connecting to Oracle 8i Reply with quote

: For the Host string enter your Oracle service name as it is specified in your
: TNSNAMES.ORA file. For more info please see "How to connect to your
: database" topic in the on-line help system

Was this an automated message? I went through the help documentation before posting the first message. The help document states:

(DBMS O71,O72,O73) The tnsnames.ora file was not found in Oracle_HOME\NETWORK\ADMIN directory.
(DBMS OR8) The tnsnames.ora file was not found in Oracle_HOME\NET80\ADMIN directory.

HOWEVER, the tnsnames.ora file is in the Oracle_Home\Network\Admin directory for 8i, there is not a NET80 directory. So by selecting Oracle 8 from the drop down menu, where is it looking for the file, in both places? Has anyone successfully used this tool with Oracle 8i?

Tue Mar 07, 2000 1:21 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6499

Post Re: Connecting to Oracle 8i Reply with quote

1. Oracle 8i is the short name of Oracle 8.1.5

2. DBMS drop-down selection simple tells the system what Oracle CLIENT software you want to use to establish a connection and it has nothing to do directly with your TNSNAMES.ORA file. dbMonitor and other components look for corresponding Oracle OCI DLLs which in turn read your TNSNAMES.ORA.

Note that different Oracle versions have different "client" interfaces, and different bugs as well. For example Oracle 8.1.5 OCI DLLs do not shut down gracefully, creating a memory leak. On some systems it causes a second connection from dbTools to fail (even cause GPF).

In order to connect to your Oracle 8i server you can, but you are not required to use Oracle 8.1.5 client software. If you have SQL*Net 2.x and Oracle 7 RSF (required support files) installed you can also use appropriate Oracle 7.x interface to connect to Oracle 8i server you can even use an ODBC connection to connect to your Oracle server, however Oracle own ODBC driver is very buggy and it is not recommended. There are exist other ODBC drivers available from Inersolve, Microsoft and other.

We are also recommending Oracle 7.3 interface as the most stable and bug free.

Again using any interface you should be able to connect to any Oracle server 7.x or 8.x running on any platform.

3. The tool is capable to work with Oracle 8i and we successfully use it internally.

: Was this an automated message? I went through the help documentation before
: posting the first message. The help document states: (DBMS O71,O72,O73)
: The tnsnames.ora file was not found in Oracle_HOME\NETWORK\ADMIN
: directory.
: (DBMS OR8) The tnsnames.ora file was not found in Oracle_HOME\NET80\ADMIN
: directory.

: HOWEVER, the tnsnames.ora file is in the Oracle_Home\Network\Admin directory
: for 8i, there is not a NET80 directory. So by selecting Oracle 8 from the
: drop down menu, where is it looking for the file, in both places? Has
: anyone successfully used this tool with Oracle 8i?

Tue Mar 07, 2000 1:46 pm View user's profile Send private message
Tom Pridham



Joined: 16 Jan 2000
Posts: 3

Post Re: Connecting to Oracle 8i Reply with quote

Thanks for the information, for a quick fix I just went through ODBC. Thanks again for your timely responses.

: 1. Oracle 8i is the short name of Oracle 8.1.5

: 2. DBMS drop-down selection simple tells the system what Oracle CLIENT
: software you want to use to establish a connection and it has nothing to
: do directly with your TNSNAMES.ORA file. dbMonitor and other components
: look for corresponding Oracle OCI DLLs which in turn read your
: TNSNAMES.ORA.

: Note that different Oracle versions have different "client"
: interfaces, and different bugs as well. For example Oracle 8.1.5 OCI DLLs
: do not shut down gracefully, creating a memory leak. On some systems it
: causes a second connection from dbTools to fail (even cause GPF).

: In order to connect to your Oracle 8i server you can, but you are not
: required to use Oracle 8.1.5 client software. If you have SQL*Net 2.x and
: Oracle 7 RSF (required support files) installed you can also use
: appropriate Oracle 7.x interface to connect to Oracle 8i server you can
: even use an ODBC connection to connect to your Oracle server, however
: Oracle own ODBC driver is very buggy and it is not recommended. There are
: exist other ODBC drivers available from Inersolve, Microsoft and other.

: We are also recommending Oracle 7.3 interface as the most stable and bug
: free.

: Again using any interface you should be able to connect to any Oracle server
: 7.x or 8.x running on any platform.

: 3. The tool is capable to work with Oracle 8i and we successfully use it
: internally.

Tue Mar 07, 2000 1:52 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.