- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Multiple installations of Oracle on the same devel...
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
тАО02-21-2002 11:19 AM
тАО02-21-2002 11:19 AM
Anyways, can anyone point me to any set of docs that will talk about what I should watch for ? I do not think all instances would be running at the same time, but, it does not hurt to set up as such, just in case.
Thanks,
Henrique Silva
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-21-2002 11:35 AM
тАО02-21-2002 11:35 AM
SolutionYou can have multiple instances on 9i and 8i running at the same time as long as there are separate ORACLE_HOMES and each has a unique Oracle SID. You can even have multiple listeners running so long as the port numbers do not conflict. I do this all the time on Development boxes and Sandboxes.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-21-2002 12:17 PM
тАО02-21-2002 12:17 PM
Re: Multiple installations of Oracle on the same developmental box ???
/u01/app/oracle/8.1.7-64bit
/u01/app/oracle/8.1.7-32bit
/u01/app/oracle/9i
Dennis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2002 12:19 AM
тАО02-22-2002 12:19 AM
Re: Multiple installations of Oracle on the same developmental box ???
Install the different Oracle versions in separate homes:
/oracle/product/8.1.7
/oracle/product/8.1.7_64
/oracle/product/9.0.1
and make sure (using script or different users) that your enviroment settings gets right depending on version:
- ORACLE_HOME
- PATH
- ORA_NLS33
- ORACLE_BASE
- LD_LIBRARY_PATH
- ORACLE_PATH
- SHLIB_PATH
and ofcourse ORACLE_SID nameing the instance.
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-22-2002 12:28 AM
тАО02-22-2002 12:28 AM
Re: Multiple installations of Oracle on the same developmental box ???
Also make sure your /etc/oratab file correctly refers to the different ORACLE_HOMEs
Something else to consider when running multiple Oracle instances on the same system (even if they are all running the same Oracle version) is to create and oracle user 'per instance' e.g. If I have 3 instances called dev, qas, and prd I would have three users:
user oradev group dba
user oraqas group dba
user oraprd group dba
This makes life a lot easier when maintaining the databases e.g If an instance crashes and leaves behind IPC resources, its much easier to identify which resources to 'ipcrm'.
HTH
Duncan
I am an HPE Employee