Home » Infrastructure » Windows » set one oracle as primary out of 2 (Oracle 8.0 & oracle 10.0)
 set one oracle as primary out of 2 [message #465383] |
Tue, 13 July 2010 23:33  |
dhpawar
Messages: 2
Registered: July 2010
Location: Pune
|
Junior Member |
|
|
Hi Team,
On my system 2 oracles are installed for different applications one having version 8.0 & other 10.0.
The oracle 10.0 is required for Windchill application. When I am trying to access the sqlplus by windchill shell it access the Oracle 8.0 sqlplus.
Please suggest me how to set one oracle as primary on system so i am able to access the oracle 10 sqlplus in windchill shell.
Thanks in Advance
Devidas
|
|
|
|
|
|
| Re: set one oracle as primary out of 2 [message #465430 is a reply to message #465405] |
Wed, 14 July 2010 02:30  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Alternatively, as it is SQL*Plus you are talking about, and regarding the fact that there are two different Oracle versions installed on your system, perhaps you could create a shortcut desktop icon for the "Command Prompt" application. In its "Start in" property, you'd put path to a directory that contains SQL*Plus executable you'd like to run.
It means that you'd, actually, have two icons: one for every SQL*Plus version. Clicking one of them would put you into the \BIN directory, and invoking SQLPLUS would run desired version.
Drawback here is the fact that your working directory is \BIN, and that's probably not a very good idea. However, you could create shortcuts to both SQLPLUS.EXEs, name them as (for example) SP8 and SP10, put them in any (harmless) directory and do the job.
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun May 04 02:39:10 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
