- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Dual Oracle DB problem sort of resolved.
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 02:25 AM
тАО12-03-2003 02:25 AM
Dual Oracle DB problem sort of resolved.
Oh and thanks so much for your help in pointing out a answer,
M
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 02:36 AM
тАО12-03-2003 02:36 AM
Re: Dual Oracle DB problem sort of resolved.
Try either:
add environtment variable TNS_ADMIN=
or
copy in both the ORACLE_HOME/network/admin the same tnsnames.ora
Remember that tnsnames dor 817 and 902 are different, they may use service_name or sid, depending upon the executables and the destination database...
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 02:58 AM
тАО12-03-2003 02:58 AM
Re: Dual Oracle DB problem sort of resolved.
If so, I cant seem to find that or if not and you are talking about the tns_name, don't have then new database sid in the other tns file, and I dont have the other in the new tns_name. I thought they were separate. Can you clearify please?
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 03:08 AM
тАО12-03-2003 03:08 AM
Re: Dual Oracle DB problem sort of resolved.
he is talking about the place, where you define environment variables. Go to system configuration/system/enhanced and there you can see and edit the variables.
greetings,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 03:15 AM
тАО12-03-2003 03:15 AM
Re: Dual Oracle DB problem sort of resolved.
usually, if not otherwise specified, its value is $ORACLE_HOME/network/admin
Usually is best if all is aligned...
to how many different database do you connect to (usually)?
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 03:20 AM
тАО12-03-2003 03:20 AM
Re: Dual Oracle DB problem sort of resolved.
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 03:25 AM
тАО12-03-2003 03:25 AM
Re: Dual Oracle DB problem sort of resolved.
obviouslt the path canghes..
Massimo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 07:16 AM
тАО12-03-2003 07:16 AM
Re: Dual Oracle DB problem sort of resolved.
Since you have a PC, run Linux. If you really want to use 2 releases on a PC server it is by far the cheapest manner. Redhat 7-9 works fine. Use ODBC to access the data from a PC. It is easier by far to do Oracle on any UNIX or variant, IMHO.
Tim
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-03-2003 03:53 PM
тАО12-03-2003 03:53 PM
Re: Dual Oracle DB problem sort of resolved.
you can define your TNS_ADMIN by doing the following on your Windows based server (W2K)
System Properties
->Advanced
->Environment Variables
->System Variables
then New
hope this helps too!
regards
Yogeeraj