New Database wants 1GB available in /

[Victor Geere]

When I try to create a new database it is looking for 1GB available in the / mount point even though the $ORACLE_BASE paramater is set to /oradb with 20GB available.

If this is not some parameter setting problem, can I increase the size of / without reinstalling HP-UX?

[James R. Ferguson]

Hi Victor:

The ORACLE_BASE is not set. Did you export it into the environment in which you need it?

You certainly do not want to increase the size of the '/' filesystem!

Regards!

...JRF...

[Trond Haugen]

I certainly hope there is some parameter setting problem - is $ORACLE_BASE exported?
There should not be any reason to extend / to hold such a amount of data. And yes, you would have had to reinstall.

Regards,
Trond

[Victor Geere]

echo $ORACLE_BASE returns /oradb, confirming that it has been exported. Any other suggestions?

[Thierry Poels_1]

Hi,

ORACLE_BASE & ORACLE_HOME normally only define where the Oracle software is located, NOT where the database's datafiles are.
Check the filenname or variables for the datafiles.

As mentionned '/' should not be extended, nor used for user or data files.

regards,
Thierry.

[Sukant Naik]

Hi Victor,

This is a issue of ORACLE_BASE being not set properly.

How are you creating a database. Are you using some script. Can you set the ORACLE_BASE variable in the script and then try to create the database ?

We need more info about how you go about your database creation.

And there is no need to increase the size of the root.

-Sukant

[harry d brown jr]

Victor,

What does

env | grep ORA

return?

live free or die
harry

[Victor Geere]

/home/oracle>env | grep ORA
ORACLE_BASE=/oradb
ORACLE_SID=dia2
ORACLE_TERM=xterm
ORA_NLS33=/oracle/product/9.0.1/ocommon/nls/admin/data
ORACLE_HOME=/oracle/product/9.0.1

[Ruediger Noack]

I agree with the other guys. ORACLE_BASE isn't exported. Check out with:
env| fgrep ORACLE_BASE
echo shows you only the vars in your current shell, not from subshells or a executable started from this shell.

Ruediger

[Niel Greeff_1]

echo $ORACLE_BASE

will give you the value in the current shell. Once the Oracle install starts it will source the variables, but only those exported from the current shell.

After setting the ORACLE_BASE variable (which you have done correctly), try

export $ORACLE_BASE

before starting the install again


Hope that helps
N

[Victor Geere]

Neil, are you saying that I should reinstall Oracle?

Thierry, which variables and filenames should I check?

[Niel Greeff_1]

Vic

Oops - Sorry - just do the export and try and re-create the database

[Thierry Poels_1 · Accepted solution]

hmmm, I have to take back some of my words :(

ORACLE_BASE <> used to define the location of datafiles in Oracle's Optimal Flexible Architecture (OFA). Sorry, never followed the book by the letter on this one ;-)


I referred to the "create tablespace ... datafile 'xxx' " statements, check the datafile values.

good luck,
Thierry.

[Victor Geere]

Problem solved.
Thanks.

Because $ORACLE_BASE wasn't set during installation the pfile was sitting under $ORACLE_HOME and I just had to point it in the right direction.

Thierry, you get the points.