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/lib/python2.7/vendor-pac

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 Address           RECORD  192.168.200.204 A03530 Domain Name          RECORD  ijarah.loc A03540 /etc/hosts Format    PASSED  Adequate IPv4 entry A03550 DNS Lookup           PASSED  Host correctly registered in DNS A03560 Net Service Access?  PASSED 

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 dc2prpntidb01:  Port Value = 1527    Database Port available:  Port Value = 1527  Checking  DB ONS Local Port on dc2prpntidb01:  Port Value

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 ---------- --------------- ---------------- ---------------------------------------------------------------- ------------          1               1 PROD1            EBSDB1                                                          OPEN So w