Re: Oracle 8 on Netware! HELP! Documentation SUCKS!

Hi,

For those who may want to know how to do this (since Deja news turned up nothing I figured nobody every really answered it) Here's what I did.

1. I created the instance in EASYCFG. I did not end up needing to create new Listener(s) as the predefined ones work just great and you can have more than 1 instance per listener. If you muddle through the online documentation long enough you find a sample which includes creating a Listener. Do not do this - it just makes it harder.
2. Once I created the instance in EASYCFG I then created an Alias for the instance - using the same name. I needed this because the SET INSTANCE command in SVRMGR would not work with the Instance unless I created the alias.
3. Either create a password file (there is a password file creation utilitiy and some online documentation) or copy and rename the demo database password file so that it is called pwd{ORACLE_SID}.ora. This sets the INTERNAL pasword for the new instance called ORACLE_SID.
4. Run SVRMGR30 (in novell you need to LOAD SVRMGR30)
5. Do these commands

SET INSTANCE ORACLE_SID
   (should return a bunch of memory usages for the instance) CONNECT INTERNAL
   (enter the password when asked)
STARTUP NOMOUNT PFILE='SYS:\ORANWxxx\DATABASE\INIT{oracle_SID}.ora';

5) Now you're connected to the instance and you can create the database etc...

Hope this helps someone in the future,

-Rob

Robert Jolliffe wrote:

> Hi,
>
> So far as I can see Oradim only works on an NT Box - wheras I have a Netware
> box. Am I wrong about this?
>
> Thanks
>
> -Rob
>
> Van Messner wrote:
>
> > You use the oradim utility to create, stop, start, delete an instance. With
> > that utility you can also set a password for "internal".
> >
> > Van
> >
> > Robert Jolliffe <rjolliffe_at_lycosmail.com> wrote in message
> > news:3790BD38.ED6E8DE9_at_lycosmail.com...
> > > Thanks for the response Wozi,
> > >
> > > I tried the set instance command as you specified below and it returned
> > the
> > > following error:
> > >
> > > PRA-064000 NETCMN: No default host string specified.
> > >
> > > I also used easycfg to create an Alias and found that I can:
> > >
> > > SET INSTANCE aliasName
> > >
> > > Successfully, but when I try and do a CONNECT INTERNAL it askes me for a
> > > password. When I created the instance it did not ask me for a password -
> > so
> > > what am I to do? I've tried all the stand by's (ORACLE, MANAGER,
> > > CHANGE_ON_INSTALL etc...). This Instance does not contain a database. I
> > > "created" the instance in easycfg - is that the correct place?
> > >
> > > Thanks
> > >
> > > -Rob
> > >
> > >
> > >
> > >
> > > wozi wrote:
> > >
> > > > : Load Svrmgr30
> > > > The SVMGR30> prompt appears:
> > > >
> > > > svrmgr30> SET INSTANCE S:VMFG
> > > > svrmgr30> CONNECT INTERNAL
> > > >
> > > > Note that if you are connecting with SID other than ORCL, you will
> > > > need to 'set instance s:instance_name'
> > > >
> > > > Chect out the Oracle 8 Getting Started Manual
> > > > wozi_at_dhc.net
> > > >
> > > > Robert Jolliffe wrote in message <378FA33A.D018E415_at_lycosmail.com>...
> > > > >Hi,
> > > > >
> > > > >Maybe it's just me but the documentation and technical support of
> > Oracle
> > > > >seems to SUCK!
> > > > >
> > > > >I'm trying to install a new database on an Oracle 8 for Netware
> > > > >configuration. The default database which ships with Oracle works
> > > > >fine. I'm trying to create a new instance and database called VMFG.
> > > > >
> > > > >What I can't figure out is the following:
> > > > >
> > > > >In SVRMGR30 I can't set the current instance until I'm in the
> > > > >application. I've kept the default listener (ROBSERVER_LSNR) on my
> > > > >server and I've added an instance called VMFG in easycfg. This seems
> > > > >pretty strait forward.
> > > > >
> > > > >I then go into the LSNCTL80 program and check STATUS and SERVICES. It
> > > > >reports the two services (VMFG and ORCL) are running.
> > > > >
> > > > >I then go into the SVRMGR30 and try and connect to the VMFG instance.
> > I
> > > > >can't figure out how to do this. I seem to be connecting to the ORCL
> > > > >instance without a problem. When I try and connect to the VMFG
> > instance
> > > > >I must have the syntax of the connect statement wrong. When I try the
> > > > >SET INSTANCE = VMFG or SET INSTANCE VMFG I get an can't find service
> > > > >name error.
> > > > >
> > > > >Unfortunately Oracle's WONDERFUL Documentation doesn't seem to even
> > hint
> > > > >at how to use it. I can't find any documentation on SVRMGR30 ANYWHERE!
> > > > >It's driving me nuts!
> > > > >
> > > > >Any help appreciated.
> > > > >
> > > > >-Rob
> > > > >
> > >
> > >

CREATE INSTANCE ORACLE NETWARE Received on Tue Jul 20 1999 - 10:44:46 CDT