Visit Counter

Wednesday, August 2, 2017

Installation Failing With Error RW-50010 and RW-50004 on Linux x86-64 Oracle Linux 6



While installing Oracle EBS R12.2 I'm getting below error.

Log file path:

/ora/appsoft/VIS/11.2.0/temp/VIS_apps12/logs


/ora/appsoft/VIS/11.2.0/appsutil/log/VIS_apps12

....
....

RW-50010: Error: script has return an error: 127
RW-50004: Error code received when running external process check log file for detials
Running Database install driver for VIS instance


Solution:




Workaround:



1. export LD_BIND_NOW=1
2. clean up the old installation files
3. reinstall the application




Refer: (Doc ID 2100852.1)

Tuesday, August 1, 2017

RW-20006 error - database port value is not valid




While installation Oracle EBS R12.2 getting error...Actually I deleted all (APPS & DB Home) folders because installation was failed but instance working so I just killed the process.




... Error:- Database Port value is not valid:port value = 1521 DB ONS Local port value=6300 ... RW-20006: Error:- Database Port value is not valid: ...




[root@localhost VIS]# ps -ef|grep VIS

root      4087 31667  0 11:11 pts/6    00:00:00 grep VIS

oracle   19255     1  0 Jul31 ?        00:00:00 /ora/ora122/VIS/11.2.0/bin/tnsls        nr VIS -inherit


[root@localhost VIS]# kill -9 19255


[root@localhost VIS]# ps -ef|grep VIS


root      4090 31667  0 11:11 pts/6    00:00:00 grep VIS


[root@localhost VIS]#


Thursday, July 27, 2017

Fatal Error: TXK Install Service


Log File:

/ora/oracle/VIS/12.1.0/appsutil/log/VIS_localhost
[root@localhost VIS_localhost]# ls
07272033.log


Executing command: /ora/oraapps1225/startCD/Disk1/rapidwiz/jre/Linux_x64/1.6.0//bin/java/bin/java -cp /ora/oracle/VIS/12.1.0/temp/VIS_localhost/DBInstallHome/fnd/../j22065856_fnd.zip:/ora/oracle/VIS/12.1.0/temp/VIS_localhost/DBInstallHome/fnd/java/3rdparty/stdalone/xmlparserv2.zip -Doracle.apps.fnd.txk.env_home=/ora/oracle/VIS/12.1.0/temp/VIS_localhost/ -Doracle.apps.fnd.txk.runtime.config=/ora/oracle/VIS/12.1.0/temp/VIS_localhost/xmldocs/instDB.xml oracle.apps.fnd.txk.config.InstallService

Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=253 See log for details. CMD= /ora/oraapps1225/TechInstallMedia/database/database/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent  -responseFile /ora/oracle/VIS/12.1.0/temp/VIS_localhost/cfgHome/response/DB_HOME/txkDB12cR1_12102.rsp

    at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:160)

    at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)

    at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)

    at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)

    at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)

    at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)

    at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)

    at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)

    at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)



Cannot install Oracle Database Home






Solution:

1. Edit both staging files for database:


 - Oracle RDBMS


location: <stage_area>/TechInstallMedia/database/database/stage/cvu/cvu_prereq.xml

 - Oracle Examples


location:<stage_area>/TechInstallMedia/database/examples/stage/cvu/cvu_prereq.xml


2. Modify the value of kernel value in prerequisites check file from 2.6.39 to 2.6.32 and save.



3. Retry the installation.






(Doc ID 2155494.1)


Refer:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=484720799765053&id=2155494.1&_adf.ctrl-state=dvos1rc5a_65




Friday, July 21, 2017

RW-00048: Error: Verify that the format of the file /etc/hosts is of the form "IPAddress hostname.domainname hostname""


Problem:   host/Domain



"Host/Domain
command: /bin/ping -c 1 localhost 
PING localhost (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.049 ms

--- localhost ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 0ms
rtt min/avg/max/mdev = 0.049/0.049/0.049/0.000 ms

host ping has succeeded
command: /bin/ping -c 1 localhost.david 
ping: unknown host localhost.david

RW-50011: Error: - host.domain ping has returned an error: 2 System variable PATH set to:
/usr/bin:/media/disk/Temp/u01/StageR12/startCD/Disk1/rapidwiz/unzip/Linux:/usr/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin:/usr/ local/bin:/usr/local/sbin


RW-00048: Error: Verify that the format of the file /etc/hosts is of the form "IPAddress hostname.domainname hostname""




# cat /etc/hosts


127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
: : 1         localhost localhost.localdomain localhost6 localhost6.localdomain6


192.0.0.10 localhost.apps





Solution:


# vi /etc/hosts


192.0.0.10 localhost.apps localhost







Thursday, July 20, 2017

Installation Fails with the error "Database pre-install checks failed"





 I have created /root/Desktop/oraapps122 Stage directory under root $HOME where as I am performing a single node installation with oracle user. Oracle user could not write to /root directory and the error message is populating continuously. The permissions issue was not reported anywhere in the logs.

Solution:

Moved the Stage directory from /root/Desktop/oraapps122 to /ora and given ownership to oracle user then the installation moved further.


# copy zip files from /root/Desktop/oraapps122 to /ora/oraapps122

#chown -R oracle:dba oraapps122




If this error encounters, check for the permissions on stage area. Oracle & applmgr user should be able to read/write to the stage directory. cd to stage area with oracle & application users. 



Create the Directory structure as following:
[root@apps ~]# mkdir /ora/oraapps122
[root@apps ~]# chown -R oracle:dba /ora/oracle/CRP/oraInventory

We need to copy the all above zip files into /ora/oraapps122/ and change the permission to oracle:dba and change the mode(chmod 775 /ora/oraapps122)
Create the oraInventory Directory as following:
[root@apps ~]# mkdir /ora/oracle/CRP/oraInventory
[root@apps ~]# chown -R oralce:dba /ora/oracle/CRP/oraInventory
[root@apps ~]# chmod -R 775 /ora/oracle/CRP/oraInventory
goto /etc and edit the oraInst.loc file and set the oraInventory location as following:
[root@apps etc]# vi oraInst.loc
inventory_loc=/ora/oracle/CRP/oraInventory
inst_group=dba
[root@apps etc]# cat oraInst.loc
inventory_loc=/ora/oracle/CRP/oraInventory
inst_group=dba



Wednesday, July 19, 2017

Baan ERP Relocate to Another Server but different Directory Structure




Here I relocate BaanERP 5 to another server but different directory structure.


Production Server having BaanERP partition given below


# /ssaerp


Restore Server having below partition given below


# /lnpool/ssaerp



1. I restored /ssaerp folder from Tape to /lnpool/ssaerp folder.


2. Changed the below scripts to start BaanERP.


#  vi /lnpool/ssaerp/bse/etc/rc.start


Change the BSE & BES_TMP variables path

BSE=/lnpool/ssaerp/bse
BSE_TMP=/lnpool/ssaerp/bse/tmp
export BSE BSE_TMP

#BSE=/ssaerp/bse
#BSE_TMP=/ssaerp/bse/tmp



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




Change the BSE & BES_TMP variables path

#  vi /lnpool/ssaerp/bse/etc/rc.start_shm


BSE=/lnpool/ssaerp/bse
BSE_TMP=/lnpool/ssaerp/bse/tmp
export BSE BSE_TMP

#BSE=/ssaerp/bse
#BSE_TMP=/ssaerp/bse/tmp





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













Tuesday, July 18, 2017

Create controlfile error ORA-1192 – Must have at least one enabled thread




SQL>  CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
  2   logging archivelog
  3   MAXLOGFILES 16
  4   MAXLOGMEMBERS 3
  5   MAXDATAFILES 100
  6   MAXINSTANCES 8
  7   MAXLOGHISTORY 31664
  8    LOGFILE
  9   GROUP 4 '/ora/ora_dat/ssaerp/redo04.log' SIZE 50M BLOCKSIZE 512,
 10   GROUP 5 '/ora/ora_dat/ssaerp/redo05.log' SIZE 50M BLOCKSIZE 512,
 11  GROUP 6 '/ora/ora_dat/ssaerp/redo06.log' SIZE 50M BLOCKSIZE 512
 12   datafile
 13  '/ora/ora_dat/ssaerp/system01.dbf',
 14  '/ora/ora_dat/ssaerp/undotbs01.dbf',
 15   '/ora/ora_dat/ssaerp/sysaux01.dbf',
 16   '/ora/ora_dat/ssaerp/users01.dbf',
 17   '/ora/ora_dat/ssaerp/system02.dbf',
 18   '/ora/ora_dat/ssaerp/xdb_SSAERP01.dbf',
 19   '/ora/ora_idx/ssaerp/xdb_SSAERP01.dbf',
 20   '/ora/ora_dat/ssaerp/xdb_SSAERP02.dbf',
 21   '/ora/ora_dat/ssaerp/xdb_SSAERP03.dbf',
 22    '/ora/ora_dat/ssaerp/xdb_SSAERP04.dbf',
 23    '/ora/ora_dat/ssaerp/xdb_SSAERP05.dbf',
 24    '/ora/ora_dat/ssaerp/xdb_SSAERP06.dbf',
 25   '/ora/ora_dat/ssaerp/xdb_SSAERP07.dbf',
 26   '/ora/ora_dat/ssaerp/xdb_SSAERP08.dbf',
 27    '/ora/ora_dat/ssaerp/xdb_SSAERP09.dbf',
 28     '/ora/ora_dat/ssaerp/xdb_SSAERP10.dbf',
.......
.......
 56   CHARACTER SET WE8ISO8859P1;
 CREATE CONTROLFILE REUSE DATABASE "SSAERP" NORESETLOGS FORCE
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01192: must have at least one enabled thread


Solution:


CREATE CONTROLFILE SET DATABASE "PCARD" RESETLOGS FORCE LOGGING NOARCHIVELOG