Home » RDBMS Server » Server Administration » Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script (Solaris 64, Rdbms)
icon9.gif  Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586579] Fri, 07 June 2013 10:09 Go to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

Hello.
I am trying to upgrade and 64bits Oracle database from 11.2.0.2 to 11.2.0.3.0 (after that ill install .6)
But when i try to upgrade the binaries, i get a message that does not find the instance to upgrade.
If i skip that msg and try to upgrade the binaries only, i get another one message that in that ORACLE_HOME there are another binaries installed and it forces to choose another directorie.
Then i try to set my enviroments variables using . oraenv but (as oracle owner) i don't have permissions over . oraenv.

That's make me think that someone does a bad installation then i tried to fix it using $ORACLE_HOME/install/changePerm.sh and i did not found it (after searching on metalling i found the note 834626.1 that says that in Oracle 11 there is not anymore changePerm.sh.
Ok then does any have a idea how can i fix that problem?

Originally i moved 11.2.0.2 binaries to another directory and installed (after changing the loc on xml of the oraInventory) and installed the 11.2.0.3 binaries in my old ORACLE_HOME and imported init, listener, tnsnames and works fine.
But there are a lot of databases with the same problems and i don't wanna use the same workaround.

By the way my metallink has a problem that only i can see and i can't create SR Sad (my account admin is working on solve it).
thank you you !!!
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586580 is a reply to message #586579] Fri, 07 June 2013 10:27 Go to previous messageGo to next message
BlackSwan
Messages: 23024
Registered: January 2009
Senior Member
I suspect that Oracle Inventory does not know about what you deem to be ORACLE_HOME.
Simply put, if Oracle Universal Installer did not create the ORACLE_HOME, then you'll be prevented from applying any upgrade to this directory.
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586583 is a reply to message #586580] Fri, 07 June 2013 10:34 Go to previous messageGo to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

mmmm but Oracle inventory seems to be ok, that's why i must to modify it cause see that there are binaries installed on that directory
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586584 is a reply to message #586583] Fri, 07 June 2013 10:56 Go to previous messageGo to next message
BlackSwan
Messages: 23024
Registered: January 2009
Senior Member
You are free to believe whatever you want to believe.
You don't have to convince me about anything involving your system.
The conflict is between you & the Oracle software.
Fortunately for all of us, Oracle software reports reality better than confused & befuddled keyboard operators.

I'll stop wasting my time trying to enlighten you.
You're On Your Own (YOYO)!

[Updated on: Fri, 07 June 2013 11:05]

Report message to a moderator

Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586585 is a reply to message #586584] Fri, 07 June 2013 11:05 Go to previous messageGo to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

Ok if you're right how can i fix it? cause you say that i must
Simply put, if Oracle Universal Installer did not create the ORACLE_HOME, then you'll be prevented from applying any upgrade to this directory.
Ok when i use universal installer,
1.- when i try to upgrade database, says that there is noone database to upgrade (how can i fix it message?)
2.- when i try to install binaries into the the original ORACLE_HOME, it says that there are binaries (how can i fix it?) cause in both cases i can't continue

That system was not installed by me, and never saw something like that (i know that something on the original installation was wrong)
thank you you and sorry
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586589 is a reply to message #586585] Fri, 07 June 2013 11:46 Go to previous messageGo to next message
John Watson
Messages: 4791
Registered: January 2010
Location: Global Village
Senior Member
Can you take a step back? Put everything back as it was before you started moving things around?
The 11.2.0.3 upgrade is perfectly straightforward: install into a new Oracle home, apply the Opatch patch, apply the latest bundle patch. Then upgrade your databases one at a time.
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586591 is a reply to message #586589] Fri, 07 June 2013 13:25 Go to previous messageGo to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

John thank you you for your answer,
The app support says that i must upgrade binaries on the same ORACLE_HOME.
I have a lot of instances to upgrade and all has the same problem that the first one.
I know that installing into another ORACLE_HOME and using the procedure that you told will work perfectly but it is not a option cause the app Sad
That's why i am asking if someone sometime has the same problem.
thank you you again!!!
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586896 is a reply to message #586591] Tue, 11 June 2013 08:40 Go to previous messageGo to next message
thorin666
Messages: 140
Registered: March 2007
Senior Member

Ok now i opened an SR. and the support refers to a document about installations
http://docs.oracle.com/cd/B19306_01/em.102/b16227/c_oui_appendix.htm#sthref534

now i get two errors....


[WARNING] [INS-32016] The selected Oracle home contains directories or files.
CAUSE: The selected Oracle home contained directories or files.
ACTION: To start with an empty Oracle home, either remove its contents or choose another location.
[FATAL] [INS-35071] Global database name cannot be left blank.
CAUSE: The Global database name was left blank.
ACTION: Specify a value for the Global database name.

I don't know why are these errors
I am using the -force flag and acording with the documentation ...
-force This allows silent mode installation on a non-empty directory without warning.


./runInstaller -silent -debug FROM_LOCATION="/u05/software/Oracle-Patchs/database/stage/products.xml" ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1" ORACLE_HOME_NAME="Oracle11gr2" ORACLE_SID="DLSHRDES" TOPLEVEL_COMPONENT='{"oracle.patchset.db","11.1.0.7.0"}' DECLINE_SECURITY_UPDATES=TRUE -force


I have not another directory to make a clean install does any know what i am doing wrong?
Regards
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586897 is a reply to message #586896] Tue, 11 June 2013 09:03 Go to previous messageGo to next message
John Watson
Messages: 4791
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I have not another directory to make a clean install does any know what i am doing wrong?
Regards
What you are doing wrong is that you are destroying your entire environment. You need to return it to the original state, and follow my advice. When your client says thisQuote:
The app support says that i must upgrade binaries on the same ORACLE_HOME.
you need to explain that it is not technically possible.

Punkt.
Re: Problem patching from Oracle 11.2.0.2 to 11.2.0.3 + changePerm.sh script [message #586899 is a reply to message #586591] Tue, 11 June 2013 09:47 Go to previous message
gazzag
Messages: 353
Registered: November 2010
Location: Bristol, UK
Senior Member
thorin666 wrote on Fri, 07 June 2013 18:25

The app support says that i must upgrade binaries on the same ORACLE_HOME.


As John says, not possible. If space is an issue you can de-install the old home once you've installed the new one.
Previous Topic: Space management in 10g + high water mark
Next Topic: analyze full database
Goto Forum:
  


Current Time: Thu Nov 20 15:48:15 CST 2014

Total time taken to generate the page: 0.09959 seconds