Create custom metadata profile in WCC

Once logged in WCC

Navigate to
Administration->Admin Applets->Configuration Manager
Add the new field by clicking on Add...

This will prompt for:

Field Name, Field Caption, Field Type and so on...

Also you will be able to create an option list

A lot of options you will have, for example, validated, non validated lists, multiselect lists, edit and select. dependant values etc ...

Note:

The field order field will allow you tu allocate the field on the desired location on the user interface.

You must make sure that the Enable User Interface checkbox is enabled.

Custom Checkin, Create security group in WCC

Security Group

Access this screen using a browser, choose Administration, then Admin Applets, then User Admin.

Then start the applet:

1. To create a security group and assign permissions:
   

   1. From the User Admin Screen, select Security then Permissions by Group.
      The Permissions By Group Screen is displayed.
   2. Click Add Group to display the Add New Group Screen.
   3. Enter a group name and description.
   4. Click OK.
   5. Set permissions for the security group:
   1. Select the security group.
   2. Select the role to edit.
   3. Click Edit Permissions.
   4. After enabling the permissions that you want the role to have for the group, click OK to close the Permissions by Group screen

   
   

In my next post, I will show you how to creare a custom metadata profile in WCC.

See you.

Inplace upgrade, Reuse the existing OWB Home

The following steps are used to recover an existing OWB Home.

1.- Get the OWBSYS and OWBSYS_AUDIT users

Execute the following sentences:

2.- sqlplus OWBSYS/*****@OWB_HOME/owb/rtp/sql/stop_service.sql
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb

chmod +x ./app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS ***

3.- Run the following SQL statement to identify the OWB_HOME for the current installation. The rtrepos.properties file is located in the path indicated by the SERVER_SIDE_HOME of the query.

1. sqlplus OWBSYS/OWBSYS_PASSWORD
2. SELECT host_name, server_side_home from wb_rt_service_nodes s, v$instance v where s.instance_number=v.instance_number;
   HOST_NAME
   SERVER_SIDE_HOME
   yourhost_machine
   OWB_HOME

4.- For an existing repository that is installed on an Oracle 11g database (not Oracle 10g), ensure that OWB_HOME and ORACLE_SID values are pointing to the database where the repository is installed. Ensure that the PATH contains OWB_HOME/bin.

If the rtrepos.properties file is not found then:

• sqlplus owbsys/*********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.pks
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/secHelper.plb
  @/u01/app/oracle/product/11.2.0/dbhome_1/owb/reposasst/upg/load_java.sql OWBSYS *********
• @/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/reset_repository.sql *********

The reset_repository forces the user to register the location again using the Control Center Manager.

When the file is created START the service.

@/u01/app/oracle/product/11.2.0/dbhome_1/owb/rtp/sql/start_service.

Ce tout!

Integration FDMEE with ERP Fusion

Recently, I was asking to integrate FDMEE with ERP Fusion using the WSDL,

using the FusionCloudAdapter.sh and FusionCloudAdapter.py.

The ODI Log throws the following exception:


2017-10-11 13:20:36,490 ERROR [AIF]: Error in initializeFsGLCloudSource.
2017-10-11 13:20:36,491 FATAL [AIF]: Error in initializeFsGLCloudSource
Traceback (most recent call last):
  File "<string>", line 451, in initializeFsGLCloudSource
  File "<string>", line 475, in executeFusionService
  File "<string>", line 557, in executeJythonScript
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 138, in <module>
    fusionCloudAdapter.extractCubeInformation()
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 16, in extractCubeInformation
    self.fusionCloudHelper("extractCubeInformation")
  File "/u01/hyp/hyperion/EPMSystem11R1/products/FinancialDataQuality/bin/FusionCloud/FusionCloudAdapter.py", line 112, in fusionCloudHelper
    raise RuntimeError
RuntimeError

Reviewing OS Level and Application Level I realize that the file was asking about other permissions to be executable.

Solution:

chmod +x -Rf  * in the folder there the py  adapter  and the sh file es located.

Test the wsdl service located in cloud. -> Success.

Charms !

Move Centos 7 Virtual Machine on Hyper-v to Oracle IaaS

A few months ago I had a requirement which was move an virtual machine with CentOS 7.2.1511 virtualized it at Hyper-v 10.0.14393.0 to Oracle IaaS.

In first place everything was well but when  I uploaded the image.tar.gz in Oracle IaaS Console was showing the next error:

[ [32m  OK  [0m] Started Show Plymouth Boot Screen.
[ [32m  OK  [0m] Reached target Paths.
[ [32m  OK  [0m] Reached target Basic System.
%G[    2.263078] tsc: Refined TSC clocksource calibration: 2992.789 MHz
[    2.473407] input: ImExPS/2 Generic Explorer Mouse as /devices/platform/i8042/serio1/input/input3
[  124.435211] dracut-initqueue[258]: Warning: dracut-initqueue timeout - starting timeout scripts
[  124.947098] dracut-initqueue[258]: Warning: dracut-initqueue timeout - starting timeout scripts


For to continue I describe my configuration:

Tools to use.
Hyper-v Hypervisor
Qemu-img utility

The Machine virtualized it in Hyper-v had vhdx format.

How to prepare the machine?

• In "fstab file" verify that doesn´t exist external discs. comment or delete.
• Edit the "ifcfg-eth0 file":

# vi /etc/sysconfig/network
BOOTPROTO="dhcp"
ONBOOT=yes
TYPE="Ethernet"
USERCTL="yes"
PEERDNS="yes"
IPV6INIT="no"
PERSISTENT_DHCLIENT="1"

• service network restart
• Edit the "network file":

# vi /etc/sysconfig/network
NETWORKING=yes

NOZEROCONF=yes

• Edit the "grub file"

# vi /etc/default/grub
GRUB_CMDLINE_LINUX="crashkernel=auto rd.lvm.lv=centos/root rd.lvm.lv=centos/swap console=tty0 console=ttyS0,115200"

• Activate the changes.

# grub2-mkconfig -o /boot/grub2/grub.cfg

How to converter the Virtual Machine to raw format?

Now. For to avoid the error:
[  124.947098] dracut-initqueue[258]: Warning: dracut-initqueue timeout - starting timeout scripts .
.
.
is very, very important add "dracut drivers" before to converter the image.

In the Virtual Machine CentOS 7 virtualized it Hyper-v, open a terminal an execute the next command:

# dracut --add-drivers "xen-blkfront xen-netfront" -force

• Shutdown the machine.




Execute the next command for to convert the vhdx file to raw format.

qemu-img convert -f vhdx C:\Users\PC\Documents\Machines\centos1\Virtual" "Hard" "Disks\centos1.vhdx -O raw C:\Users\PC\Documents\Machines\centos1\Virtual" "Hard" "Disks\centos1.img

• Now is necesary package the image created in tar format because is the format that Oracle IaaS accepted.

# tar -czvf centos1.raw.tar.gz centos1.img

Ready! Now upload the tar file to Oracle IaaS and you create an virtual Machine with the procedure mentioned here.

If you need to use private keys for authenticate execute the next commands before convert the vhdx file to raw format as mentioned here.

# yum install acpid
# systemctl enable acpid
# yum install cloud-init
# yum install cloud-utils-growpart

I hope will be useful for someone.
Regards!

Change ODI Supervisor Account

Sometimes, you have several boxes and environments, and make a lot of configurations and we don't really keep tracking of all actions done until certain point of time. When you need that password you realize that you don't have it.

In ODI there's a user SUPERVISOR, who controls the master configuration of the tool.

If you want to change it please do the following:

1.- Log in with the master repo user

2.- Execute the following statement:

update snp_user set pass='aYyH5kyea2TN2.YuxopAMy'  

where wuser_name = 'SUPERVISOR'

Where pass is the new encoded password, encoded with the ODI utility encode.sh

Location:

/product/111/odi_111/odi_111/oracledi/agent/bin/encoded.sh newpassword

sh encode.sh newPassword

aYyH5kyea2TN2.YuxopAMy

and once again!,  easy no?

Get the Admin account password in Weblogic Systems

Recently I had the entrust to get the admin account password of weblogic, so after a little bit searching in oracle documentation and web I used the following code:

The steps:

1.- Build script get_password.py

from weblogic.security.internal import *
from weblogic.security.internal.encryption import *
encryptionService = SerializedSystemIni.getEncryptionService(".")
clearOrEncryptService = ClearOrEncryptedService(encryptionService)

# Take encrypt password from user
pwd = raw_input("Paste encrypted password ({AES}fk9EK...): ")

# Delete unnecessary escape characters
preppwd = pwd.replace("\\", "")

# Display password
print "Decrypted string is: " + clearOrEncryptService.decrypt(preppwd)

2.- Set the environmental variables

sh $DOMAIN_HOME/bin/setDomainEnv.sh | source $DOMAIN_HOME/bin/setDomainEnv.sh

3.- Get the username and password

grep username $DOMAIN_HOME/servers/AdminServer/security/boot.properties | sed -e "s/^username=\(.*\)/\1/"
|
grep password $DOMAIN_HOME/servers/AdminServer/security/boot.properties | sed -e "s/^password=\(.*\)/\1/"

4.- cd $DOMAIN_HOME/security

java weblogic.WLST get_password.py


bash-3.2$ java weblogic.WLST get_password.py

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Paste encrypted password ({AES}fk9EK...): (OR USERNAME)

Decrypted string is: admin


Voilá!

Resources:
https://blogs.oracle.com

Update:

If your environment doesn't recognize your wlst command do the following:

 sh /$ENV/fmw/product/111/soa_111/common/bin/wlst.sh get_password.py

You must be located in $DOMAIN_HOME/security.