SOACS Timezone

Setting the SOACS timezone

So we have provisioned servers in the cloud but the time is in UTC.

UTCbeforereboot

You wanted to use BST, this is how it can be done.

1) Log onto the SOA Server

2) All the timezones you can use can be found in the following /usr/share/zoneinfo -  As root change the target for localtime as below

3) When we reboot, we want this setting to be permanent , so we do the following : Save/Exit 4) Reboot the server 5) Log into EM.

UTCafterrebootv2

   

Monitoring Exalytics (linux 5) with EM13C – Part 1

Fresh Install of EM 13C and the challenges of pushing a 12.1.0.5 agent for linux 5 from EM13C.

Oracle Enterprise Manager is an on premise management platform, we decided to investigate the use of 13c and see what benefits we could get by using this to monitor our exalytics system as well as our other Oracle portfolio including premise and cloud applications. There is many blogs on this but I had some interesting challenges that were difficult to resolve that I wanted to share. During this setup, I did reach out to some well-known EM13C experts that I wanted to say thanks to Kellyn - http://dbakevlar.com - @DBAKevlar and Philip - http://redstk.com/blog - @pbedba.  When 13c came out they did not allow you to push or extract an agent that was lets say 12.1.0.5 that you would need if you have linux 5 running.  It was OK if you already had an agent already installed and upgraded to 13 on the OMS server.  This is where the fun began, In this post I will cover the basics as what was needed to be done to extract a 12.1.0.5 agent and install.  Oracle released a few patches for this in the last 6 weeks to help with this which I will also cover. We are installing this on windows 8, First thing we do is download the following:
  • 12c Enterprise database
  • Database templates for EM13.
  • EM13
Ensure your account has administrator privileges.

DB12c Install

Start the installer for Oracle 12c Database. Click next Select install database software only. For this we are selecting single instance database installation. We are installing Enterprise Edition. Remember the password. Enter the paths and click next. We have installed the database. Unzip the database templates for EM to (This will be the location where you have installed the database software, ensure you unzip the templates to the templates folder. C:\app\kt1\product\12.1.0\dbhome_1\assistants\dbca\templates C:\app\kt1\product\12.1.0\dbhome_1\BIN Run dbca.bat as administrator Select next Select advanced mode click next. If you have saved the templates to the correct location you will see the templates in the above screen. Enter your database name and click next. Ensure nothing is selected in screen above and click next. For this example we are using the same password, note your password.     Select create a new listener, and give it a name and the port you want to use.   Select filesystem,Click next.   In the above screen select the following file, which should be where you extracted your templates.: shpool_12.1.0.2.0_Database_SQL_for_EM13_1_0_0_0.sql Click Next      Click Next Click Finish   Database Created.

EM13c Install

Select next Select skip for now, and click next. As I am installing this on my laptop, I have ignore this error. Still works OK J, I have 8gb memory.   Click Yes We are doing simple. Enter your details as well as your host name.   Enter the password you want for your EM, and provide your database connection details. Select next. Click Install. You will see the installation progress.  

Downloading Agent Software

Our Exalytics system we need to install the agent 12.1.0.5, Log into your EM13C., Select Setup/Extensibility/Self Update,   Drill down into the agent software. Select version 12.1.0.5 Click Download At this point I started hitting problems. 13c did not allow you to push to a 12.1.0.5 agent by default, to be able to do this you will need to patch the EM13C. As when you try to export the agent you get an error as below. Download Patch 22741755 and install as per Read Me, remember on windows ensure you do this as Administrator. Once done also verify it is Installed !!! Lets try and export the agent on the host again. Agent Extracted !!! J

Exalytics Configuration

Log onto your ILOM and ensure the SP system identifier is entered. Log onto your exalytics system As Root

Agent Install onto exalytics

Create a directory on the Target: **This is a known BUG (Heartbeat Status : OMS responded illegally [ERROR- Failed to Update Target Type Metadata]) Download Patch
Patch 22581985: 12.1.0.5.0 agent & 13.1 OMS returns ERROR- Failed to Update Target Type Metadata
 
Install it and verify it as per previous patch. We are now ready to Discover the Exalytics system in EM13C.  

ERROR: -14(asmlib /opt/oracle/extapi/64/asm/orcl/1/libasm.so version failed with 2

So you have decided to patch your OS, after patching you cannot start the ASM, when you look into the alert log for the ASM you see the following: Errors in file /u01/app/oracle/product/11.2.0/grid/log/diag/asm/+asm/+ASM/trace/+ASM_rbal_5702.trc: ORA-15183: ASMLIB initialization error [driver/agent not installed] WARNING: FAILED to load library: /opt/oracle/extapi/64/asm/orcl/1/libasm.so ERROR: no read quorum in group: required 2, found 0 disks NOTE: cache dismounting (clean) group 1/0xC9C86BB1 (DATA) NOTE: messaging CKPT to quiesce pins Unix process pid: 5733, NOTE: dbwr not being msg'd to dismount NOTE: lgwr not being msg'd to dismount NOTE: cache dismounted group 1/0xC9C86BB1 (DATA) NOTE: cache ending mount (fail) of group DATA number=1 incarn=0xc9c86bb1 NOTE: cache deleting context for group DATA 1/0xc9c86bb1 Tue Jun 09 17:28:12 2015 ERROR: -14(asmlib /opt/oracle/extapi/64/asm/orcl/1/libasm.so version failed with 2 ) Check the following as it could be the kernal: # uname -rm 2.6.18-406.el5 x86_64 # rpm -qa |grep asm oracleasm-2.6.18-371.3.1.el5-2.0.5-1.el5 oracleasm-support-2.1.8-1.el5 oracleasmlib-2.0.4-1.el5 We can see from the above commands that the kernal has changed to 2.6.18-406 and we only have the packages installed for 2.6.18-371.  We need to download the package. Navigate to : http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html Scroll down to your architecture for example Intel EM64T (x86_64) Architecture Library and Tools From here we can see in the list the following : oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm - This matches our kernal from our OS command earlier, download this. # rpm -Uvh oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm warning: oracleasm-2.6.18-406.el5-2.0.5-1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 Preparing... ########################################### [100%] 1:oracleasm-2.6.18-406.el########################################### [100%] # /etc/init.d/oracleasm start Initializing the Oracle ASMLib driver: [ OK ] Scanning the system for Oracle ASMLib disks: [ OK ] The ASM is up and running again!!!      

Oracle export from Oracle 7.3 (AIX) to Oracle 11g (Linux)

If you have an old AIX IBM Server you will know, there is a limit of the size of file you can have, what do you do if the database is much bigger than the limit.  In the example below we will split the file to 1gb chunks. ----------- Export Section L1:/home5/dump > mknod /tmp/split_pipe p L1:/home5/dump > mknod /tmp/exp.pipe p mknod: /tmp/exp.pipe: Do not specify an existing file. L1:/home5/dump > nohup split -b1000m < /tmp/split_pipe > /home5/dump/L1_dmp.dmp.Z & [1]     18820 L1:/home5/dump > nohup compress < /tmp/exp.pipe > /tmp/split_pipe & [2]     16918 L1:/home5/dump > nohup exp system/12345 file=/tmp/exp.pipe full=Y log=/home5/dump/exp_live.txt & [3]     19830 L1:/home5/dump > Sending nohup output to nohup.out. ------------------ IMPORT Section # The import script assumes in this example that the above export script created 2 split files # called expfileaa and expfileab. The order of the file for the cat command is very important. Copy the files over to the Linux machine. mknod /tmp/split_pipe p cat /cima1/backup/export/infobase/xaa /cima1/backup/export/infobase/xab > /cima1/backup/export/infobase/L1.dmp.Z uncompress L1.dmp.Z SQL> CREATE DIRECTORY aix AS '/backup/export/aix’; Directory created. SQL> GRANT read, write ON DIRECTORY aix TO starsky; Grant succeeded. imp startsky/12345 full=y file=L1.dmp show=y log=import.sql Conclusion Well you have exported a database in AIX by splitting the file, thereafter moving the files to linux and importing them into a Oracle 11g Database.