on 04-15-2010 7:48 AM
Hello All,
I have serious problem with oracle software... What I have done is, I had a SAP system B01 and for some reasons i want to change this to A01. This means that not only database name but also, i want the Oracle home to be chnaged to /oracle/A01/920_64 from /oracle/B01/920_64.
With the help of UNIX team, i have changed the mount points to /oracle/A01/920_64 and changed the referances in .profiles,.sapenv, .dbenv, listener,/etc/oratab,/etc/oraInst.loc, init.ora,initSID.ora.
when i tried to login as ora<sid>, i got a problem that oracle is unable to load libjox9.a with reason that file or path not found. I have added LIBPATH to /oracle/A01/920_64/lib: and lib32. Then it allowed me login to the database.
When i try to login as <SID>ADM , its not allowaing me to log into the database. its showing the error that libjox9.a couldnot be located.
MY QUESTION is DOES SAP ALLOW THIS SCENARIO? (COPYING ORACLE SOFTWARE or changing the home of exiting SOFTWARE)
Could you please help me with this?
PS: I have already changed the permissions of oracle executable with Sticky BIt
>
> MY QUESTION is DOES SAP ALLOW THIS SCENARIO? (COPYING ORACLE SOFTWARE or changing the home of exiting SOFTWARE)
Clear and simple: NO, this is not supported nor is it recommended.
There are way more fixed path dependencies than what one would expect at first sight!
Therefore, the only supported way is to reinstall the software into a new Oracle Home.
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars,
Thanks for the reply. So the only solution i have is to re-install new oracle software?? When I try to install inew ORACLE_HOME i am getting below error
**** Error Dialog: There was an error during loading library : generalQueries ****
and .err file has below contents
oracle.sysman.oii.oiif.oiifb.OiifbCancelException: java.io.IOException: error in opening zip file
at oracle.sysman.oii.oiis.OiisCompContext.doQuery(OiisCompContext.java:2318)
at Components.oracle.swd.jre.v1_3_1_0_0.CompContext.getCalculatedValueObject_PROD_HOME(CompContext.java:384)
at Components.oracle.swd.jre.v1_3_1_0_0.CompContext.getCalculatedValueObject(CompContext.java:231)
at oracle.sysman.oii.oiis.OiisCompContext.getCalculatedValue(OiisCompContext.java:612)
at oracle.sysman.oii.oiis.OiisProdHomeVar.getCalculatedValue(OiisProdHomeVar.java:199)
at oracle.sysman.oii.oiis.OiisVariable.setVariable(OiisVariable.java:1353)
at oracle.sysman.oii.oiis.OiisProdHomeVar.computeVarValue(OiisProdHomeVar.java:311)
at oracle.sysman.oii.oiis.OiisCompInstallation.calculateProdHome(OiisCompInstallation.java:609)
at oracle.sysman.oii.oiis.OiisCompInstallation.initContext(OiisCompInstallation.java:325)
at oracle.sysman.oii.oiic.OiicInstallSession$CompInit.initComp(OiicInstallSession.java:1379)
at oracle.sysman.oii.oiic.OiicInstallSession$CompInit.run(OiicInstallSession.java:1307)
I git struck with this during pre-requisite checker phase itself. Kindly Suggest
Also, Interestingly Application is running fine after the ORACLE_HOME change. R3trans works fine. All actions which use OPS$ mechanism to login into the database works perfect
Only <SID>ADM is unable to do sqlplus '/ as sysdba' or when we suppy a user or password. Cant we fix this with re-installing the software?
Guys, I am running out of ideas,,, Kindly HELP ME
Okay, in that case you can delete the P11 user, but it doesn't harm if you leave it there..
So R3trans -d with the adm user is working, but sqlplus '/as sysdba' isn't, right?
Have you ran sapdba_role.sql to set the correct permissions?
And check the user environment if there are still variables that point to the previous SID.
Kind regards,
Mark
In addition to the other suggestions:
Is your <sid>adm user a member of group dba?
That being said, I agree with all those replies that say it would be easier to do a fresh install and a homogeneous system copy afterwards.
You may be able to overcome all the problems. But I doubt that it's worth it.
Just my 2 eurocent.
Run a relink all with the oracle user.
And change all environment files of the Oracle and SAP users.
Kind regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.