Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

New Database wants 1GB available in /

SOLVED
Go to solution
Victor Geere
Frequent Advisor

New Database wants 1GB available in /

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?
I thought that I was because I had thought.
13 REPLIES
James R. Ferguson
Acclaimed Contributor

Re: New Database wants 1GB available in /

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
Honored Contributor

Re: New Database wants 1GB available in /

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
Frequent Advisor

Re: New Database wants 1GB available in /

echo $ORACLE_BASE returns /oradb, confirming that it has been exported. Any other suggestions?
I thought that I was because I had thought.
Thierry Poels_1
Honored Contributor

Re: New Database wants 1GB available in /

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.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Sukant Naik
Trusted Contributor

Re: New Database wants 1GB available in /

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
Who dares he wins
harry d brown jr
Honored Contributor

Re: New Database wants 1GB available in /

Victor,

What does

env | grep ORA

return?

live free or die
harry
Live Free or Die
Victor Geere
Frequent Advisor

Re: New Database wants 1GB available in /

/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
I thought that I was because I had thought.
Ruediger Noack
Valued Contributor

Re: New Database wants 1GB available in /

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

Re: New Database wants 1GB available in /



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
Well, we all try
Victor Geere
Frequent Advisor

Re: New Database wants 1GB available in /

Neil, are you saying that I should reinstall Oracle?

Thierry, which variables and filenames should I check?
I thought that I was because I had thought.

Re: New Database wants 1GB available in /

Vic

Oops - Sorry - just do the export and try and re-create the database
Well, we all try
Thierry Poels_1
Honored Contributor
Solution

Re: New Database wants 1GB available in /

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.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Victor Geere
Frequent Advisor

Re: New Database wants 1GB available in /

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.
I thought that I was because I had thought.