Re: Error just after install

"Daniel A. Morgan" wrote:

> "Joel A. Stevens" wrote:
>
> > Hello-
> > I am underway with a trial version of Oracle 8.0.6 on an
> > IBM AIX box. The Installer left me with what looks to be
> > a fine install. I do not yet have any database created. I
> > simply want to get a sanity check to verify that things are in place.
> > Per the Oracle documentation, I login as oracle, run "svrmgrl"
> > followed by "connect internal" and "startup" and am met
> > with a quick error message of:
> > ORA-02899 smscre Cannot create SGA with Extended
> > Shared Memory Feature.
> > IBM AIX RISC/System/6000 Error 12: Not enough space.
> > In checking my existing file systems, I have at least 10 MB
> > free in the "/" (root) directory and well over 200 MB free
> > in the file system where I installed Oracle. I have not yet
> > created any database, only installed the program code. I can
> > certainly startup SQL*Plus but am looking for a file system or
> > area where Oracle needs more room and does not have
> > what it needs.
> > I can increase file system sizes and keep chasing this as the
> > source of the problem but am wondering if this is symptomatic
> > of a more general config problem or alternatively would
> > certainly increase the necessary file system if I could find out
> > which one is too small.
> > Thanks for any help on this one.
> >
> > Joel A. Stevens
> > joelst_at_nsis.net
>
> Did you read the documentation or just run the installer?
>
> If AX is anything like other versions of UNIX, and I'm sure it is, there
> is an entire check list of steps you must take before and after
> installing Oracle which it appears you didn't follow. I would suggest
> reading the readme file, making the required changes for shared memory,
> etc. and rebooting the system. Hopefully the other things you did won't
> require a complete reinstall but I wouldn't be surprised.
>
> PS: You do not go into svrmglr and type STARTUP ... you type STARTUP
> NOMOUNT PFILE=<and the path to your init.ora>
>
> (ignore capitals above they are just there for emphasis)
>
> Daniel A. Morgan

Sorry for not being more comprehensive with my initial post. I was actually running a standard SQL script when I was starting Server Manager in that it had
 connect internal
 startup mount pfile=<path the init<sid>.ora  create database....

but, as I mentioned above, the idea of being low on space somewhere just didn't seem right. Sure enough, in the AIX world, when you are running AIX 4.3.3 only, you need to have the environmental variable EXTSHM undefined. Well, I had used EXTSHM= in my .profile and what I really needed was simply to not even have EXTSHM exported as a variable. That is the only change I made and I in business now. I never changed any of my file settings. Thank you very much for your assistance in helping me solve this problem. I appreciate your prompt response.

Joel Stevens
joelst_at_nsis.net Received on Mon Jun 04 2001 - 12:19:39 CDT