ITExperts4u Blog’s

##
## Using oidadmin
##

## startup oidadmin from the infrastructure-host
##

oidadmin

enter hostname: infrastructure-host.domainname.com
enter port: 389

enter username: orcladmin
enter password: <ISA_ADMIN_password_specified_during_install>

On the main screen to check Portal password:

Entry Management
cn=oracle context
cn=Products
=IAS
=IAS Infrastructure Databases
=SID
orclResourceName=PORTAL
orclpasswordattribute: GJx1ywdL (this will vary from install to install)

##
## Using ldapsearch from the command line
##

ldapsearch -h infrastructure-host.domainname.com -p 389 \
-D cn=orcladmin -w <ISA_ADMIN_password_specified_during_install> \
-b “cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext” \
-s sub “orclResourceName=PORTAL” orclpasswordattribute

REFERENCE:
Note:356333.1 Unable access Portal welcome page. Get “Servlet Error”
Note:344804.1 Accessing Portal Returns “Servlet Error” After a New Install of Portal 10.1.2.0.2
Note:198800.1 How to get the Portal schema password of the Infrastructure database

Sun JRE instead of Jinitiator with Forms and Webutil

Running Forms and Webutil with Sun Java 5.0.6 instead of Jinitiator.

And you know what: it’s faster and has more functionality I’ve been told…
First you need the java-file. In this case: jre15006.exe.

Initially I found it hard to find on the site of Sun – didn’t even know the name of the file I was looking for…
Found it at http://www.muangyacctv.com/download/JAVA but if you keep searching the Sun-website, you will find it here:

https://cds.sun.com/is-bin/INTERSHOP.enfinity/WFS/CDS-CDS_Developer-Site/en_US/-/USD/ViewProduct
Detail-Start?ProductRef=jre-1.5.0_06-oth-JPR@CDS-CDS_Developer

Then: where shall I put the file? The application server expects the file in /forms/jinitiator.
In forms.conf this is defined as:
AliasMatch ^/forms/jinitiator/(..*) “/software/oracle/middle/jinit/$1?

Next thing is the configuration in formsweb.cfg (at the end of this post is the configuration what worked for me,
but first some explanation, quoted from some notes):

# baseHTMLjinitiator
# Suppose the old [webutil] configuration in formsweb.cfg contains:
baseHTMLjinitiator=webutiljini.htm
# Change this in [sunwebutil] to:
baseHTMLjinitiator=webutiljpi.htm

# IE : Used to enable the browser’s default JRE
IE=native

# jpi_classid
# This parameter value is used by Microsoft Internet Explorer to determine if the desired plug-in is installed.
# The value is recorded in the Windows Registry during the JRE/JPI or Jinitiator installation.
# When the browser sees this ID number it looks in the Registry to determine if it exists.
# If the ID is not found, the browser assumes that the needed plug-in has not been installed.
# The exact value will differ depending on the JRE or Jinitiator version selected for use.
# The only exception is the Sun “dynamic

Solution for mount problems facing on AIX?
Facing Errors like below?

Have you ever tried mounting a shared folder existing on Solaris or Linux machine to a AIX machine ? While doing so most of us will see the below kind of error. So to solve this problem the solution is this post.

bash-3.00# mount pmgxs2v1:/dbarchive /dbarchive
mount: 1831-008 giving up on:
pmgxs2v1:/dbarchive
vmount: Operation not permitted.

Solution:
bash-3.00# nfso -o nfs_use_reserved_ports=1
Setting nfs_use_reserved_ports to 1
bash-3.00# mount -n pmgxs2v1 /dbarchive /dbarchive
bash-3.00# cd /dbarchive/
bash-3.00# ls
apache builds java oracle os stax unzipper
browsers instance lost+found oracle-bundles staf stax-tnpm

Explanation:
Solaris by default requires any NFS mount to use a so called reserved port below 1024 and AIX 4.3 or above does by default use ports above 1024.
We can use the nfso command to restrict AIX to the reserved port range as follows:
nfso -o nfs_use_reserved_ports=1

You can have multiple instances on the same machine, each with their own data files, either sharing the ORACLE_HOME or each with different ORACLE_HOME. ORACLE_HOME and ORACLE_SID are the key environment variables used by Oracle to identify an instance. In addition $ORACLE_HOME/bin must be in your PATH environment variable.

To check the value of these environment variables:

$ env |grep ORACLE
ORACLE_SID=pdb10i1
ORACLE_BASE=/u01/app
ORACLE_HOME=/u01/app/oracle/product/10.2.0

The “oraenv

Sequence to be followed for Starting and Stopping Oracle Application Server:-
The following steps hold true if the Mid and Infra tiers are on the same machine or on different machines, the sequence remains the same.

Steps to Stop Application Server:-
1) First Stop Middle Tier
Set MIDTIER_HOME to your middle tier home location
a) Goto $MIDTIER_HOME/bin/emctl stop iasconsole
b) $MIDTIER_HOME/opmn/bin/opmnctl stopall
2) Once the Mid Tier services are stopped, now stop Infra-Tier Services.
Set INFRATIER_HOME to your infra home location
a) $INFRATIER_HOME/bin/emctl stop iasconsole
b) $INFRATIER_HOME/opmn/bin/opmnctl stopall
3) Login to database
a) $INFRATIER_HOME/bin/ sqlplus / as sysdba
b)Issue the command ” shut immediate” to shut down the database
c) $INFRATIER_HOME/bin lsnrctl stop
d) $INFRATIER_HOME/bin/emctl stop dbconsole

Steps to Start Application Server:-

Follow the Above Steps in reverse order:-
1) First Start Infra Tier
Set Infratier_home to your Infra tier home locaiton
a)$INFRATIER_HOME/bin/lsnrctl start
b)$INFRATIER_HOME/bin/ sqlplus / as sysdba
c) Once logged in Issue the command ” startup” to startup the database
d) $INFRATIER_HOME/bin/emctl start dbconsole

2) Now issue the following commands,
a) $INFRATIER_HOME/opmn/bin/opmnctl startall
b) $INFRATIER_HOME/bin/emctl start iasconsole

3) Once the Infra tier is up now start the Mid Tier
Set MIDTIER_HOME to your mid home location
a) INFRATIER_HOME/opmn/bin/opmnctl startall
b) INFRATIER_HOME/bin/emctl start iasconsole

I was trying to open the outlook i was getting the error “Cannot start Microsoft Office Outlook. Cannot open the Outlook window.”

Then I had searched on the google, I foud the article and it worked for me.

Start->run..then type the following -> “Outlook.exe /resetnavpane”

I was excited to see the feature of Epic browser. It is marvelous. You can download it from http://www.epicbrowser.com/

Oracle 11i Applications Working on IE8, Firefox 3.5 & VISTA and Windows 7

What you need to do is below and please follow the exact steps for this to work. I got this to work on latest Firefox 3.5 and IE8 and that too on VISTA. It also works on the current Windows 7 RTM both Firefox and IE8. When you upgrade to Windows 7 from VISTA using the upgrade process, it migrates all programs etc so it worked for me on Windows 7 as well, no issues.
1. Install JInitiator version “1.3.1.21″. I can give provide the executable if needed.
2. Make sure that your Java Version is “1.5.0 (build 1.5.0_13-b05)”. I have not tried the latest version. I can probably provide the oajse2.exe.
3. In Firefox change the following Settings (Uncheck Enable Java)
4. In IE8 Tools -> Options -> Advanced -> “Enable third-party browser extensions” (UNCHECK)
5. Replace the JVM.DLL in “JInitiator 1.3.1.21\bin\hotspot” directory with the JVM.DLL in “Java\jre1.5.0_13\bin\client”.
6. Restart both Firefox and IE8.
7. The 11i Apps work via the regular login as well as “dev60cgi/f60cgi” URL.
8. I have uploaded both Java JRE and Jinitiator on Rapidshare. Below are the links
9. One more thing to note. I was also able to work with both 11.5.10 and 12.1.1 with IE8. All you need is to install the latest oajse and make sure that under Security options, change the mode to CUSTOM and DISABLE “Enable XSS Filter” option.
Java JRE – http://rapidshare.com/files/278239402/oaj2se.exe
Jinitiator – http://rapidshare.com/files/278241098/oajinit.exe

If you’re running an Oracle Application Server 10g instance you are probably familiar with Oracle Enterprise Manager Application Server Control. If not, go back to the manual. This is not a how-to on setting it up or using it. If you want to know how to secure it and refresh the certificate when it expires, read on.

Application Server Control is installed with Application Server 10g and typically runs on a port like 1810. By default it uses the non-secure http protocol. Since your whole application server is controlled through this interface, you probably want to secure it. The instructions below will generate a self signed certificate and get your Application Server Control up and running with https.

As usual this post is written for Oracle Application Server 10g on UNIX. Always review the documentation for your release before trying any of these steps.

Securing Application Server Control

Oracle has provided a simple way to secure Application Server Control.

Note: If $ORACLE_HOME/bin is not in your path you will need to provide this path to emctl.

1. Connect to the command line on the application server and set all the appropriate environment variables for your application instance.

2. Run the command emctl stop iasconsole to stop Application Server Control.

3. Run the command emctl secure em to secure Application Server control. This will perform a few steps including generating a self-signed secure certificate.

4. Run emctl start iasconsole to start Application Server Control.

If all goes well you will now be able to connect to your Application Server Control instance on the same port as before but now with the https protocol. In most browsers you will need to specify