vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have a win2000 server with two different oracle homes on it. When creating an Oracle service with oradim, how do I tell it which home to use when it starts the instance? The homes contain different versions and I want different services starting different instances in different versions. The versions involved are 8.1.7.0 and 8.1.7.12. -- Chuck Remove "_nospam" to reply by email |
| |||
| Chuck wrote: > I have a win2000 server with two different oracle homes on it. When > creating an Oracle service with oradim, how do I tell it which home to use > when it starts the instance? The homes contain different versions and I > want different services starting different instances in different versions. > The versions involved are 8.1.7.0 and 8.1.7.12. One of the oradim parameters is pfile ... meaning parameter file ... meaning init<SID>.ora. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) |
| |||
| Make sure that you set the appropriate ORACLE_HOME for your window: set ORACLE_HOME=C:\directory Then, make sure you are using the oradim utility in that home for the specific service you want to create. HTH, Brian Chuck wrote: > > I have a win2000 server with two different oracle homes on it. When > creating an Oracle service with oradim, how do I tell it which home to use > when it starts the instance? The homes contain different versions and I > want different services starting different instances in different versions. > The versions involved are 8.1.7.0 and 8.1.7.12. > -- > Chuck > Remove "_nospam" to reply by email -- ================================================== ================= Brian Peasland dba@remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" |
| |||
| Brian Peasland <dba@remove_spam.peasland.com> wrote in news:4019504F.399E09B9@remove_spam.peasland.com: > Make sure that you set the appropriate ORACLE_HOME for your window: > > set ORACLE_HOME=C:\directory > > Then, make sure you are using the oradim utility in that home for the > specific service you want to create. > > HTH, > Brian > > > > Chuck wrote: >> >> I have a win2000 server with two different oracle homes on it. When >> creating an Oracle service with oradim, how do I tell it which home >> to use when it starts the instance? The homes contain different >> versions and I want different services starting different instances >> in different versions. The versions involved are 8.1.7.0 and >> 8.1.7.12. -- >> Chuck >> Remove "_nospam" to reply by email > Thanks. Oracle didn't have this scanario documented anywhere. I guess they don't expect people to be running multiple instances and multiple versions on the same Windows server. -- Chuck Remove "_nospam" to reply by email |
| |||
| On 29 Jan 2004 21:09:59 GMT, Chuck <chuckh_nospam@softhome.net> wrote: >Thanks. Oracle didn't have this scanario documented anywhere. I guess >they don't expect people to be running multiple instances and multiple >versions on the same Windows server. Both not true. It is possible and it is documented in the Windows specific documentation, which you obviously didn't read. -- Sybrand Bakker, Senior Oracle DBA |
| |||
| Chuck <chuckh_nospam@softhome.net> wrote in message news:<Xns947F83DEDD5F6chuckhsofthomenet@130.133.1. 4>... > I have a win2000 server with two different oracle homes on it. When > creating an Oracle service with oradim, how do I tell it which home to use > when it starts the instance? The homes contain different versions and I > want different services starting different instances in different versions. > The versions involved are 8.1.7.0 and 8.1.7.12. if you create a database using the Oracle Database Creation Assistant (dbca) and save the scripts, it specifies the full path to each executable that is run. seems like a good practice to me. if your Oracle homes are as follows: D:\oracle \ora81 \ora92 then to create a new service for an 8.1.7 db (assuming that you already have a password file in D:\oracle\ora92\database) C:\> d:\oracle\ora81\bin\oradim.exe -new -sid <mysid> -startmode m -pfile <path> -timeout 150 hth. Pd |
| |||
| Sybrand Bakker <gooiditweg@sybrandb.demon.nl> wrote in news:gqvi10pkugl0cu4h000gkpak7fpgv1stav@4ax.com: > On 29 Jan 2004 21:09:59 GMT, Chuck <chuckh_nospam@softhome.net> wrote: > >>Thanks. Oracle didn't have this scanario documented anywhere. I guess >>they don't expect people to be running multiple instances and multiple >>versions on the same Windows server. > > Both not true. It is possible and it is documented in the Windows > specific documentation, which you obviously didn't read. > > > -- > Sybrand Bakker, Senior Oracle DBA Actually it is true. I did read the docs and it's not there. The 8i documentation details how to upgrade from one version to another, but nothing is mentioned about keeping two services of different 8i releases active. If you claim it's in there then I would challenge you to provide the manual and page #. The only references to oradim in the 8i docs are in 8i the Migration Guide pages 4-15, 7-16, and 13-5. No mention is ever given of multiple 8i services being active. -- Chuck Remove "_nospam" to reply by email |
| |||
| On 30 Jan 2004 14:03:04 GMT, Chuck <chuckh_nospam@softhome.net> wrote: >Sybrand Bakker <gooiditweg@sybrandb.demon.nl> wrote in >news:gqvi10pkugl0cu4h000gkpak7fpgv1stav@4ax.com : > >> On 29 Jan 2004 21:09:59 GMT, Chuck <chuckh_nospam@softhome.net> wrote: >> >>>Thanks. Oracle didn't have this scanario documented anywhere. I guess >>>they don't expect people to be running multiple instances and multiple >>>versions on the same Windows server. >> >> Both not true. It is possible and it is documented in the Windows >> specific documentation, which you obviously didn't read. >> >> >> -- >> Sybrand Bakker, Senior Oracle DBA > >Actually it is true. I did read the docs and it's not there. The 8i >documentation details how to upgrade from one version to another, but >nothing is mentioned about keeping two services of different 8i releases >active. If you claim it's in there then I would challenge you to provide >the manual and page #. The only references to oradim in the 8i docs are in >8i the Migration Guide pages 4-15, 7-16, and 13-5. No mention is ever given >of multiple 8i services being active. Don't be stupid. I mentioned the 'Windows specific documentation', did I? Is thered something wrong with your eyes or your brains, that I have to do your reading? -- Sybrand Bakker, Senior Oracle DBA |
| |||
| Sybrand Bakker <gooiditweg@sybrandb.demon.nl> wrote in news:35bl10178an6ud2vl3r2eaot3ashq18kqv@4ax.com: > On 30 Jan 2004 14:03:04 GMT, Chuck <chuckh_nospam@softhome.net> wrote: > >>Sybrand Bakker <gooiditweg@sybrandb.demon.nl> wrote in >>news:gqvi10pkugl0cu4h000gkpak7fpgv1stav@4ax.co m: >> >>> On 29 Jan 2004 21:09:59 GMT, Chuck <chuckh_nospam@softhome.net> >>> wrote: >>> >>>>Thanks. Oracle didn't have this scanario documented anywhere. I >>>>guess they don't expect people to be running multiple instances and >>>>multiple versions on the same Windows server. >>> >>> Both not true. It is possible and it is documented in the Windows >>> specific documentation, which you obviously didn't read. >>> >>> >>> -- >>> Sybrand Bakker, Senior Oracle DBA >> >>Actually it is true. I did read the docs and it's not there. The 8i >>documentation details how to upgrade from one version to another, but >>nothing is mentioned about keeping two services of different 8i >>releases active. If you claim it's in there then I would challenge you >>to provide the manual and page #. The only references to oradim in the >>8i docs are in 8i the Migration Guide pages 4-15, 7-16, and 13-5. No >>mention is ever given of multiple 8i services being active. > > > Don't be stupid. I mentioned the 'Windows specific documentation', did > I? Is thered something wrong with your eyes or your brains, that I > have to do your reading? > > > -- > Sybrand Bakker, Senior Oracle DBA > Still the same old asshole eh Sybrand. I was referring to windows specific documentation. Oradim isn't used anywhere else asshole. But I guess a "Senior Oracle DBA" should know that. -- Chuck Remove "_nospam" to reply by email |
| ||||
| Chuck wrote: > Still the same old asshole eh Sybrand. I was referring to windows > specific documentation. Oradim isn't used anywhere else asshole. But I > guess a "Senior Oracle DBA" should know that. If you've got a personal problem with Sybrand ignore him. No one is forcing you to read what he writes or to respond. There is no excuse for the "colorful" language used above. Can we have a bit of adult-level more professional conduct ... please. Thanks. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) |