Operating System - HP-UX
1748182 Members
3535 Online
108759 Solutions
New Discussion юеВ

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

 
SOLVED
Go to solution
Frank de Vries
Respected Contributor

DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Hpux 11.00 (64bit)

We have a strange phenomenon with the oracle upgrade tool dbua. (v9.2.0.8)

We launch it and select the db to upgrade,
then we press finish, it pops up a complaint
it needs 90MB for a new tablespace.

It got us BAFFLED !!.

The filesystem concered has more then 3,5Giga free, a double check confirms that:
[root@orasrv2:]/devnew/oracle/oradata/D03<>>> bdf .
Filesystem kbytes used avail %used Mounted on
/dev/DEVN/lvora 8192000 4076664 3858187 51% /devnew/oracle

I have seen from the trace.log that the freespace check returned a value of 71Mb free.
We have only one filesystem with 71Mb free and
that is root.

Unfortunately I cannot easily extend root as it has an contiguous policy, and I don't
realy want too.

Has anyone had similar problems ?
Does anyone know a workaround or force for this
rather 'unintelligent' spacecheck of dbua ??
Look before you leap
10 REPLIES 10
Hein van den Heuvel
Honored Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB


Could this be a simple typo in the path, causing it to miss a softlink over to the real device?

If you pass that exact path (cut & paste) directly to bdf, what does it report?

/devnew/oracle/oradata/D03

Should that be:

/devnew/oracle/oradata/D030

Groetjes,
Hein.
Frank de Vries
Respected Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Hi Hein

I am trying to understand what you are saying.

I am hardly typing anything,
just start ./dbua and take it from there.

The environment is realy simple (yet)

[oradev@orasrv2:]/home/oradev<>>> set | grep ORA
ORACLE_BASE=/devnew/oracle
ORACLE_DOC=/devnew/oracle/product/9.2.08/odoc
ORACLE_HOME=/devnew/oracle/product/9.2.08
ORACLE_SID=upgrade
ORACLE_TERM=hpterm
ORAENV_ASK=Yes
ORAHOME=/devnew/oracle/product/9.2.08
ORASID=upgrade
ORA_NLS33=/devnew/oracle/product/9.2.08/ocommon/nls/admin/data

The $ORACLE_BASE is a filesystem
called /devnew/oracle

You mean I should have a directory called
/devnew/oracle/oradata/D030 ??
Because I haven't.
But then it is anyway on $ORACLE_BASE

The instance that I am trying to upgrade is called D03 (dee zero three).

Look before you leap
Hein van den Heuvel
Honored Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

The suggestion I made for D030 was because that is a name which seems to be used elsewhere in the log. For example: "/devnew/oracle/admin/D030/upgrade"

I saw the mountpoint for /devnew/oracle in the original post, but just imagine that oradata, or the D03 is in fact a softlink back to root. Unlikely, still.

I tend to check that by using
#bdf devnew/oracle/oradata/D03

This will always go back and report on the right mountpoint behind that exact path.
Looking back, you may have implied that with
the "<>>>" notation, but I read that too quickly.

Sorry, no better suggestions for now.
Hein.
Frank de Vries
Respected Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Okay fair enough.
I have posted a call on metalink,
curious to hear what the excuse is.
Look before you leap
Volker Borowski
Honored Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Hi,

do you have user quotas active for the oracle user on this new filesystem (which may default to 70Megs) and therefor does not show more space available to this user ?
At least the log does not look like there is a typo involved.

Volker
Yogeeraj_1
Honored Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

hi frank,

Good that you have escalated the problem to Oracle Metalink.

In the meanwhile, can you try to create a new tablespace (before upgrade) on the file system identified by: /devnew/oracle/oradata/D03

This will be just to verify if you have any problem on the file system side.

let us know.

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Frank de Vries
Respected Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

I tried all that, to no avail.
There is an inbuild function that pre-checks
for space , if it is not satisfied it
simply aborts.

Oracle metalink came back to me it should
have something to with ORACLE_BASE ?
Unlikely, but I am looking into this.

Another scenario that I am considering is
the effect of Mc/Serviceguard.
The filesystems are not mounted directly via fstab, but via the package of Mc/Sg.
Although the mount command shows the corrects
names and mountpoints.

But then again I do not know what the dbua function is checking, and maybe it is outside the scope of Mc/Sg.

Still working on it.
Any ideas welcome.
Look before you leap
Eric Antunes
Honored Contributor
Solution

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Hi Frank,

dbua has its secrets... :)

I had to increase the rollback definition sizes like "Next value", "Maxsize value"... in the dbua configuration file ($ORACLE_HOME/assistants/dbma/mep.cfg). The file looked like this after those changes:















I hope this will help,

Eric
Each and every day is a good day to learn.
Frank de Vries
Respected Contributor

Re: DBUA DESPITE ORACLE FILESYSEM WITH 3,5GIGA FREE, POPUPS ERROR ASKING FOR 90MB

Thanks for your answers,
seems that dbua is quite fussy and at best buggy.

I will do a manual install , since
I had new errors after I got passed this one.


Look before you leap