Monday, November 23, 2015

Change JAVA default location of Linux




When you install a product for example 12 C versions Oracle when you are running the installer this ask you for a specific JAVA version and there is no other way to set that if you don't install it, even when set JAVA_HOME, JRE_HOME, JDK_HOME, (Or I haven't find it yet)
So, download the JAVA version you want and move it to:

/usr/lib/jvm/jdk1.7.0_79 (for example)

To set your JAVA version and associate it to java command, then configure the JAVA command, with root privileges run:

sudo update-alternatives --install "/usr/bin/java" "java" "/usr/lib/jvm/jdk1.7.0_79/bin/java" 1
sudo update-alternatives --config java

Optionally you can set:

export JAVA_HOME=/usr/java/jdk1.7.0_79
export JRE_HOME=/usr/java/jdk1.7.0_79/jre
export JDK_HOME=/usr/java/jdk1.7.0_79

In your bash_profile.

Restart bash or reboot.

Note:

When you install java with rpm  option, this is installed in /user/java/(java_version)

Annexed:

Remove-->

sudo update-alternatives --remove "java" "/usr/lib/jvm/jre-1.6.0-openjdk.x86_64/bin/java"  

Friday, July 24, 2015

Change Dynamic Ip to Static Ip Oracle Linux Server



Change the network file, and set the gateway


[oracle@alexdb ~]$ cat  /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=alexdb.oracle.com
GATEWAY=192.168.x.x

Change your interface:
/etc/sysconfig/network-scripts/ifcfg-eth0

Check the values in red

DEVICE=eth0
NM_CONTROLLED=yes
HWADDR=00:21:F6:3F:3A:69
TYPE=Ethernet
UUID=ea5fd29b-4752-4ef7-890f-9611c18eb4c6
DEFROUTE=yes
IPV4_FAILURE_FATAL=yes
IPV6INIT=no
NAME="System eth0"
ONBOOT=yes
PEERROUTES=yes
IPADDR=192.168.128.63
GATEWAY=192.168.128.1
NETMASK=255.255.255.0
BOOTPROTO=static
USERCTL=no


Change the hosts file /etc/hosts


issue the following command:
service network restart

Your mac address must match HWADDR=00:21:F6:3F:3A:69 to your interface address

ifup eth0 if your interface is not available. 

Cheers!


Tuesday, June 30, 2015

How to change UUID from VDI Virtual Box


Today I had a problem, I ran out of time and I had to create a clone of virtual machine but I didn't wanted to install again the SO,  what I did is create a duplicate in file system of the vm. When I tried to start both machines at same time I get an error of UUID.

To fix this:

I changed the UUID with a vbox command



C:\Program Files\Oracle\VirtualBox>VBoxManage.exe internalcommands sethduuid "C:
\Users\Alejandro\VirtualBox VMs\OL6.6_BI1\OL6.6.vdi"

UUID changed to: 762eadf7-3b7a-4d9b-a08f-6a88e888931b


Then I got an Error with the VM when I was trying to started it, Checking the files associated I realized that the old UUID was in, So I use the new UUID and replace the UUID reference in the file associated to the VDI the vbox file.

Content:

<?xml version="1.0"?>
<!--
** DO NOT EDIT THIS FILE.
** If you make changes to this file while any VirtualBox related application
** is running, your changes will be overwritten later, without taking effect.
** Use VBoxManage or the VirtualBox Manager GUI to make changes.
-->
<VirtualBox xmlns="http://www.innotek.de/VirtualBox-settings" version="1.14-windows">
  <Machine uuid="{762eadf7-3b7a-4d9b-a08f-6a88e888931b}" name="OL6.6" OSType="Oracle_64" snapshotFolder="Snapshots" lastStateChange="2015-07-01T02:37:11Z">
    <MediaRegistry>
      <HardDisks>
        <HardDisk uuid="{762eadf7-3b7a-4d9b-a08f-6a88e888931b}" location="OL6.6.vdi" format="VDI" type="Normal"/>
      </HardDisks>
      <DVDImages/>
      <FloppyImages/>
    </MediaRegistry>
    <ExtraData>
      <ExtraDataItem name="GUI/LastCloseAction" value="PowerOff"/>
      <ExtraDataItem name="GUI/LastGuestSizeHint" value="640,480"/>
      <ExtraDataItem name="GUI/LastNormalWindowPosition" value="806,72,944,394,max"/>
      <ExtraDataItem name="GUI/MiniToolBarAlignment" value="bottom"/>
      <ExtraDataItem name="GUI/SaveMountedAtRuntime" value="yes"/>
      <ExtraDataItem name="GUI/ShowMiniToolBar" value="yes"/>
    </ExtraData>
    <Hardware version="2">
      <CPU count="1" hotplug="false">
        <HardwareVirtEx enabled="true"/>
        <HardwareVirtExNestedPaging enabled="true"/>
        <HardwareVirtExVPID enabled="true"/>
        <HardwareVirtExUX enabled="true"/>
        <PAE enabled="true"/>
        <LongMode enabled="true"/>
        <HardwareVirtExLargePages enabled="true"/>
        <HardwareVirtForce enabled="false"/>
      </CPU>
      <Memory RAMSize="4096" PageFusion="false"/>
      <HID Pointing="PS2Mouse" Keyboard="PS2Keyboard"/>
      <HPET enabled="false"/>
      <Chipset type="PIIX3"/>
      <Boot>
        <Order position="1" device="Floppy"/>
        <Order position="2" device="DVD"/>
        <Order position="3" device="HardDisk"/>
        <Order position="4" device="None"/>
      </Boot>
      <Display VRAMSize="12" monitorCount="1" accelerate3D="false" accelerate2DVideo="false"/>
      <VideoCapture enabled="false" screens="18446744073709551615" horzRes="1024" vertRes="768" rate="512" fps="25"/>
      <RemoteDisplay enabled="false" authType="Null" authTimeout="5000"/>
      <BIOS>
        <ACPI enabled="true"/>
        <IOAPIC enabled="true"/>
        <Logo fadeIn="true" fadeOut="true" displayTime="0"/>
        <BootMenu mode="MessageAndMenu"/>
        <TimeOffset value="0"/>
        <PXEDebug enabled="false"/>
      </BIOS>
      <USB>
        <Controllers>
          <Controller name="OHCI" type="OHCI"/>
          <Controller name="EHCI" type="EHCI"/>
        </Controllers>
        <DeviceFilters/>
      </USB>
      <Network>
        <Adapter slot="0" enabled="true" MACAddress="08002723B9FA" cable="true" speed="0" promiscuousModePolicy="AllowAll" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
            <InternalNetwork name="intnet"/>
            <NATNetwork name="NatNetwork"/>
          </DisabledModes>
          <BridgedInterface name="Intel(R) Dual Band Wireless-AC 7260"/>
        </Adapter>
        <Adapter slot="1" enabled="false" MACAddress="0800274AF066" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="2" enabled="false" MACAddress="0800278B7008" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="3" enabled="false" MACAddress="08002755B6EB" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="4" enabled="false" MACAddress="0800277F3F9A" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="5" enabled="false" MACAddress="080027677373" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="6" enabled="false" MACAddress="080027B9B276" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
        <Adapter slot="7" enabled="false" MACAddress="080027F0677A" cable="true" speed="0" type="82540EM">
          <DisabledModes>
            <NAT>
              <DNS pass-domain="true" use-proxy="false" use-host-resolver="false"/>
              <Alias logging="false" proxy-only="false" use-same-ports="false"/>
            </NAT>
          </DisabledModes>
        </Adapter>
      </Network>
      <UART>
        <Port slot="0" enabled="false" IOBase="0x3f8" IRQ="4" hostMode="Disconnected"/>
        <Port slot="1" enabled="false" IOBase="0x2f8" IRQ="3" hostMode="Disconnected"/>
      </UART>
      <LPT>
        <Port slot="0" enabled="false" IOBase="0x378" IRQ="7"/>
        <Port slot="1" enabled="false" IOBase="0x378" IRQ="7"/>
      </LPT>
      <AudioAdapter controller="AC97" driver="DirectSound" enabled="true"/>
      <RTC localOrUTC="UTC"/>
      <SharedFolders>
        <SharedFolder name="Programas" hostPath="C:\Oracle\Programas" writable="true" autoMount="true"/>
      </SharedFolders>
      <Clipboard mode="Bidirectional"/>
      <DragAndDrop mode="Bidirectional"/>
      <IO>
        <IoCache enabled="true" size="5"/>
        <BandwidthGroups/>
      </IO>
      <HostPci>
        <Devices/>
      </HostPci>
      <EmulatedUSB>
        <CardReader enabled="false"/>
      </EmulatedUSB>
      <Guest memoryBalloonSize="0"/>
      <GuestProperties>
        <GuestProperty name="/VirtualBox/GuestAdd/HostVerLastChecked" value="4.3.26" timestamp="1435712622146009900" flags=""/>
        <GuestProperty name="/VirtualBox/GuestAdd/Revision" value="98988" timestamp="1435712516094043001" flags=""/>
        <GuestProperty name="/VirtualBox/GuestAdd/Vbgl/Video/0" value="1920x954x0,0x0,1" timestamp="1435712592180704800" flags=""/>
        <GuestProperty name="/VirtualBox/GuestAdd/Vbgl/Video/SavedMode" value="1920x954x0" timestamp="1435712592181204800" flags=""/>
        <GuestProperty name="/VirtualBox/GuestAdd/Version" value="4.3.26" timestamp="1435712516093542900" flags=""/>
        <GuestProperty name="/VirtualBox/GuestAdd/VersionExt" value="4.3.26" timestamp="1435712516094043000" flags=""/>
        <GuestProperty name="/VirtualBox/GuestInfo/OS/Product" value="Linux" timestamp="1435712516092542800" flags=""/>
        <GuestProperty name="/VirtualBox/GuestInfo/OS/Release" value="2.6.39-400.17.1.el6uek.x86_64" timestamp="1435712516093042900" flags=""/>
        <GuestProperty name="/VirtualBox/GuestInfo/OS/Version" value="#1 SMP Fri Feb 22 18:16:18 PST 2013" timestamp="1435712516093042901" flags=""/>
        <GuestProperty name="/VirtualBox/HostInfo/GUI/LanguageID" value="es_ES" timestamp="1435709890894685000" flags=""/>
      </GuestProperties>
    </Hardware>
    <StorageControllers>
      <StorageController name="IDE" type="PIIX4" PortCount="2" useHostIOCache="true" Bootable="true">
        <AttachedDevice passthrough="false" type="DVD" port="1" device="0">
          <HostDrive src="D:"/>
        </AttachedDevice>
      </StorageController>
      <StorageController name="SATA" type="AHCI" PortCount="1" useHostIOCache="false" Bootable="true" IDE0MasterEmulationPort="0" IDE0SlaveEmulationPort="1" IDE1MasterEmulationPort="2" IDE1SlaveEmulationPort="3">
        <AttachedDevice type="HardDisk" port="0" device="0">
          <Image uuid="{762eadf7-3b7a-4d9b-a08f-6a88e888931b}"/>
        </AttachedDevice>
      </StorageController>
    </StorageControllers>
  </Machine>
</VirtualBox>

Now I have my two duplicate VM's! =)

How to change OLS Hostname




1.- Edit the file sudo vi /etc/sysconfig/network
2- Add the new hostname, and save.

3.- Modify the /etc/hosts

4.- Save and reboot.



voilà!!!!!


Installing DB 11g on Virtual Box part 2

9.-  Add the following groups

sudo groupadd -g 501 oinstall
sudo groupadd -g 502 dba
sudo groupadd -g 503 oper
sudo groupadd -g 504 asmadmin
sudo groupadd -g 506 asmdba
sudo groupadd -g 505 asmoper

10.- If you don't have the user created yet:

sudo useradd -u 502 -g oinstall -G dba,asmdba,oper oracle

if the user already exists:

sudo usermod -g oinstall -G dba,asmdba,oper oracle

if you want to change the user password:

passwd oracle

11.- For the 11GR2 version add the following line to this file "/etc/security/limits.d/90-nproc.conf"
# Change this
*          soft    nproc    1024

#to this:
* - nproc 16384


12.- Add the following property to the file "/etc/selinux/config"
SELINUX=permissive

13.- Restart OS.

14.- Disable firewall

15.- Create directories
sudo mkdir -p /u01/app/oracle/product/11gr2/db_1

16.- Change Group
sudo chown -R oracle:oinstall /u01

17.- If your installation is remote, set the display for launching windows
xhost +alexdb.oracle.com

alexdb.oracle.com being added to access control list

18.- Add the following lines to your db owner user

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=yourhost; export ORACLE_HOSTNAME
ORACLE_UNQNAME=yoursid; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11gr2/db_1; export ORACLE_HOME
ORACLE_SID=yoursid; export ORACLE_SID

PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

19.- Run the installer
./runInstaller

If you have missing libraries, install them with yum

Example:

sudo yum install compat-libstdc++-33
yum install libaio.i686 libaio-devel.i686 compat-libstdc++-33.i686 libstdc++.i686
yum install libaio libaio-devel compat-libstdc++-33 libstdc++
yum install unixODBC
yum install unixODBC-devel
yum install elfutils-libelf-devel
yum install pdksh

Finish your installation, executing the following sentences:

sh /u01/app/oraInventory/orainstRoot.sh
sh /u01/app/oracle/product/11gr2/db_1/root.sh 

if you want your db starting every time your machine restart, add this line to /etc/oratab

your_sid:/u01/app/oracle/product/11gr2/db_1:y

Enterprise Manager Database Control URL - (yoursid) :
https://localhost:1158/em

Cannot resolve hostname for interface any from opmnctl

I ran into a problem when I was starting up my BiSystem this because an issue regarding the hostname

The error:

opmnctl status: opmn is not running.
opmnctl start: failed. Can not resolve <hostname> for interface any

I modify my /etc/hosts

according this note:

http://docs.oracle.com/cd/E14571_01/install.1111/b32474/common.htm#ASINS283

Separate the domain name from the localhost information like this:

127.0.0.1      localhost.localdomain localhost
ip    alex alexdb.oracle.com

Now my system is up and running.

Tuesday, June 23, 2015

ImportError: no module named security OIAM



In some cases when you try to configure the security yo get this error:

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Problem invoking WLST - Traceback (innermost last):
  File "/u02/Middleware/Oracle_IDM1/common/tools/configureSecurityStore.py", line 15, in ?
ImportError: no module named security

this because you misplaced the path

Example:

[oracle@alexdb bin]$ pwd
/u02/Middleware/wlserver_10.3/common/bin
[oracle@alexdb bin]$ 

The command:

./wlst.sh /u02/Middleware/Oracle_IDM1/common/tools/configureSecurityStore.py -d /u02/Middleware/user_projects/domains/oam11g_domain –c IAM –p admin –m create


The correct way:

[oracle@alexdb bin]$ pwd
/u02/Middleware/oracle_common/common/bin
[oracle@alexdb bin]$ ./wlst.sh /u02/Middleware/Oracle_IDM1/common/tools/configureSecurityStore.py -d /u02/Middleware/user_projects/domains/oam11g_domain –c IAM –p admin –m create



Info: Data source is: opss-DBDS
Please input data source password:
Info: DB JDBC driver: oracle.jdbc.OracleDriver
Info: DB JDBC URL: jdbc:oracle:thin:@alexdb.oracle.com:1521/odb11g
Connected:oracle.jdbc.driver.T4CConnection@1e7f7b92
Disconnect:oracle.jdbc.driver.T4CConnection@1e7f7b92
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  checkServiceSetup - done
Jun 23, 2015 3:38:35 PM oracle.security.jps.internal.config.ldap.LdapCredStoreServiceConfigurator schemaCompatibleHandler
INFO: Credential store schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  seedSchemaAndCreateDIT - done
Jun 23, 2015 3:38:37 PM oracle.security.audit.Auditor init
WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.
Jun 23, 2015 3:38:37 PM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to true
Jun 23, 2015 3:38:37 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible
WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.
Jun 23, 2015 3:38:38 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationCredImpl migrateCredentialData
INFO: Migration of Credential Store data in progress.....
Jun 23, 2015 3:38:38 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationCredImpl migrateCredentialData
INFO: Migration of Credential Store data completed, Time taken for migration is 00:00:00
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  migrateData - done
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  testJpsService - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  checkServiceSetup - done
Jun 23, 2015 3:38:38 PM oracle.security.jps.internal.config.ldap.LdapKeyStoreServiceConfigurator schemaCompatibleHandler
INFO: Keystore schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  seedSchemaAndCreateDIT - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  migrateData - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  testJpsService - done
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  checkServiceSetup - done
Jun 23, 2015 3:38:40 PM oracle.security.jps.internal.config.ldap.LdapPolicyStoreServiceConfigurator schemaCompatibleHandler
INFO: Policy schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  seedSchemaAndCreateDIT - done
Jun 23, 2015 3:38:42 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationPolicyImpl migrateAllPolicyData
INFO: Migration of All[Application + Global] policies in progress.....
WLS ManagedService is not up running. Fall back to use system properties for configuration.
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy migrateDataInternal
INFO: Migration of Admin Roles started
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy cloneAdminRoleMembers
INFO: Migration of Admin Role Members started
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy cloneAdminRoleMembers
INFO: Migration of 1 Admin Role Members completed in 00:00:00
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.destination.apibased.JpsDstPolicy migrateDataInternal
INFO: Migration of 1 Admin Roles completed in 00:00:00
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationPolicyImpl migrateAllPolicyData
INFO: Migration of All[Application + Global] policies completed, Time taken for migration is 00:00:02
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  migrateData - done
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  testJpsService - done
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  checkServiceSetup - done
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.config.ldap.LdapAuditServiceConfigurator schemaCompatibleHandler
INFO: Audit store schema upgrade not required. Store Schema version 11.1.1.9.0 is compatible to the seed schema version 11.1.1.9.0
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  checkServiceSchema - Store schema has been seeded completely
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  seedSchemaAndCreateDIT - done
Jun 23, 2015 3:38:44 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationAuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data in progress.....
Jun 23, 2015 3:38:47 PM oracle.security.jps.internal.tools.utility.JpsUtilMigrationAuditStoreImpl migrateAuditStoreData
INFO: Migration of Audit Store data completed, Time taken for migration is 00:00:02
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  migrateData - done
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  testJpsService - done
persist to output: /u02/Middleware/user_projects/domains/oam11g_domain/config/fmwconfig - done
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  checkServiceSetup - done
[oracle.security.jps.internal.config.db.DbCredStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  checkServiceSetup - done
[oracle.security.jps.internal.config.db.DbKeyStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  checkServiceSetup - done
[oracle.security.jps.internal.config.db.DbPolicyStoreServiceConfigurator]  updateServiceConfiguration - done
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  checkServiceSetup - done
[oracle.security.jps.internal.config.db.DbAuditStoreServiceConfigurator]  updateServiceConfiguration - done
Jun 23, 2015 3:38:55 PM oracle.security.audit.Auditor init
WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.
Jun 23, 2015 3:38:55 PM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to true
Jun 23, 2015 3:38:55 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible
WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.
persist to output: /u02/Middleware/user_projects/domains/oam11g_domain/config/fmwconfig - done
Jun 23, 2015 3:39:01 PM oracle.security.audit.Auditor init
WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.
Jun 23, 2015 3:39:01 PM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to true
Jun 23, 2015 3:39:01 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible
WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.
Using default context in /u02/Middleware/user_projects/domains/oam11g_domain/config/fmwconfig/jps-config-migration.xml file for credential store.
Credential store location : jdbc:oracle:thin:@alexdb.oracle.com:1521/odb11g
Jun 23, 2015 3:39:14 PM oracle.security.audit.Auditor init
WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.
Jun 23, 2015 3:39:14 PM oracle.security.jps.util.JpsUtil disableAudit
INFO: JpsUtil: isAuditDisabled set to true
Jun 23, 2015 3:39:14 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible
WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.
Credential with map Oracle-IAM-Security-Store-Diagnostics key Test-Cred stored successfully!


Credential for map Oracle-IAM-Security-Store-Diagnostics and key Test-Cred is: 
GenericCredential
Info: diagnostic credential created in the credential store.
Info:  Create operation has completed successfully.
[oracle@alexdb bin]$ 






Thursday, June 18, 2015

Installing DB 11g on Virtual Box

1.- Add oracle to sudoers.

2.- Add hostname to hosts file

<IP-address>  <fully-qualified-machine-name>  <machine-name>

3.- Add or amend the following lines in the "/etc/sysctl.conf" file, use an editor or vi command.

fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

4.- Let's check the file 
ls -la /etc/sysctl.conf


5.- Save the file.

6.- Recompile kernel parameters

/sbin/sysctl -p

7.- Add the following lines to the "/etc/security/limits.conf" file.

oracle              soft    nproc   16384
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

8.- Check if the following libraries are present

rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*


In the next post i'm going to finish the main configuration.

Wednesday, June 17, 2015

Configure OLS 7.1 with Virtual Box with Guest Additions

When you try to mount a device, or share a folder in your VM, you got an unknow device error, that's because the kernel headers are incompatibles

The solution is update the system:

yum -y update kernel
yum -y install kernel-devel kernel-headers dkms gcc gcc-c++
Reboot the system.


Then Re-run the command VBoxLinuxAdditions.run

All the shared folder are under /media/ with the prefix sf_<folder>

If you don't have access to your shared folder, add the OS user to the virtual-box group,

therefore you will get access to your resource.

The commands:

gpasswd -a your_user_name vboxsf

groups your_user_name

Reboot.


Monday, June 15, 2015

Repository Creation Utility prerequisites OIM



When you run the RCU, you got an exception regarding database parameters values, you fix it with the following lines:

ALTER SYSTEM SET PROCESSES=800 SCOPE=SPFILE;

ALTER SYSTEM SET OPEN_CURSORS=800 SCOPE=BOTH;

restart your DB.

Sunday, June 7, 2015

Installing ODI 12c and Enterprise Agent


Pre-Requisites of Installation

  1. The environment is set with the next physical characteristics:
    1. Windows 7 Professional 64 bits 
    2. Intel (R) Core (TM) i5-4200U CPU @ 1.60GHz 2.30 GHz
    3. 6 GB in RAM
  2. Download the next software:
    1. jdk-7u75-windows-i586.exe
    2. fmw_12.1.3.0.0_infrastructure.jar
    3. fmw_12.1.3.0.0_odi.jar
  3. Installing of JDK 7
    1. Choose the installation path 
    2. Finish the process of installation
    3. Add the environment variables
    4. Check the value of the variables

Installation of the Infrastructure 12.1.3.0.0

1. Execute the file.jar whit command java –jar fmw_12.1.3.0.0_infrastructure.jar 
2. Wait to that the process continue and click on Next
3. Choose the installation directory and click on Next

4. Choose the option “Infraestructura de Fusion Middleware” and click on Next

5. Wait to that finish  the process of validation of requisites of system and click Next
6. Click on “Install” for installation confirm
7. Click on Next for continue with the process
8. Click on “Terminar” for finish the installation process

Installation of ODI 12.1.3.0.0

1. Execute the file.jar whit command java –jar fmw_12.1.3.0.0_odi.jar 
2. Wait for the process to finish loading files and click on Next 
3. Choose the directory of the infrastructure previously installed and click on Next

4. Choose the installation the Enterprise type and click on Next 
 
5. Wait to that finish  the process of validation of requisites of system and click Next
6. Click on "Instalar" for confirm the installation

7. Click on Next for continue 
8. Click on "Terminar" for finish the installation process


Installation of RCU for odi 12.1.3.0.0  


1. Access to the infrastructure path  C:\Oracle\fmw12c\oracle_common\bin and execute the file rcu.bat
2. Wait for the process to finish loading files and click on Next 
3. Choose the option "Crear Repositorio" 
4. Write the correct data of connection to the DB 

5.  Click Aceptar on the emergent window 
6.  Choose the option "Crear Nuevo Prefijo"

7.  Click Aceptar on the emergent window
8.  Write a password for the schemas
9.  Write the data next: 
     Contraseña para el usuario SUPERVISOR: *** 
     Tipo del Repositorio de Trabajo: D 
     Nombre del Repositorio de Trabajo: WORKREP 
     Contraseña para el Repositorio de Trabajo: *** 
     Algoritmo de cifrado: AES-128
 
10. Click on Next for continue
11. Click Aceptar on the emergent window
12. Click on Crear for confirm the creation of the schemas 
13. Click on Cerrar for finish the process 

Creation of the Domain

1.  Access the directory  C:\Oracle\fmw12c\oracle_common\common\bin and execute the script config.cm 
2.  Choose the option "Crear Nuevo Dominio". Write Name and path the domain and click Next

3.  Choose the products to install and click on Next

4.  Write the credentials for the Administrator user 
5.  Choose Production Mode and check the JDK 

6.  Write the correct information of the schemas and click Next 

7.  Click on Next for continue with the process 
8.  Check that the tests are successfull

9.  Write the credentials for SUPERVISOR user

10. Choose the next options and Click on Next 

11. Leave the defaults and Click on Next 
12. Write the values for NodeManager and Click on Next 
13. Write the values for Managed servers and Click on Next
  
14. Click on Next 
15. Leave the defaults and Click on Next 
16. Write the Machine Name for the Domain 

17. Set the servers to the machine 

18. Leave the defaults and Click on Next

19. Write the values for OracleDIAgent1 and Click on Next 

20. Set OracleDIAgent1 to the machine and Click on Next 
21. Click on "Crear" for continue 
22. Click on Next for continue 
23. Click on "Terminar" for finish the process

Configuration to the Enterprise Agent


1.  Start Adminserver and odi_server1
2.  Navigate to Deployments in the weblogic console and search oraclediagent. Note that the state is Failed

3.  Navigate to Deployments > odiconsole >Test. Click on the first link

4.  Login in the odiconsole with the correct credentials

5.  Navigate to Exploration > Topology > Agents
6.  Right-click on physical agents and choose Create

7.  Write the values for new agent 

8.  Now create the Logic Agent. Right-click Logical Agents > Create 

9.  Right-Click on the new agent logical and click Edit
10.Check the mapping with physical agent
  
11. Navigate a Deployments in the weblogic console 
12. Start oraclediagent 
13. Check that the new state is Active