Oracle Database Discussions

Hi;
Yes it should work, can you post what you put exactly in file?

If you hit any error can you post it here

Regard
Helios

Hi Helios,

Yes it should work, can you post what you put exactly in file?
After giving the path of ]
oracle base= /home/orar12/app/orar12/
and software install location(oracle home path) = /r12/d02/oracle/R12I/db/tech_st/11.1.0

it telling the error,

INS-32016 - the selected oracle home contains directories or files,
INS-32018 - the selected oracle home is outside of oracle base.

Thanks,
vasanth

Hi;

Pelase put similar entery to your oratab file

VIS:/u02/VIS/visdb/9.2.0:N

retest issue

Regard
Helios

Hi again;

For your issue remove what you added or put # beginning of line for your input which mean this line will not be read and try to put this
I assume your SID is VIS

VIS:/r12/d02/oracle/R12I/db/tech_st/11.1.0:N

Regard
Helios

Hi;

You can find details about how you should check edit oratab file from below doc
http://download.oracle.com/docs/cd/B28359_01/server.111/b32009/strt_stp.htm#UNXAR173

Regard
Helios

Hi Helios,

I put the entry in oratab as you suggested. Now in the final step it remains the same..

I clicked the help option on that window, it tells after you click next, DBUA diaplays a dialog as it gathers critical information about your database. This may take few minutes , depending upon the amount of data that is in the database, as well as the current load on the database..

My question is , Whether it will show the database in the list after putting the entry in ORATAB or after clicking next at DBAU it will take some time to configure as they told above.??. If so, how long it will take to complete..?. my database size is 194GB now...

Thanks,
vasanth

Edited by: vasanth on Mar 2, 2011 2:45 PM

Hi;

Did you check log file?

It should be at xxx/11.x/cfgtoollogs/dbua/SID/upgrade

Regard
Helios

Hi Helios,

Pls first let me know the oracle base path and software location path. Im getting confuse on those.

If i give oracle base path /home/orar12/product
and for software location is new oracle home path as /r12/d02/oracle/R12I/db/tech_st/11.2.0.,
means it telling the error and the another error is, My old oracle home path is /r12/d02/oracle/R12I/db/tech_st/11.1.0

What should i want to give in both location..??.

please let know the clear path of the both...


Thanks,
vasanth

Hi vasanth;

We are talking about some issue during upgrade(dbua) or you are mainly asking oracle_base and oracle_home usage?

Please check
oracle_home & oracle_base difference

326192

If you are making dbca you should see your old db on dbua screen

Regard
Helios

Hi,
I started to re install the database.. then in the beginning while giving those path it telling like this....

thanks,
vasanth

Hi vasanth;

You are making EBS db upgrade soo your path should be like that for oracle db 11.2.0.1 software path

your base : /r12/d02/oracle/R12I/db/
your oracle_home= $ORACLE_BASE/tech_st/11.1.0(or you can use /r12/d02/oracle/R12I/db/tech_st/11.1.0 instead of $ORACLE_BASE)

Regard
Helios

Hi Helios,

I completed the steps above as you told for oracle base and oracle home. Now started DBUA , it tells to disable Data vault in oracle home.

I disabled that by relinking and did all the option and made disable. Then continued upgradation, it again tells the same message to disable database vault...

SQL> select * from V$OPTION where parameter='Oracle Database Vault';

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Oracle Database Vault
FALSE


How to clear this.?.

Thanks,
vasanth

Edited by: vasanth on Mar 3, 2011 3:21 PM

Hi;

Please check below docs steps and retest

B Disabling and Enabling Oracle Database Vault
http://download.oracle.com/docs/cd/B19306_01/server.102/b25166/dvdisabl.htm

Regard
Helios