Oracle Database Administration, Oracle Developer Suite, Oracle JDeveloper, Oracle BI Publisher, Oracle Forms/Reports,Oracle SQL Developer

Data Center Consolidation

Data center consolidation is the process of reducing the volume of physical IT assets through highly efficient and scalable technologies. Organizations leverage data center consolidation to reduce operating costs.

Analyse and Solve Serious Hardware and Sofware Problems

Listing several basic hardware and software troubleshooting steps with respect to operating systems, software programs, and computer hardware.

Mission Critical Systems

A mission critical system is a system that is essential to the survival of a business or organization. When a mission critical system fails or is interrupted, business operations are significantly impacted.

The best server hardware to maximize IT performance

Data center hardware advances target new workloads such as big data processing, as well as higher efficiency for existing apps and services. The best server hardware for your data center depends on existing and planned application architectures, data center operations staff skills and of course the IT budget.

How to verify the current level for the product family patches/patchsets installed on the system?


How to verify the current level for the product family patches/patchsets installed on the system?

 Current level for the product family patches/patchsets installed on the system can be
 verified by querying table : AD_TRACKABLE_ENTITIES

  It has Columns:
  ABBREVIATION VARCHAR2 - Product Abbreviation
  NAME VARCHAR2 - Holds the name of the trackable entity
  TYPE VARCHAR2 - Holds the type of the trackable entity
  CODELEVEL VARCHAR2 - Holds the codelevel of the trackable entity ---> baseline.delta      version
  BASELINE VARCHAR2 - Holds the baseline of the trackable entity


  An example query:
  SQL>
  SELECT ABBREVIATION,


             NAME,
             TYPE,
             CODELEVEL,
             BASELINE
       FROM AD_TRACKABLE_ENTITIES
       WHERE ABBREVIATION IN ('ad',
                          'txk',
                          'fnd',
                          'fwk',
                          'atg_pf',
                          'icx')
      ORDER BY ABBREVIATION;



   

       Doc ID 2234900.1

DataInstall and HRGLOBAL How to Apply hrglobal.drv


DataInstall/HRGLOBAL Technical considerations for EBS Release 12.2


   1.  Start an online patching cycle
Source the run edi􀆟on environment file: Example: UNIX: $RUN_BASE/EBSapps/appl/APPS$CONTEXT_NAME.env
$ adop phase=prepare

   2.  Run DataInstall
The command line DataInstall java utility should be run on the tier which has the $APPL_TOP available.
    It will perform view creation actions against the database pertaining to the options selected.
    For multi-node/RAC setups, DataInstall need only to be run on the primary node.
    Run the DataInstall java utility in order to select the legislations you want to apply as follows:
    java oracle.apps.per.DataInstall <un> <pw> thin <host:port:sid>
    where
    <un> is the username of the main apps account
    <pw> is the password for this account
    <host:port:sid> represents the database connection information
    For example: java oracle.apps.per.DataInstall apps apps thin dbsvr1:1521:testdb

   3.  Apply hrglobal.drv
The driver is located at $PER_TOP/patch/115/driver/hrglobal.drv and should be run      on the tier which has the $APPL_TOP available.
12.2 SPECIFIC: The driver will be applied via the adop patching utility, as opposed   to adpatch which was used prior to 12.2.
Care must be taken when applying hrglobal.drv via adop that the following  parameters are passed with the adop command line:
     options=nocopyportion,nogenerateportion,forceapply
Example: adop phase=apply patchtop=$PER_TOP/patch/115           patches=driver:hrglobal.drv
     options=nocopyportion,nogenerateportion,forceapply
where $PER_TOP corresponds to the patch file system

These options are mandatory in order to
a) avoid adop trying to sync the file system when applying a patch (in this case the hrglobal.drv file) that contains database operations only and
b) ensure that adop will not consider during an upgrade to have been installed previously and proceed with the current request.
Please also ensure the forceapply parameter is at the end of the options list.

   4.  Complete the online patching cycle by running the following commands in the order shown:
a. $ adop phase=finalize
b. $ adop phase=cutover
c. $ adop phase=cleanup

Reference:
Doc ID 1469456.1


How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases

How To Reset a Purchase Order or Requisition From In Process or Pre-Approved To Incomplete/Requires Reapproval For Isolated Cases


These scripts allow the user to resubmit the document for approval by resetting the authorization status when documents are stuck in 'In-Process' or 'Pre-Approved' statuses.
The scripts are:

poxrespo.sql - to reset Standard, Blanket, Planned and Contract purchase orders
poresrel.sql - to reset Blanket and scheduled releases
poresreq.sql - to reset Internal and purchase requisitions

In order to obtain the scripts apply the proper patch. The scripts will be available in the $PO_TOP/sql directory.
It is strongly encouraged to use these reset scripts where there are single (or few) occurrences of documents getting stuck. It is not necessary to submit a Service Request for authorized use of these scripts and if any issues arise after proper use of one of the reset scripts the issues will be fully supported by Oracle Support. Often where there are single occurrences that cannot be replicated, root
cause investigations cannot be performed. But if there are continued repetitive occurrence of such issues, then these should be reported to Oracle Support.

Doc ID 390023.1

Installing Oracle VM Server 2.2.1, Oracle VM Manager 2.2.0

Installing Oracle VM Server 2.2.1, Oracle VM Manager 2.2.0 

Oracle Virtualization – Installing Oracle VM Server 2.2.1, Oracle VM Manager 2.2.0
Oracle provides virtualization software ranging from bare metal implementations based on Oracle VM Server to a Microsoft Windows/Linux/Mac OS and Solaris deployments based on Oracle Virtual Box. Oracle VM Manager facilitates management of Oracle VM Server.
In real life Oracle VM server runs on a dedicated set of servers and is installed as a bare metal product without the need of an Operating system. Oracle VM Manager is installed on a Linux box. Oracle VirtualBox can be successfully used for testing and self-study of the new features.
1. VirtualBox configuration to run VMserver machine and VMManager machine.
The article assumes that the VirtualBox is downloaded and installed and that both virtual machines are configured as follows.


OEL 54 is installed as a base OS for the OracleVMManager while Oracle VM Server is used for the OracleVM machine. The latter will be discussed in greater details in bullet item 2. Note that in case of OracleVMManager machine Guest additions are installed and the shared folder feature is enabled by placing in the guest /etc/rc.local the following command’ mount -t vboxsf OracleVMServer /media/windows’. Both machines also have multiple NIC defined. Bridged interfaces are required for the ORacleVM and OracleVMManager setup. NAP is for access to the Internet and the host-only adapters are for access from the host OS (Microsoft Windows in my case). All iso images are in the shared folder and the OEL or Oracle VM server iso is specified for the initial OEL and Oracle VM Server installation. For additional information related to OEL installation

2. Installation of Oracle VM Server
Specify the Oracle-VM-Server-2.2.1.iso and start the OracleVM machine.


Skip the testing if already sure about the physical integrity of the media. Press Skip to continue.


Select the model of the keyboard and press OK.


Initialize the drive.


OK the default.


Select Yes to continue.


Review the layout and press OK to continue.


Press OK to continue.


Select eth3 interface for the VM management. Press OK to continue.


Enter 198.169.2.41 and the mask 255.255.255.0. Remember that this address will be used to talk to the Oracle VM Manager later.


Enter the gateway and DNS information as specified below.


Select a hostname and press OK to continue.


Select the time zone and press OK to continue.


Enter a password for the Oracle VM agent and press OK to continue.


Enter the root password and press OK to continue.


Press OK to continue and take a note of the location.


Wait for the installation to complete.


Wait for the installation to complete.


When installation completes press Reboot.


Acknowledge the license agreement.


After that you are about to login.


3. Installation of Oracle VM Manager
The article assumes that OEL is installed and networking is configured so that both OracleVM machine and OracleVM Manager machine can communicate. The /etc/hosts is as follows.
[root@oraclevmmgr racovm]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
192.168.2.18 oraclevmmgr.gj.com oraclevmmgr
192.168.2.41 oraclevm.gj.com oraclevm
[root@oraclevmmgr racovm]#
If only iso is available mount it as follows.
[root@oraclevmmgr cdrom]# mount -o loop,rw OracleVM-Manager-2.2.0.iso /media/cdrom
[root@oraclevmmgr cdrom]# cd /media/cdrom
[root@oraclevmmgr cdrom]# ls
EULA LICENSE readme.txt runInstaller.sh scripts source TRANS.TBL
[root@oraclevmmgr cdrom]# ./runInstaller.sh
bash: ./runInstaller.sh: Permission denied
Copy directory structure to a new location to be able to set the permissions.
[root@oraclevmmgr cdrom]# mkdir /media/vmmanager
[root@oraclevmmgr cdrom]# ls
EULA LICENSE readme.txt runInstaller.sh scripts source TRANS.TBL
[root@oraclevmmgr cdrom]# cd ../vmmanager
[root@oraclevmmgr vmmanager]# ls
[root@oraclevmmgr vmmanager]# cp -R /media/cdrom .
[root@oraclevmmgr vmmanager]# ls
cdrom
[root@oraclevmmgr vmmanager]# cd cdrom
[root@oraclevmmgr cdrom]# ls
EULA LICENSE readme.txt runInstaller.sh scripts source TRANS.TBL
[root@oraclevmmgr cdrom]# ./runInstaller.sh
bash: ./runInstaller.sh: Permission denied
[root@oraclevmmgr cdrom]# chmod 777 runInstaller.sh
[root@oraclevmmgr cdrom]#
Execute the installer and respond to the prompts.
[root@oraclevmmgr cdrom]#

[root@oraclevmmgr cdrom]# ./runInstaller.sh

Welcome to Oracle VM Manager 2.2
Please enter the choice: [1|2|3]
1. Install Oracle VM Manager
2. Uninstall Oracle VM Manager
3. Upgrade Oracle VM Manager
1
Starting Oracle VM Manager 2.2 installation …
Do you want to install a new database or use an existing one? [1|2]
1. Install a new Oracle XE database on localhost
2. Use an existing Oracle database in my network
1
Prepare to install the Oracle XE database …
Checking the supported platforms … Done
Checking the prerequisite packages are installed … Done
Checking the available disk space … Done
Installing the oracle-xe-univ package (rpm) now …
Done

Oracle Database 10g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 10g Express
Edition. The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts. Press to accept the defaults.
Ctrl-C will abort.
Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:
Do you want Oracle Database 10g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener…Done
Configuring Database…Done
Starting Oracle Database 10g Express Edition Instance…Done
Installation Completed Successfully.
To access the Database Home Page go to “http://127.0.0.1:8080/apex”
Checking the availability of the database …
Set default database schema to ‘OVS’.
Please enter the password for account ‘OVS’:
Confirm the password:
Creating the Oracle VM Manager database schema …Done
Installing the ovs-manager package (rpm) …
Done
Installing the oc4j package (rpm) …
Done
Please enter the password for account ‘oc4jadmin’:
Confirm the password:
Starting OC4J … Done.
To access the OC4J Home Page and change the password go to http://127.0.0.1:8888/em
Deploying Oracle VM Manager application to OC4J container.
Creating connection pool … Done
Creating data source … Done
Deploying application help … Done
Deploying application … Done
Please enter the keystore password for the Web Service:
Password must be at least 6 characters. Enter password:
Confirm the password:
Setting keystore password for Web Service …administ Done
Do you want to use HTTPS access for Oracle VM Manager (Y|n)Y
Configuring OC4J to use HTTPS … Done
Stopping OC4J … Done
Starting OC4J … Done
Please enter the password for the default account ‘admin’:
Confirm the password:
Configuring SMTP server …
Please enter the outgoing SMTP mail server(e.g. – mail.abc.com, mail.abc.com:25): oraclevmmgr
Mail server checking, may need some time, please wait …
Mail server ‘oraclevmmgr’ check failed, enter Y to change the name and retry or N to keep hostname and continue(Y|n)?localhost
Please enter the outgoing SMTP mail server(e.g. – mail.abc.com, mail.abc.com:25): localhost
Mail server checking, may need some time, please wait …
Setting the SMTP server to localhost …
Done
Please enter an e-mail address for account ‘admin’: root@localhost
Confirm the e-mail address : root@localhost
Updating e-mail address for account ‘admin’ to ‘root@localhost’ …
Done
The console feature is not enabled by default.
For detailed setup, refer to Oracle VM Manager User’s Guide
Installation of Oracle VM Manager completed successfully.
To access the Oracle VM Manager 2.2 home page go to:
https://192.168.2.18:4443/OVS
To access the Oracle VM Manager web services WSDL page go to:
https://192.168.2.18:4443/OVSWS/LifecycleService.wsdl
https://192.168.2.18:4443/OVSWS/ResourceService.wsdl
https://192.168.2.18:4443/OVSWS/PluginService.wsdl
https://192.168.2.18:4443/OVSWS/ServerPoolService.wsdl
https://192.168.2.18:4443/OVSWS/VirtualMachineService.wsdl
https://192.168.2.18:4443/OVSWS/AdminService.wsdl
To access the Oracle VM Manager help page go to:
https://192.168.2.18:4443/help/help
You have mail in /var/spool/mail/root
[root@oraclevmmgr cdrom]#

Now once Oracle VM Manager is installed and configured spicefy the URL above to access it with a browser.


After login we have


A server pool needs to be defined. Press Next to continue. Enter the name of the server pool and the hostname of the server where the Oracle VM Server is installed along with the server agent password and login credentials.


Press Create button to create the server pool.

Oracle Solaris 11 Information Library

Oracle Solaris 11 Information Library

GETTING STARTED WITH ORACLE SOLARIS 11


Start Here  


Oracle Solaris 11 Release Notes  
Oracle Solaris 11 End-of-Feature (EOF) List  
Transitioning From Oracle Solaris 10 to Oracle Solaris 11  

INSTALLING AND UPDATING ORACLE SOLARIS 11

Installing Oracle Solaris 11 Systems  
Creating and Administering Oracle Solaris 11 Boot Environments  
Transitioning From Oracle Solaris 10 JumpStart to Oracle Solaris 11 Automated Installer  
Creating a Custom Oracle Solaris 11 Installation Image  
Adding and Updating Oracle Solaris 11 Software Packages  
Copying and Creating Oracle Solaris 11 Package Repositories  
Oracle Solaris 11 Installation Man Pages  
Image Packaging System Man Pages  

ADMINISTERING ORACLE SOLARIS 11

Creating and Administering Oracle Solaris 11 Boot Environments  
Booting and Shutting Down Oracle Solaris on SPARC Platforms  
Booting and Shutting Down Oracle Solaris on x86 Platforms  
Oracle Solaris Administration: Common Tasks  
Oracle Solaris Administration: Devices and File Systems  
Oracle Solaris Administration: IP Services  
Oracle Solaris Administration: Naming and Directory Services  
Oracle Solaris Administration: Network Interfaces and Network Virtualization  
Oracle Solaris Administration: Network Services  
Oracle Solaris Administration: Oracle Solaris Zones, Oracle Solaris 10 Zones, and Resource Management  
Oracle Solaris Administration: SAN Configuration and Multipathing  
Oracle Solaris Administration: Security Services  
Oracle Solaris Administration: SMB and Windows Interoperability  
Oracle Solaris Administration: ZFS File Systems  
Oracle Solaris Tunable Parameters Reference Guide  
Oracle VTS (Validation Test Suite)  
How to Perform System Archival and Recovery Procedures With Oracle Solaris 11  
International Language Environments Guide  

SECURING THE ORACLE SOLARIS 11 OPERATING SYSTEM

Oracle Solaris 11 Security Guidelines  
Oracle Solaris Administration: Security Services  
Developer's Guide to Oracle Solaris 11 Security  
Trusted Extensions Configuration and Administration  
Trusted Extensions User's Guide  
Trusted Extensions Label Administration  
Trusted Extensions Developer's Guide  
Compartmented Mode Workstation Labeling: Encodings Format  

WORKING WITH THE ORACLE SOLARIS 11 DESKTOP

Oracle Solaris 11 Accessibility Guide for the GNOME Desktop  
Oracle Solaris 11 User's Guide for the GNOME Desktop  
Optimizing the Oracle Solaris 11 Desktop for a Multi-User Environment  

DEVELOPING APPLICATIONS FOR USE WITH ORACLE SOLARIS 11

Introduction to the Oracle Solaris 11 Developer Environment  
Copying and Creating Oracle Solaris 11 Package Repositories  
Linker and Libraries Guide  
ONC+ Developer's Guide  
Resource Management and Oracle Solaris Zones Developer's Guide  
Oracle Solaris Dynamic Tracing Guide  
Programming Interfaces Guide  
Writing Device Drivers  

ORACLE SOLARIS 11 REFERENCE MANUALS

man pages section 1: User Commands  
man pages section 1M: System Administration Commands  
man pages section 2: System Calls  
man pages section 3: Library Interfaces and Headers  
man pages section 3: Basic Library Functions  
man pages section 3: Networking Library Functions  
man pages section 3: Extended Library Functions, Volume 1  
man pages section 3: Extended Library Functions, Volume 2  
man pages section 3: Extended Library Functions, Volume 3  
man pages section 3: Extended Library Functions, Volume 4  
man pages section 3: Curses Library Functions  
man pages section 3: Multimedia Library Functions  
man pages section 4: File Formats  
man pages section 5: Standards, Environments, and Macros  
man pages section 7: Device and Network Interfaces  
man pages section 9: DDI and DKI Driver Entry Points  
man pages section 9: DDI and DKI Kernel Functions  
man pages section 9: DDI and DKI Properties and Data Structures  
Oracle Solaris 11 Installation Man Pages  
Image Packaging System Man Pages  

IMPORTANT INFORMATION FROM PREVIOUS RELEASES

Device Driver Tutorial  
Memory and Thread Placement Optimization Developer's Guide  
Oracle Solaris Modular Debugger Guide  
Multithreaded Programming Guide  
SIP API Developer's Guide  
Oracle Solaris WBEM Developer's Guide  
SPARC Assembly Language Reference Manual  
x86 Assembly Language Reference Manual  
OpenBoot 4.x Command Reference Manual  
Writing FCode 3.x Programs  
Solaris Volume Manager Administration Guide  

RELATED INFORMATION

Oracle Solaris 11 Product Center  
Oracle Solaris 11 How-To Articles  
Oracle Solaris 11 Technologies  
Oracle Solaris 11 Animations and Videos  
Oracle Solaris 11 Training  

LEGAL INFORMATION FOR THIS RELEASE

Accessing Third-Party Notice and License Information for Oracle Solaris 11  
Accessing Open Source Code