Search

Custom Search

Saturday 5 December 2015

Installing Oracle Ksplice

Installation instructions

To install Ksplice Uptrack, please run the following commands as root:


wget -N https://www.ksplice.com/uptrack/install-uptrack

sh install-uptrack 9db6fd7c6694c39d955e99969f1fdbddb83888661a488166e0d54e91dfa52784

uptrack-upgrade -y

If you'd like Ksplice Uptrack to automatically install updates as they become available, run:

sh install-uptrack 9db6fd7c6694c39d955e99969f1fdbddb83888661a488166e0d54e91dfa52784 --autoinstall

in place of the above install-uptrack command, or set "autoinstall = yes" in /etc/uptrack/uptrack.conf after installation.
If installing on a Debian or Ubuntu machine, you may first need to install the ca-certificates package with apt-get install ca-certificates. Without this package you will see a "certificate verification error".

Thursday 22 October 2015

Enabling SNMP in Oracle Enterprise Linux

1. Install the required tools using 


yum -y install net-snmp net-snmp-utils

2. Enable ports 162 and 161 UDP, TCP in firewall

3. Edit config file

vi /etc/snmp/snmpd.conf

Should look like the following

# com2sec notConfigUser  default       public

com2sec notConfigUser   default        nameofcommunitystring
#com2sec ConfigUser     default         nameofcommunitystring
com2sec AllUser         default             nameofcommunitystring

####
# Second, map the security name into a group name:

#       groupName      securityModel securityName
group   notConfigGroup  v1              notConfigUser
group   notConfigGroup  v2c             notConfigUser
group   ConfigGroup     v2c             ConfigUser
group   AllGroup        v2c             AllUser

####
# Third, create a view for us to let the group have rights to:

# Make at least  snmpwalk -v 1 localhost -c public system fast again.
#       name           incl/excl     subtree         mask(optional)
view    systemview    included   .1.3.6.1.2.1.1
#view    systemview    included   .1.3.6.1.2.1.25.1.1
view    systemview    included   .1.3.6.1.2.1.25
view    AllView       included        .1

####
# Finally, grant the group read-only access to the systemview view.

#       group          context sec.model sec.level prefix read   write  notif
access  notConfigGroup ""      any       noauth    exact  systemview none none
access  ConfigGroup     ""      any     noauth  exact   SystemView      none    none
access  AllGroup        ""      any     noauth  exact   AllView         none    none


3.Restart snmpd daemon

service snmpd restart

4. Configure SNMP to start when the server boots:

chkconfig snmpd on

5. Check config

snmpwalk -v 2c -c nameofcommunitystring -O e 102.106.0.460

Friday 25 September 2015

Node-oracledb Installation on Linux

1) Install Node.js
Download the Node.js Linux 64-bit binaries and extract the file, into /opt:

cd /opt
tar -zxf node-v0.12.7-linux-x64.tar.gz

Set PATH to include Node.js:
export PATH=/opt/node-v0.12.7-linux-x64/bin:$PATH

2) Install the free Oracle Instant Client 'Basic' and 'SDK' ZIPs


Download the free Basic and SDK ZIPs from Oracle Technology Network and install them into the same directory:

cd /opt/oracle
unzip instantclient-basic-linux.x64-12.1.0.2.0.zip
unzip instantclient-sdk-linux.x64-12.1.0.2.0.zip
mv instantclient_12_1 instantclient
cd instantclient
ln -s libclntsh.so.12.1 libclntsh.so

You will need libaio installed. On some platforms the package is called libaio1.

To run applications, you will need to set the link path:

export LD_LIBRARY_PATH=/opt/oracle/instantclient:$LD_LIBRARY_PATH

Alternatively, if there is no other Oracle software on the machine that will be impacted, permanently add Instant Client to the run-time link path. Do this on Linux by creating a file /etc/ld.so.conf.d/oracle-instantclient.conf that contains the library location /opt/oracle/instantclient, and then run ldconfig as the root user.

3) Tell the installer where to find Instant Client:

export LD_LIBRARY_PATH=/opt/instantclient:$LD_LIBRARY_PATH
export OCI_LIB_DIR=/opt/instantclient
export OCI_INC_DIR=/opt/instantclient/sdk/include

Install node-oracledb from the NPM repository:

npm install oracledb

If you are installing with sudo, you may need to use sudo -E to preserve the environment variable values.

Monday 17 August 2015

Oracle Database 11g Install Part 2

If you rather videos click here...
Part 1 available here
Continuing the screenshots






















 
[oracle@main-emcc admin]$ /u01/app/oracle/product/11.2.0/dbhome_1/bin/netca



End.

For video click here...

Oracle Database 11g Install Part 1

Oracle Database 11g R2 Linux Install
Part 2 available here..

Create the necessary users and groups with the following commands







# groupadd -g 1000 oinstall
# groupadd -g 1031 dba
# usermod -g oinstall -a -G dba oracle

# mkdir -p /u01/app/oracle
# mkdir /u01/app/oracle/oms
# mkdir /u01/app/oracle/agent
# chown -R oracle:oinstall /u01
# chmod -R 775 /u01/

unzip installation files
[oracle@main-emcc Downloads]$ unzip linux.x64_11gR2_database_1of2.zip
[oracle@main-emcc Downloads]$ unzip linux.x64_11gR2_database_2of2.zip


run the installer
[oracle@main-emcc database]$ ./runInstaller

Configure the hosts file
root@main-emcc admin]# vi /etc/hosts   and add servername eg main-emcc
e.g hosts file should look like the following

127.0.0.1   main-emcc localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6








Tuesday 4 August 2015

Changing the Database Oracle Home File Path Value in Enterprise Manager 12c Cloud Control using emcli


Note : in the EM 12c console, on the Configure Database Instance: Properties page, the Oracle Home Path value can be changed

Access: Targets > Databases > (database instance target), right-click > Oracle Database > Target Setup > Monitoring Configuration


Steps

1. /bin/emcli login -username=sysman

2. /bin/emcli sync

3. OMS_HOME>/bin/emcli modify_target -name="" -type="" -properties="OracleHome:" -on_agent

Example for Oracle database target:

emcli modify_target -name="test" -type="oracle_database" -properties="OracleHome:/u01/app/oracle/product/11.2.0/dbhome_1" -on_agent

Monday 3 August 2015

Registering For Oracle Unbreakable Linux Network From OLE 6.6

The follow are the steps required to register a machine for the Oracle Unbreakable Linux Network,
the OS version is Oracle Linux Enterprise 6.6 (OLE 6.6) 

Go to System -> Administration -> ULN Registration



Enter your root password

You will be presented with the following screen, click "Forward"


Fill out the  fields with the information provided by your Oracle sales agent, then click "Forward"





Fill the required information as necessary





That's it.




Thursday 30 July 2015

Enabling SSL in oracle EBS 12.0.6

The steps outlined below will help you to add SSL encryption to your Oracle EBS application.
The following uses a self signed certificate but if you would like to create a local certificate authority(CA) for signing such certificates  please view the tutorial here...


 Basic Steps
  •     Create Wallet with Self-Signed certificate
  •     Copy Wallet with Self-Signed certificate to OPMN certificate directory
  •     Modify Xml attributes
  •     Run Adauto config
  •     Configure database (Copy Wallet)
  •     Restart Server
  •     End

Middle Tier Setup

Step 1)  Generate Wallet and Self-Signed Certificate

 
Source your environment 
 
  •  Log on to the application (middle) tier, as the OS user who owns the application tier files.
  •  Source your /.env file to set your APPL_TOP variables.
  • Navigate to the $INST_TOP/ora/10.1.3 and source the .env file to set your 10.1.3 ORACLE_HOME variables. When working with wallets and certificates, you must use the 10.1.3 executables.

Create a Wallet
 
  • Verify the location of the Web SSL directory: grep s_web_ssl_directory $CONTEXT_FILE
  • Navigate to this directory, which will have Apache and opmn subdirectories
  • Change to the Apache subdirectory
  • Backup any existing wallets (demo certificates are included in Release 12)

Create your new wallet:

orapki wallet create -wallet . -auto_login -pwd

"-wallet ." (note the ".") tells orapki that you want to create the wallet in the current directory. You can also specify the full path to any directory where you wish to create a wallet.

" -auto_login" tells orapki that you want to create cwallet.sso which is an obfuscated copy of ewallet.p12. With auto login enabled, processes submitted by the OS user who created the wallet will not need to supply the password to access the wallet.


You should now see two wallet files in your directory: cwallet.sso and ewallet.p12.

Add your self-signed certificate to the wallet.

Enter the following command all on one line, substituting the appropriate parameters for your instance:

orapki wallet add -wallet . -dn "CN=EBSSERVER.COM,OU=IT,O=COMPANY_NAME,L=CITY,ST=STATE,C=US" -keysize 1024 -self_signed -validity 9650 -pwd *********

When viewed in the wallet manager the certificate must be in [Ready] state

Check permission on certificates to make sure everyone has access to them (oracle install user).


Step 2) - Modify the OPMN wallet.

The E-Business Suite Rapid Install process creates a default "demo" opmn wallet in the $INST_TOP/certs/opmn directory that can be used in test instances for basic SSL testing. Now that the Apache wallet has been created you will need to to use these same certificates for opmn.   Use the following steps to backup and copy the wallets:

  • Navigate to the $INST_TOP/certs/opmn directory.
  • Create a new directory named BAK
  • Move the ewallet.p12 and cwallet.sso files to the BAK directory just created.
  • Copy the ewallet.p12 and cwallet.sso files from the $INST_TOP/certs/Apache directory to the $INST_TOP/certs/opmn directory.
  • Do the same for the apache directory


Step 3) Appstier Setup
 
Edit the context xml file in $APPL_TOP/admin, change the SSL related variables to SSL values

SSL Related Variables in the Context File

Variable
Non-SSL Value
SSL Value
s_url_protocol
http
https
s_local_url_protocol
http
https
s_webentryurlprotocol
http
https
s_active_webport
same as s_webport
same as s_webssl_port
s_webssl_port
not applicable
default is 4443
s_https_listen_parameter
not applicable
same as s_webssl_port
s_help_web_agent
url constructed with http protocol and s_webport for both non-SSL and SSL


s_login_page
url constructed with http protocol and s_webport
url constructed with https protocol and s_webssl_port




s_external_url
url constructed with http protocol and s_webport
url constructed with https protocol and s_webssl_port


Execute autoconfig

Bounce the mid-tier services

Step 4) DB Tier Setup

Once you run autoconfig on Apps Tier, you need to do wallet setup on DB tier as well. Since R12 is autoconfig enabled, there will be a directory called appsutil in ORACLE_HOME on database side. Follow below steps to carry out the setup on database side.
  • Login to DB tier as oracle user
  • Change dir to $ORACLE_HOME/appsutil
  • Create a new dir with name “wallet”
  • Copy wallet and certificate files from steps above to this directory

If Not Working
  • Recheck XML parameters
  • Verify permissions on wallet files


Wednesday 15 July 2015

How to Generate a Specific Form through AD utility (adadmin)


1. Start the adadmin Utility

From a command line session, as the applmgr user, start the adadmin utility.
bash-3.00$ adadmin 


Please note that if your system is configured using more than one tier and more than one APPL_TOP (in contrast to the shared APPL_TOP), you should run this utility from each forms tier.

2. Step Through the Initial adadmin Questions


Your default directory is '/oracle/prod/apps/apps_st/appl'.

Is this the correct APPL_TOP [Yes] ?

If the above is true, then hit the [Enter] key.
AD Administration records your AD Administration session in a text file
you specify.  Enter your AD Administration log file name or press [Return]
to accept the default file name shown in brackets.

Filename [adadmin.log] : POXBWVRP.log

Here you can record your adadmin session in a specific log file like above.

************* Start of AD Administration session *************
AD Administration version: 12.0.0
AD Administration started at: Tue May 07 2013 21:01:17
APPL_TOP is set to /oracle/prod/apps/apps_st/appl
You can be notified by email if a failure occurs.
Do you wish to activate this feature [No] ?

This option only works in UNIX and the purpose of this question is to notify the AD administrator by mail if any failure occurred while adadmin was running in unattended mode.

Please enter the batchsize [1000] :

This option asks for a specific batch size, to reserve memory when adadmin validates package and procedure information. This option only is meaningful when running database administrative related tasks. For the purpose of generating a form, you can leave the default value.

You are about to use or modify Oracle Applications product tables
in your ORACLE database 'prod'
using ORACLE executables in '/oracle/prod/apps/tech_st/10.1.2'.
Is this the correct database [Yes] ?

If correct, hit the [Enter] key. Otherwise, exit this utility by typing "abort" plus the [b] key and verify if your environment has been sourced correctly.

AD Administration needs the password for your 'SYSTEM' ORACLE schema
in order to determine your installation configuration.
Enter the password for your 'SYSTEM' ORACLE schema:

Here you must enter your SYSTEM database user password.

The ORACLE username specified below for Application Object Library
uniquely identifies your existing product group: APPLSYS
Enter the ORACLE password of Application Object Library [APPS] :

Here you must enter your SYSTEM database user password.
After finally reaching this point, the utility will try to connect to your database and get information regarding your system.

3. The next step which requires user interaction is the main menu:


            AD Administration Main Menu
   --------------------------------------------------
   1.    Generate Applications Files menu
   2.    Maintain Applications Files menu
   3.    Compile/Reload Applications Database Entities menu
   4.    Maintain Applications Database Entities menu
   5.    Change Maintenance Mode
   6.    Exit AD Administration

Enter your choice [6] : 1

         Generate Applications Files
   ----------------------------------------
   1.    Generate message files
   2.    Generate form files
   3.    Generate report files
   4.    Generate product JAR files
   5.    Return to Main Menu

Enter your choice [5] : 2

AD utilities can support a maximum of 999 workers. Your
current database configuration supports a maximum of 276 workers.
Oracle recommends that you use between 64 and 128 workers.
Enter the number of workers [64] : 8


In order to determine the optimal number of workers for your system, you should consider the following general rule:
Total of available workers for your system = (Number of processors) x 3

Your current character set is "UTF8".
Do you want to generate Oracle Forms objects
using this character set [Yes] ?


If this is your correct character set, hit [Enter].  Otherwise, please verify your environment.

Do you want to regenerate Oracle Forms PL/SQL library files [Yes] ?

In this case, we will generate PL/SQL library files, so you might reply 'y' to the above question.

Do you want to regenerate Oracle Forms menu files [Yes] ?

Same as above; reply 'y' to this question.

Do you want to regenerate Oracle Forms executable files [Yes] ?

Here, hit [Enter] to accept the default 'Yes'

Enter list of products ('all' for all products) [all] : PO

Now, we need to specify the Application short name. (po for Purchasing Order, gl, for General Ledger, ap for Payables, and so on).  In our example we will be using module fnd (Application Object Library).
In 11i, the entry must be typed using lowercase characters.

Generate specific forms objects for each selected product [No] ? Yes


Answer 'y' to this question, since it will regenerate all forms for the module selected previously if 'No' is answered here.

The current set of installed languages is: US
Please select languages for generating Oracle Forms files.
You may select all of the above languages, or just a subset.
Enter list of languages ('all' for all of the above) [all] :


In this case, reply 'all', since this will regenerate the form for all existing languages.

You selected the following languages: US

Is this the correct set of languages [Yes] ?
Reading product form information...
Selecting Oracle Forms PL/SQL library files and menu files to generate...
Selecting library and menu files for Purchasing...
List of libraries and menus in Purchasing :

   POASTDCM.pll   POXAPAPC.pll   POXAPINT.pll   POXBWVRP.pll   POXCOMSG.pll
    POXCORE.pll   POXCOSEU.pll   POXCPDOC.pll   POXDOCEC.pll   POXDOCON.pll
   POXDOPRE.pll   POXGMLCR.pll   POXGMLCT.pll   POXGMLPO.pll   POXGMLRQ.pll
   POXOPROC.pll   POXPIPLL.pll   POXPIPOH.pll   POXPIPOL.pll   POXPIPOS.pll
   POXPIRFV.pll   POXPIRQH.pll   POXPIRQL.pll    POXPOAH.pll   POXPOCTR.pll
   POXPODIS.pll   POXPODMC.pll   POXPOEAC.pll   POXPOEGA.pll   POXPOEPO.pll
   POXPOPOL.pll   POXPOPOS.pll   POXPORCV.pll   POXPOREL.pll   POXPORMC.pll
   POXPOVCT.pll   POXPOVP1.pll   POXPOVP2.pll   POXPRCDF.pll   POXPROJA.pll
   POXPROJM.pll   POXRIHDR.pll   POXRILNS.pll   POXRQDIS.pll   POXRQHDR.pll
   POXRQLNS.pll   POXRQMOD.pll   POXRQVR1.pll   POXRQVR2.pll   POXSCAPP.pll
   POXSCRFV.pll   POXSCSAQ.pll   POXSCSI2.pll   POXSCSIL.pll   POXSTIFT.pll
   RCVCOFND.pll   RCVCOTRX.pll   RCVCOUOM.pll   RCVGMLCR.pll   RCVGMLTX.pll
   RCVMRFND.pll   RCVMRMAT.pll   RCVRCCON.pll   RCVRCCUR.pll   RCVRCERH.pll
   RCVRCERL.pll   RCVRCMUR.pll   RCVRCVRC.pll   RCVSHESH.pll   RCVSTDRO.pll
   RCVTXECO.pll   RCVTXERE.pll   RCVTXERT.pll   RCVTXVTX.pll

Enter libraries and menus to generate, or enter 'all' [all] : POXBWVRP.pll
Selecting product forms to generate...
Selecting forms for Purchasing...

List of forms in Purchasing :
   POASTDCM.fmx   POASTDSR.fmx   POXBWVRP.fmx   POXCPDOC.fmx   POXDOAPP.fmx
   POXDOCEC.fmx   POXDOCON.fmx   POXDOFDO.fmx   POXDOPRE.fmx   POXDOREP.fmx
   POXGAORG.fmx   POXOPROC.fmx   POXPCATN.fmx    POXPOAH.fmx   POXPODMC.fmx
   POXPOEAC.fmx   POXPOEPO.fmx   POXPOERL.fmx   POXPORMC.fmx   POXPOVCT.fmx
   POXPOVPO.fmx   POXPRCDF.fmx   POXQUEMQ.fmx   POXRQARQ.fmx   POXRQERQ.fmx
   POXRQMOD.fmx   POXRQTMP.fmx   POXRQVRQ.fmx   POXSCAPP.fmx   POXSCASL.fmx
   POXSCERQ.fmx   POXSCSAQ.fmx   POXSCSIC.fmx   POXSTASL.fmx   POXSTDCG.fmx
   POXSTDCS.fmx   POXSTDLC.fmx   POXSTDPC.fmx   POXSTIFT.fmx   POXSTITS.fmx
   POXSTPRS.fmx   POXSTRLM.fmx   POXSVASL.fmx   POXTAXCT.fmx   POXTAXDT.fmx
   RCVCOFND.fmx   RCVCOSTA.fmx   RCVRCERC.fmx   RCVRCMUR.fmx   RCVRCVRC.fmx
   RCVSHESH.fmx   RCVSTAND.fmx   RCVSTDRO.fmx   RCVTXECO.fmx   RCVTXERE.fmx
   RCVTXERT.fmx   RCVTXVTX.fmx

Enter forms to generate, or enter 'all' [all] : POXBWVRP.fmx


Enter ‘POXBWVRP.fmx’ at the prompt. Once you do so, adadmin will invoke the appropriate forms compiler and will regenerate the forms.

Generating Oracle Forms objects...

If any error is found, review the adadmin log file and the adworker log file(s).  The adworker log files are also located under $APPL_TOP/admin//log directory.  The file name is adworkxx.log where xx is the number of the worker that had failed. If submitting the problem to Oracle Support as a service request, please upload the adadmin log and the relevant adworker log.

Monday 13 July 2015

Starting/Stopping Oracle Enterprise Manager Cloud Control

export ORACLE_HOME=/u01/app/oracle/oms/oracle_common

/u01/app/oracle/oms/oms/bin> ./emctl stop oms -all

/oms11g/bin> ./emctl start oms