SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
connecting to oracle 9.2

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
connecting to oracle 9.2
Author Message
randy



Joined: 13 Oct 2005
Posts: 9

Post connecting to oracle 9.2 Reply with quote

Downloaded the DBAudit application for evaluation.

We have two different versions of Oracle running here, 8.1 and 9.2 .
I can connect to the 8.x version fine, but when connecting to the 9.2
the message returns that i must have my default home set to 9i.
The home default key value is OraHome92.

I have tried a few things (altering the registry settings, etc.) to no avail.

What am I missing?

Thanks in advance for the assistance

Thu Oct 13, 2005 11:31 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: connecting to oracle 9.2 Reply with quote

Please don't confuse Oracle server version with Oracle client version. When giving you a choice of drivers for connecion DB Audit wants you to pick the one that is compatible with your client version. So if you got v8 on the client and v9 on the server please pick 8. This does not affect any fnctionality. IT is just te graphical console will look for different connectivity methods and files.

: Downloaded the DBAudit application for evaluation.

: We have two different versions of Oracle running here, 8.1 and 9.2 .
: I can connect to the 8.x version fine, but when connecting to the 9.2
: the message returns that i must have my default home set to 9i.
: The home default key value is OraHome92.

: I have tried a few things (altering the registry settings, etc.) to no avail.

: What am I missing?

: Thanks in advance for the assistance

Thu Oct 13, 2005 1:01 pm View user's profile Send private message
randy



Joined: 13 Oct 2005
Posts: 9

Post Re: connecting to oracle 9.2 Reply with quote

: Please don't confuse Oracle server version with Oracle client version. When
: giving you a choice of drivers for connecion DB Audit wants you to pick
: the one that is compatible with your client version. So if you got v8 on
: the client and v9 on the server please pick 8. This does not affect any
: fnctionality. IT is just te graphical console will look for different
: connectivity methods and files.

Tried that too.... and i have both versions loaded

When connecting to the 9.2 with the 8i selected, the connection string is
missing the 'as sysdba' option, which means i can't connect as sys. i can
connect as another user with dba authority such as sysadm, but that doesn't
allow for the full access to objects owned by sys.

Admittedly, this will likely wind up on the a server console that has only one
version loaded, but if the reporting mechanism operates under the same scheme,
then it could be a potential issue as well.

We don't expect to be running both versions forever, but it is likely for the
next year or so.

Any other suggestions?

Thu Oct 13, 2005 2:06 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7839

Post Re: connecting to oracle 9.2 Reply with quote

In this case I think all you need to do is to re-arrange values in the system PATH environment variable and make sure path to version 9 client is listed before 8. You can change it in My Computer properties (see Environment Variables options)

: Tried that too.... and i have both versions loaded

: When connecting to the 9.2 with the 8i selected, the connection string is
: missing the 'as sysdba' option, which means i can't connect as sys. i can
: connect as another user with dba authority such as sysadm, but that doesn't
: allow for the full access to objects owned by sys.

: Admittedly, this will likely wind up on the a server console that has only
: one
: version loaded, but if the reporting mechanism operates under the same
: scheme,
: then it could be a potential issue as well.

: We don't expect to be running both versions forever, but it is likely for the
: next year or so.

: Any other suggestions?

Thu Oct 13, 2005 3:04 pm View user's profile Send private message
randy



Joined: 13 Oct 2005
Posts: 9

Post Re: connecting to oracle 9.2 Reply with quote

: In this case I think all you need to do is to re-arrange values in the system
: PATH environment variable and make sure path to version 9 client is listed
: before 8. You can change it in My Computer properties (see Environment
: Variables options)

Thanks for the assist. I had tried that after the last post and it works
great.

I'm thinking we'll be purchasing this!

Thanks again for the support.

Regards,
Randy

Thu Oct 13, 2005 3:35 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.