UNIX Oracle Upgrade 10 to 11

[Former Member]

Current Environment: SAP Dev System Oracle Version 10, UNIX HP v11

I am trying to upgrade the Oracle Database from 10 to 11.3, when I run the OUI it cancels or errors out at the following step i.e. Provide Previliged user groups. I know I have to select the default entries provided but when I select that it fails.

Also when I change the default entries it still fails.

I have checked the groups i.e. DBA and OPER.

I have changed the entries in /etc/group file and edited using Vi editor and added ora<SID> in group file under dba group, after reading the SCN blogs.

Can some one help this I cannot move past this step.

Help is appreciated.

[Former Member]

Hi,

Kindly give me the screen shot as you got error.

Thank you

Mahendran

[Former Member]

Folks I ran the ./RUNINSTALLER_CHECK in /oracle/stage/11203/database/SAP and the following things have failed and are not fixable,

-------------------------------------------------------------------------------

1. User Existance - oraecd           Status - Failed Fixable - No
2. Group Existance - dba              Status - Failed Fixable - No
3. Group Membership - dba           Status - Failed Fixable - No
4. Run Level                                 Status - Failed Fixable - No
5. Architecture                             Status - Failed Fixable - No
6. OS Kernel Version                    Status - Failed Fixable - No
7. OS Kernel Parameter - maxfiles_lim Status - Failed Fixable - No
8. USers with Same UID                Status - Failed Fixable - No

Then there are a list of PH* patches which have a warning status and are fixable/nonfixable.

I do not understand I am installing the Oracle with the oraecd user and it does belong to group dba as I have used the vi editor to change the settings in the /etc/group file.

id ora<sid>

uid=110(ora<sid>) gid=108(dba)

id <sid>adm

uid=109(<sid>adm) gid=107(sapsys)

Following are a few line from the group file:

sapinst::106:<sid>adm,ora<sid>,root

sapsys::107:<sid>adm,ora<sid>,root

dba::108:<sid>adm,ora<sid>,root

oper::109:<sid>adm,ora<sid>

I Have ran the RUNFIXUP.SH script but the errors still remain.

Help is appreciated

[Former Member]

Can you please check this note

Note 1431796 - Oracle 11.2.0: Troubleshooting the Software Installation -

Thanks

[former_member227600]

Hi,

Can you please run below command & post the result .

cd /

ls -ltr |grep oracle

ls -ltr |grep /oracle/<SID>

ls -ltyr |grep /oracle/<SID>/11203

Regards

Ram

[Former Member]

Hi Ram,

ls -ltr | grep oracle

drwxrwxr-x   7 ora<sid>     dba           1024 Dec 27 17:15 oracle

ls -ltr | grep /oracle/<sid>

blank

ls -ltr | grep /oracle/ECD/11203

blank

[Former Member]

Hi Rishi,

chec ked the note and ran the OUI with the option -ignoreInternalDriverError, but still the errors I think I need to install the patches in the Unix Server.

[Reagan]

Hello

id ora<sid>
uid=110(ora<sid>) gid=108(dba)

orasid should be part of dba and oper groups.

Secondly you need to have a compatible OS for 11G installation.

Check the previous link I have provided.

Also could you tell me the size of the file system /oracle/SID ?

Is the file system /oracle/SID getting full when you run the scripts RUNINSTALLER_CHECK or RUNINSTALLER ?

If yes then extend the file system with more space and restart the script.

Regards

RB

[Former Member]

Hi Reagen,

How do I make ora<sid> user part of the oper user, is there a specific command.

Also I will check the space on the /oracle/<sid> mount when I run the ./RUNINSTALLER on monday.

I think I do need the patches on the HPUX there is a list of like 8 patches that is avaliable on the following page:

http://docs.oracle.com/cd/E11882_01/install.112/e10867/toc.htm

some of them are already installed that I checked with the following command:

# /usr/sbin/swlist - l  patch | grep <Patch No.>

or

# /usr/sbin/swlist - l patch  | more

Thanks.

[Reagan]

You need to use the usermod command

usermod -G oper,sapsys oraecd

Regards

RB

[Former Member]

Thanks Reagan,

I have changed the oraecd groups, now I am waiting for the data Center team to appply the HP unix patches, will update when that gets done.

Thanks a much.

[Former Member]

Hi Raegan,

I have changed the Groups but still I am getting the same errors, I am waiting for the Unix Admin to install the HP patches.

I wanted to find out from you that if it is okay to RUNINSTALLER with -ignoreInternalDriverError, which gives me the checkbox to ignore all errors, but the Installer tells me that the configuration might not be proper.

Do you have any knowledege about this option and if it is okay to go ahead with this option or shall I wait for the Unix Admin to install the Patches for the HP UX

[Former Member]

Hi

You need to have the OS Patches installed before proceeding ahead with the Upgrade activity .

Would not suggest to use the ignoreInternalDriverError option !!

Thanks

Rishi

[Former Member]

Thanks Rishi for the quick reply. I was thinking the same thing.

Will update the post as soon as the patches are applied.

[Reagan]

Hello

Without the OS patches you will only have trouble with Oracle installation.and also during the database upgrade.

You should get all the OS patches applied on the system.

Regards

RB

[Former Member]

Hi

can you please provide the error log / details of the issue like screenshot .. would be helpful to suggest ahead.

Thanks

Rishi

[Former Member]

Hi Rishi I am attaching the log details, I am getting the error when  you have to enter the Operating System Groups.

I am selecting the default values provided by the OUI i.e. DBA as OSDB and OPER as OSPER Group and then it throws the Error saying- INS30060 Check for Group Existence Failed.

--------------------------------------------------------------------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=hostname
UNIX_GROUP_NAME=dba
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle/<SID>/11203
ORACLE_BASE=/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=true
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.2.0,oracle.rdbms.rat:11.2.0.2.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.isRACOneInstall=false
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
#INVENTORY_LOCATION=
.
. (INFO)    -  Starting Oracle Universal Installer in interactive mode - please wait ...
.
.
. (INFO)    -  Oracle Universal Installer finished.
. (INFO)    -  Name of OUI session log file not found.
.
. OUI output:
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 415 MB.   Actual 9579 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 32768 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /oracle/<SID>/.11ginstall_11203.tmp/OraInstall2013-12-26_03-20-11PM. Please wait ....
.
. Performing clean up tasks ...
. Clean up tasks completed.
.
. Post-installation tasks are not executed.
. Reason: error during installation
. Post-installation tasks have been skipped.
.
. Installation Results
. (ERROR)   -  Oracle Database software installation finished with errors.
. The Oracle executable /oracle/<SID>/11203/bin/oracle is empty or does not exist.
. Possible cause(s): link error, installation was cancelled or interrupted, or fatal error.
. (INFO)    -  You can find the installation summary log at /oracle/<SID>/11ginstall_11203.log
. (EXIT)    -  Exiting with exit code 2.

----------------------------------------------------------------------------------------------------------------------------------------

[Former Member]

Hi,

>> . (ERROR)   -  Oracle Database software installation finished with errors.

>> . The Oracle executable /oracle/<SID>/11203/bin/oracle is empty or does not exist.

The error shows that the /oracle/<SID>/11203/bin/oracle folder is not empty.

Best regards,

Orkun Gedik

[Former Member]

There might be a permission problem on the "oracle" folder, also

[Reagan]

Hello

If you installing Oracle 11.2.0.3 software then there should be nothing under /oracle/SID/11203

Do you have all the OS level patches for HP-UX installed for 11G installation ?

Check this link and select the HP-UX according to the one you use.

Check the software requirements section to identify the OS patches required.

Oracle Database Online Documentation 11g Release 2 (11.2)

If possible upload this file /oracle/<SID>/11ginstall_11203.log

Regards

RB