Thursday, April 23, 2009

Oracle XE change HTTP and FTP Port

Login on SQL*Plus with the system user:


SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 23 11:40:05 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn system/[PASSWORD]
Connected.
SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8080 0

SQL> begin
2 dbms_xdb.sethttpport('8585');
3 end;
4 /

PL/SQL procedure successfully completed.

SQL> select dbms_xdb.gethttpport as "HTTP-Port"
, dbms_xdb.getftpport as "FTP-Port" from dual;

HTTP-Port FTP-Port
---------- ----------
8585 0


Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Install java SDK on linux

Download the bin file from the java website:
http://java.sun.com/products/archive/

Install the package as root:

su - root

Change the execute rights:

chmod 700 jdk_*.bin

Execute the bin:

./jdk_*.bin

Java will be installed in /usr/java/

export JAVA_HOME=/usr/java/jdk...
export PATH=$JAVA_HOME/bin:$PATH

Now you can check if everthing is ok by:
which java
java -version

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Wednesday, April 22, 2009

ORA-39165: Schema TMP was not found and ORA-31655: no data or metadata objects selected for job

These errors can occur if the user exists and owns objects but when there are no records in any of the tables.

Error:

expdp system/[PASSWORD]@[ORACLE_SID] directory=[EXPORT_DIR] logfile=[LOG_FILE].log content=DATA_ONLY dumpfile=[DUMP_FILE].dmp schemas=[TMP]

Export: Release 11.1.0.6.0 - Production on Wednesday, 22 April, 2009 16:26:37

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Release 11.1.0.6.0 - Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@[ORACLE_SID] directory=[EXPORT_DIR] logfile=[LOG_FILE].log content=DATA_ONLY dumpfile=[DUMP_FILE].dmp schemas=[TMP]
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
ORA-39165: Schema [TMP] was not found.
ORA-31655: no data or metadata objects selected for job
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" completed with 2 error(s) at 16:26:41


Solution:
Remove the DATA_ONLY option, only the METADATA will be exported!!

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Monday, April 20, 2009

Manual installation ultrasearch in Oracle database

Manual installation of database component ultrasearch in an Oracle database:

set echo on
spool ultrasearch.log
@$ORACLE_HOME/ultrasearch/admin/wk0setup.sql [ORACLE_HOME] "" SYS [PASSWORD SYS] "as sysdba" wksys SYSAUX TEMP "" "FALSE" DATABASE "" [ORACLE_HOME]/jdbc/lib/classes12.zip [ORACLE_HOME]/jlib/orai18n.jar [ORACLE_HOME]/jdk/bin/java /appl/oracle/db_10.2.0.4.0/ctx/bin/ctxhx [DB_HOSTNAME]:[DB_PORT]:[DB_SID] [DB_HOSTNAME]:[DB_PORT]:[DB_SID] [ORACLE_HOME]
spool off
exit


Check if the option is installed:

select comp_name, version, status from dba_registry
where COMP_ID='WK';


Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Register database by listener

When you want to register an database to an listener you can do this like this:


sqlplus / as sysdba
alter system register


Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Thursday, April 16, 2009

Redhat Linux IP configuration eth0

Find the file ifcfg-eth0 normally in the directory /etc/sysconfig/network-scripts/

If an static ip address is used it should look something like:


DEVICE=eth0
BOOTPROTO=none
ONBOOT=yes
NETWORK=10.0.1.0
NETMASK=255.255.255.0
IPADDR=10.0.1.27
USERCTL=no


When DHCP is used it should look like:

DEVICE=eth0
BOOTPROTO=dhcp
ONBOOT=yes


After the ifcfg-eth0 file is changed the network must be restarted this can be done with the following command:

service network restart

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Share host folders on Virtual Linux machine

In VMWare Workstation select the properties of the Virtual Machine and click on options. You can see an Shared Folders property. Enable this option and choose a folder on your host which you want to share.

VMWare tools need to be installed for this feature.

Now restart your virtual machine.

When the virtual machine is started you can access the shared folder in the directory /mnt/hgfs/[NAME OF THE SHARE]

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Split vmware files (vmdk) files in smaller chunks

There is an application availible that makes it possible to split up files VMware vmdk files in smaller parts (this is part of vmware workstation vmware-diskmanager.exe). There is also een gui build for this: the application can be found on:

http://vmxbuilder.com/vmware-diskmanager-gui

If you want to change the name of the master vmdk file than you also need to change the vmx file. (Do not forget to copy the vmx file to the directory where the split up files are placed).

Change the entry:
scsi0:0.fileName = "NEW NAME.vmdk"

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Install VMWare tools on a linux VM

First you select the option VM > Install VMWare Tools... in VMWare workstation. Than an virtual CD is mounted in your Virtual linux machine (/media/VMware_Tools). If this does not happen you should mount the cdrom manually: mount /media/cdrom. This can give an failure but this is error can be ignored.

execute the rpm file:

rpm -ivh VMwareTools-*.rpm


After the rpm is installed the configure perl script can be executed:

cd /usr/bin/
./vmware-config-tools.pl


Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Tuesday, April 14, 2009

Install Oracle XE on Linux and configure database XE

Download the rpm from the Oracle Website:
http://www.oracle.com/technology/software/products/database/xe/htdocs/102xelinsoft.html

Execute the RPM

rpm -ihv oracle-xe-univ-10.2.0.1-1.0.i386.rpm


Configure the database

su - root
cd /etc/init.d
./oracle-xe configure


Refer:
http://www.oracle.com/technology/software/products/database/xe/files/install.102/b25144/toc.htm

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Friday, April 10, 2009

Documentation, Netpoint/Oblix/CoreId/Oracle Access Manager

Documentation Library Oracle Access Manager:
http://download-uk.oracle.com/docs/cd/B28196_01/index.htm

Oracle® Application Server Best Practices Guide
http://download-uk.oracle.com/docs/cd/B28196_01/core.1014/b31762/accessmgr.htm

Oracle® Access Manager Access Administration Guide
http://download-uk.oracle.com/docs/cd/B28196_01/idmanage.1014/b25990/v2config.htm#BHADBAGE

Did this post help you in any way can you please leave a comment? This will motivate me writing more posts.

Thursday, April 9, 2009

Integration BPEL / OID 10.1.4 Migration of LDIF data failed. Not all the entries are successfully

In the document: http://download-uk.oracle.com/docs/cd/B31017_01/integrate.1013/b28982/service_config.htm#BABIBGFF is mentioned how the integration between BPEL and OID can be configured. But when this is done with OID version 10.1.4 some problems occur:

Migration of LDIF data failed. Not all the entries are successfully.
If the script configure_oid.sh is executed like this:

(Pay attention on a production system choose the option seedRequiredUsers instead of SeedAllUsers, otherwise all test users are in the OID)


cd $ORACLE_HOME/bpel/system/services/install/ant-tasks
./configure_oid.sh orcladmin <PASSWORD> 389 false us seedRequiredUsers oc4jadmin <PASSWORD> oc4j_soa
Buildfile: oid-config.xml

config-oid:
[echo] Configuring OID...
[mkdir] Created dir: $ORACLE_HOME/ldap/install
[java] Install Configuration
[java] Install Type: ConfigureOID
[java] Oracle Home: $ORACLE_HOME
[java] JDK Home: $ORACLE_HOME/jdk
[java] Proxy Required: false
[java] Database Vendor: oracle
[java] OID Host: ${oid.host}
[java] OID Port: 389
[java] OID Realm: us
[java] OID Seed: seedRequiredUsers
[java] Admin User: orcladmin

[java] ***************************************************************
[java] Trying to obtain OID specific details from configuration files.
[java] Warning: You would encounter problems if you have not associated your instance with an OID.
[java] ***************************************************************
[java] OID Host is: ldap.test.nl
[java] OID Port is: 389
[java] Seeding users/roles in OID realm : us...
[java] Buildfile: bpminstall.xml

[java] seed-oid:

[java] init:

[java] seed-oid:
[java] Seeding system users/roles into OID ...
[java] Migration of LDIF data failed. Not all the entries are successfully migrated
[java] Seeding demo users/roles into OID ...
[java] Migration of LDIF data failed. Not all the entries are successfully migrated

[java] BUILD SUCCESSFUL
[java] Total time: 5 seconds
[java] Exit: 0
[java] Configuring BPEL identity service configuration file ...
[java] Adding jaas-mode attribute to hw_services orion-application.xml
[java] Adding jaas-mode attribute to orabpel orion-application.xml

bpel-grant-privileges:
[echo] Granting Server privileges to BPMSystemAdmin role...
[echo] Granting Domain privileges to BPMDefaultDomainAdmin role...

all:

BUILD SUCCESSFUL
Total time: 11 seconds
Done


After some investigation I noticed that the ldif script that is inserted in the OID is in the directory: $ORACLE_HOME/bpel/system/services/config/ldap.

Then I tried to insert the users with the ldapadd commando an error occured:

ldapadd -h ldap.test.nl -p 389 -D cn=orcladmin -w <PASSWORD> -f system-oid_xxx.ldif
adding new entry cn=bpeladmin,cn=users, dc=us,dc=test,dc=nl
ldap_add: Constraint violation
ldap_add: additional info: Password Policy Error :9004: GSL_PWDNUMERIC_EXCP :Your Password must contain at least 1 numeric characters.


The conclusion is that there is een password policy in the OID, when this policy is changed the ldapadd works like a charm.

Change the policy in the OID:
start oidadmin > login with orcladmin > Password Policy Management > cn=pwdPolicies, cn=Common, cn=Product, cn=OracleContext > Password Policy for Realm dc=us,dc=test,dc=nl > tab Password Syntax

Change Number of Numeric Characters: 0



or you can change all passwords in the *.ldif file. But then the ant script is not working only because the ldif file is generated during the ant script.

The ldapadd command is working after the change in de oid and also when the passwords are changed:


ldapadd -h ldap.test.nl -p 389 -D cn=orcladmin -w <PASSWORD> -f system-oid_xxxx.ldif
adding new entry cn=bpeladmin,cn=users, dc=us,dc=test,dc=nl
adding new entry cn=default,cn=users, dc=us,dc=test,dc=nl
adding new entry cn=guest,cn=users, dc=us,dc=test,dc=nl
modifying entry cn=BPMSystemAdmin,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMDefaultDomainAdmin,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMWorkflowAdmin,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMWorkflowReassign,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMWorkflowSuspend,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMWorkflowViewHistory,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=rule-administrators,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMAnalyst,cn=Groups, dc=us,dc=test,dc=nl
modifying entry cn=BPMPublic,cn=Groups, dc=us,dc=test,dc=nl


Now also the configure_oid.sh works like it supposed to. But when you use this script you must change all passwords because default the passwords are CHANGE_ME. The passwords are defined in the file: $ORACLE_HOME/bpel/system/services/config/ldap/system-oid.sbs.

You can verifiy everything is working fine by invoking the BPEL identity service:
http://<hostname>:<port>/integration/services/IdentityService/identity?operation=lookupUser

If the execution of this request results in this error:


Identity Service cannot find user. Error occurs while getting user "[USER]" in realm "jazn.com" Verify that user "[USER]" exits in realm "jazn.com". Contact oracle support if error is not fixable.


Adjust the file $ORACLE_HOME/j2ee/oc4j_soa/config/jazn.xml.


Line : provider="XML" location="./system-jazn-data.xml" default-realm="jazn.com"


Line :

provider="LDAP" location="ldap://test.nl:389" default-realm="us"


Change the $ORACLE_HOME/j2ee/oc4j_soa/config/jazn.xml the same as $ORACLE_HOME/j2ee/home/config/jazn.xml


There is another problem in the integration of BPEL and OID.
Hint : LOGON TO THE BPEL ADMIN CONSOLE FAILS - INSUFFICIENT PRIVILEGES / NO DOMAIN

There are two OC4J homes in the environment ($ORACLE_HOME/j2ee/home and $ORACLE_HOME/j2ee/oc4j_soa).
OC4J instance is associated with OID through EM.

This modifies the $ORACLE_HOME/j2ee/home/config/jazn.xml. However, it does not modify the $ORACLE_HOME/j2ee/oc4j_soa/config/jazn.xml file correctly.

$ORACLE_HOME/j2ee/oc4j_soa/config/jazn.xml


Line : provider="XML" location="./system-jazn-data.xml" default-realm="jazn.com"


Line :

provider="LDAP" location="ldap://test.nl:389" default-realm="us"


Change the $ORACLE_HOME/j2ee/oc4j_soa/config/jazn.xml the same as $ORACLE_HOME/j2ee/home/config/jazn.xml

Refers:
http://download-uk.oracle.com/docs/cd/B31017_01/integrate.1013/b28982/service_config.htm#BABIBGFF

Oracle HTTP Server on port under 1024 on Linux

Execute the following commands as the root user


cd $ORACLE_HOME/Apache/Apache/bin/

chown root .apachectl
chmod 6750 .apachectl


Pay attention to the dots in front of the apachectl!!!!!!!!!!!!!!!!!

Tuesday, April 7, 2009

"Address already in use: make_sock: could not bind to address 127.0.0.1 port 7200", Netpoint/Oblix/CoreId/Oracle Access Manager

When in the error log of the HTTP_Server ($ORACLE_HOME/Apache/Apache/logs/error_log.xxxxx) this error occures:


[Thu Mar 12 16:16:18 2009] [crit] (98)Address already in use: make_sock: could not bind to address 127.0.0.1 port 7200


Some processes of the HTTP_Server are still running and need to be killed.

"*** glibc detected *** realloc(): invalid size: 0x081a61f8 ***", Netpoint/Oblix/CoreId/Oracle Access Manager

After the installation of the Access Server component of Oracle Access Manager the HTTP_Server needs to be restarted.

It is possible that the following error occures:

[Mon Feb 16 14:42:44 2009] [warn] pid file $ORACLE_HOME/Apache/Apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
*** glibc detected *** realloc(): invalid size: 0x081a61f8 ***


This can be solved by changing the httpd.conf file:
exclude two modules:


#LoadModule perl_module libexec/libperl.so
#LoadModule php4_module libexec/libphp4.so

Invalid Credentials Error OAM After Applying 10.1.4.3 Patchset to OID

After applying patchset 10.1.4.3 to the OID, Login to Oracle Access Manager (OAM) access server/identity server/ policy manager fails with invalid credentials.

Applying OID 10.1.4.3 patchset modifies the OID attribute orclinmemfiltprocess. The new value is not correct and causes the described problem.

Execute the following query in the OID

For OID 10.1.4.3


$ORACLE_HOME/bin/ldapmodify –h <OID_HOST> -p <OID_PORT> –D cn=orcladmin –w <PASSWORD> -v <EOF
dn: cn=dsaconfig,cn=configsets,cn=oracle internet directory
changetype: modify
replace: orclinmemfiltprocess
orclinmemfiltprocess:(|(!(obuseraccountcontrol=*))(obuseraccountcontrol=activated))
orclinmemfiltprocess:(|(obuseraccountcontrol=activated)(!(obuseraccountcontrol=*)))
orclinmemfiltprocess:(obapp=groupservcenter)(!(obdynamicparticipantsset=*))
orclinmemfiltprocess:(objectclass=oblixworkflowinstance)
orclinmemfiltprocess:(objectclass=inetorgperson)
orclinmemfiltprocess:(objectclass=oblixorgperson)
orclinmemfiltprocess:(objectclass=oblixworkflowstepinstance)
EOF


Refers: metalink note: 558040.1

Migration has failed. Please try to manually run the migration program by invoking

Error during text based Installation of the Dutch Language Pack for Identity server on RedHat Linux

./Oracle_Access_Manager10_1_4_0_1_NL_linux_LP_Identity_System

Migrating language...


Migration has failed. Please try to manually run the migration program by
invoking
$ORACLE_ACCESS_MANAGER/identity/oblix/tools/migration_tools/start_obmigratenp
-c LP -f ERROR: could not read property fromMigrationVersion for bean
dsInfoInputbecause the following error occurred:
java.lang.NullPointerExceptionERROR: could not read property
fromFirstMinorVersion for bean dsInfoInputbecause the following error occurred:
java.lang.NullPointerException -t 1014 -s "ERROR: could not read property
destination for bean backupOblixDirBeanbecause the following error occurred:
java.lang.NullPointerException" -d "/appl/oracle/ident_10.1.4/identity" -i
"$ORACLE_ACCESS_MANAGER/identity".


Made an SR by Oracle Support and the solution to this problem is starting the installation with the -gui option.

Monday, April 6, 2009

Form-Based Authentication Single Sign On for Oracle SOA suite 10.1.3.x ESB console, Netpoint/Oblix/CoreId/Oracle Access Manager

1. Configure ESB console with OAM

see my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application)

All the files that need to be changed are located in $ORACLE_HOME/j2ee/oc4j_soa/*

1.1 system-jazn-config.xml
Change the system-jazn-config.xml see Chapter 3.5 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application

The application name should be: esb

1.2 orion-application.xml
Change the orion-application.xml files in both directories: (applications and application-deployments) see Chapter 3.3 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

Replace this code:

<jazn provider="XML" location="../../config/system-jazn-data.xml" default-realm="jazn.com" jaas-mode="doAsPrivileged" />


By this code:


<jazn provider="XML" default-realm="jazn.com" jaas-mode="doAsPrivileged">
<jazn-web-app auth-method="COREIDSSO"/>
</jazn>


1.3 web.xml
Change the web.xml see Chapter 3.1 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

Location:
/appl/oracle/soa_10.1.3/j2ee/oc4j_soa/applications/esb-dt/esb_console/WEB-INF

In the web.xml the following code must be replaced:


<login-config>
<auth-method>FORM</auth-method>
<form-login-config>
<form-login-page>/login.jsp</form-login-page>
<form-error-page>/login_error.jsp</form-error-page>
</form-login-config>
</login-config>


Replace by:


<login-config>
<realm-name>ascontrol</realm-name>
</login-config>


1.4 opmn.xml
Change the opmn.xml see Chapter 2.1 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

1.5 Policy Domain
Configure a policy domain for /em see Chapter 3.4 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

The only difference is that /esb needs to be protected instead of: /callerInfo/callerInfoB

Form-Based Authentication Single Sign On for Oracle SOA suite 10.1.3.x asconsole, Netpoint/Oblix/CoreId/Oracle Access Manager

I will explain how SSO / OAM / Oracle SOA suite 10.1.3 asconsole can be configured.

1. Configure asconsole with OAM /em
First I will configure the asconsole, this is very easy. Before you can start configuring you need to create the user and groups in the OID this can be achieved with a trick.

1.1 Add User and Groups in the OID
Log in on the asconsole of the SOA suite with the oc4jadmin user:

http://hostname:port/em
Click on the home container > tab Administration > Identity Management

Fill in the OID settings of your OID, then automaticly the users and groups are added to the OID.

After this it is easy (see my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application)

All the files that need to be changed are located in the directory: $ORACLE_HOME/j2ee/home/*

1.2 system-jazn-config.xml
Change the system-jazn-config.xml see Chapter 3.5 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application

The application name should be: asconsole

1.3 orion-application.xml
Change the orion-application.xml files in both directories: (applications and application-deployments) see Chapter 3.3 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

Replace this code:


<!-- %BEGINGOVERNSSO%

<jazn provider="XML">
<jazn-web-app auth-method="CUSTOM_AUTH"/>
</jazn>

%ENDGOVERNSSO% -->


By the following code:


<jazn provider="XML" default-realm="jazn.com" jaas-mode="doAsPrivileged">
<jazn-web-app auth-method="COREIDSSO"/>
</jazn>


1.3 web.xml
Change the web.xml see Chapter 3.1 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

In the web.xml the following code must be replaced:


<login-config>
<auth-method>FORM</auth-method>
<realm-name>ascontrol</realm-name>
<form-login-config>
<form-login-page>/console/logon</form-login-page>
<form-error-page>/logon_failed.html</form-error-page>
</form-login-config>
</login-config>


Replace by:


<login-config>
<realm-name>ascontrol</realm-name>
<auth-method>BASIC</auth-method>
</login-config>


1.4 opmn.xml
Change the opmn.xml see Chapter 2.1 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

1.5 Policy Domain
Configure a policy domain for /em see Chapter 3.4 of my post CoreId/Oracle Access Manager Form-Based Authentication for J2EE application.

The only difference is that /em needs to be protected instead of: /callerInfo/callerInfoB

Friday, April 3, 2009

Invoking ESB Service From BPEL Fails With Error "exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException"

When the ESB service is called in an BPEL process and the next error occurs (Oracle ESB 10.1.3.x):

Invoking ESB Service From BPEL Fails With Error "exception on JaxRpc invoke: HTTP transport error: javax.xml.soap.SOAPException"

Metalink note: 427452.1

There are two options to resolve this issue:

Option 1: Configure the virtualhost and port number for a particular ESB system where services got registered.

1. Click the ESB system then configure Virtual host and Port number,
Set Virtual host to ESB Runtime Server's hostname
Set Port to ESB Runtime Server's http listening port
2. Apply the change

Option 2: Use ESB bindings to invoke ESB services.
1. Login to ESB console, and click the Routing Service which BPEL is attempting to invoke.
2. Go to "Definition" tab, and uncheck "Can be invoked from an external service"
3. Click apply.
4. Go to BPEL Console and clear the WSDL Cache.
5. Restart SOA suite