Apps DBA Workshop

Recently installation Solaris 11.4 operating environment where the repository was successfully confiured and installed started reporting the following errors when we were trying to install the new packages using the same repository. The following Error message is reported while we are trying to use the locally configured repository: root@ECMDB:~# pkg publisher Traceback (most recent call last):   File "/usr/bin/pkg", line 6702, in handle_errors     __ret = func(*args, **kwargs)   File "/usr/bin/pkg", line 6584, in main_func     api_inst = __api_alloc(mydir, provided_image_dir, pkg_image_used)   File "/usr/bin/pkg", line 1459, in __api_alloc     exact_match=exact_match)   File "/usr/lib/python2.7/vendor-packages/pkg/client/api.py", line 370, in __init__     cmdpath=self.cmdpath)   File "/usr/lib/python2.7/vendor-packages/pkg/client/image.py", line 236, in __init__     progtrack)   File "/usr/...

On solaris sparc mini cluster the database  home installation pre-eq checks were failing with following errors, though these errors are not reported during installer checks. A00100 OS Type              RECORD  SunOS SPARC 2.11 64-bit A00200 OS Certified?        PASSED  Certified A00210 Got Maint Updates?   FAILED  NoMaintUpd A01010 ApplTierDirectory    RECORD  /u01 A01020 A_T Valid?           PASSED  ATexists A01030 A_T Permissions OK?  PASSED  CorrectPerms A01040 A_T Disk Space       PASSED  Available A01400 Got Software Tools?  PASSED  tools_found A02020 ulimits OK?          FAILED  NoFilesTooSmall StackTooSmall A02210 Kernel Params OK?    PASSED  KernelOK A03010 Space in tmp         PASSED  Available A03510 IP ...

Scaling of Database Instance for Oracle EBS R12.2 failing with the below listed Error: StackTrace: java.lang.NullPointerException         at oracle.apps.ad.context.CloneContext.preserveOldPortSettings(CloneContext.java:5527)         at oracle.apps.ad.context.CloneContext.promptForPortPool(CloneContext.java:5716)         at oracle.apps.ad.context.CloneContext.getInputDBRACInitial(CloneContext.java:3389)         at oracle.apps.ad.context.CloneContext.getInputFromUsers(CloneContext.java:2226)         at oracle.apps.ad.context.CloneContext.doClone(CloneContext.java:959)         at oracle.apps.ad.context.CloneContext.main(CloneContext.java:8059) RC-50208: Warning: Exception  in method preserveOldPortSettings Raised by oracle.apps.ad.context.CloneContext Started testing the availabilty of ports in port pool 6  Checking  Database Port on dc2prpn...

While starting one of the cluster instance we encountered following error: SQL> startup nomount pfile='initPROD2.ora' ORA-32006: BACKGROUND_DUMP_DEST initialization parameter has been deprecated ORA-00304: requested INSTANCE_NUMBER is busy SQL> exit Disconnected Here we are trying to start instance on node2 and getting this error message, the error message is very clear that the instacne number which we are trying to mount is not available and is already mounted on other instance. SQL> set pages 300 lines 300 SQL> select inst_id, instance_number, instance_name, host_name, status from gv$instance;    INST_ID INSTANCE_NUMBER INSTANCE_NAME    HOST_NAME                                                        STATUS ---------- --------------- ---------------- -------------------------------------------------...

Oracle EBS R12.2 is a highly scalable software package and the application can be scale up to multiple servers based on the business requirements. I encountered below error message while adding additonal server to an newly cloned EBS Environment. Verifying: pairsfile /apps/appspre/UAT/fs2/inst/apps/UAT_erpnode1/appl/admin/pairsnode02.txt Verifying: Run file system AdminServer is running Validated the passed arguments for the option ebs-get-serverstatus AdminServer is in RUNNING mode. .end std out. .end err out. Script Executed in 2302 milliseconds, returning status 0 run AdminServer is RUNNING Verifying: Patch file system AdminServer is running RC-50208: Exception  in method TimedProcessProcess.run Raised by oracle.apps.ad.util.TimedProcess$TimedProcessProcess: java.io.IOException: Cannot run program "/apps/NTISPROD/fs1/F MW_Home/webtier/perl/bin/perl": error=2, No such file or directory Exception in TimedProcess...Failed to  execute command = /apps...

As you know Oracle released Oracle Solaris 11.2 in 2014. Oracle Solaris 11 is delivered in different medias, but this article demonstrates Installation using the solaris 11.2 text media. Download the software from oracle: http://www.oracle.com/technetwork/server-storage/solaris11/downloads/install-2245079.html - Download he x86 Text Installer. I did this Installation on Virtual Box VM created with the following specs: - use download  media " sol-11_2-text-x86.iso " and poweron virtual machine. - Select "1  Install Oracle Solaris" - press-F2 to continue - Select "local disk" - provide host name - Select manual network configuration if not using DHCP - If you want to configure DNS then select configure DNS and provide DNS server IP address - Select Time Zone based on your region. - Provide root password and create an additional OS account. - Re...

New version of start CD has been release for Oracle EBS R12.2. Every new version will of start CD will included bug fixes and enhancements. Oracle always recommend to use the latest version of start CD for EBS Installations and upgrades. If you preparing a fresh stage then directly you can use "buildStage.sh" script from "start CD 12.2.0.49" for preparing your stage, If stage is already in place and you want to update it with the latest startCD then you can follow all listed below Instructions. STEPS: 1) Download patch form MOS (need valid CSI) 2) verify the version of existing start CD 3) Copy startCD-49 to Stage area  and rename/delete the existing "stardCD" directory 4) Run "builStage.sh" script to copy latest Tech Patches to Stage area. 1) Download patch form MOS (need valid CSI) You need to have a valid support contract to download this patch 2) verify the version of existing start CD You can verify version of startC...