https://localhost:1158/em untrusted connection in firefox

As salamo alaikum wa rahmatullah,

When I try to connect with Firefox after installing the Oracle 11g in my laptop, firefox generated exception for untrusted connection, Hereunder is solution is solution,

Please follow up the steps

Archive for the ‘localhost:1158 uses an invalid security certificate’ tag

Untrusted Oracle Enterprise Manager and Firefox 3

 While installing a VM of Windows XP and Oracle 11g, I found that Firefox 3.0 doesn’t trust the Oracle Enterprise Manager certificate.
This is the alert box you get after the install at http://localhost:1158/em:

You can grant a security exception to the browswer. Here are the steps:
1. Dismiss the dialog box, then click the hyperlink “Or you can add an exception…” in the web page.

2. Click the “Add Exception …:” button.

3. Click the “Get Certificate …” button.

4. Confirm the “Create Security Exception” button.

You’re done. So was I, a bit annoying really … a lot like Microsoft Vista – allow or deny.

Hope it helps you guys.

Thanks and Regards
Mohammad Shahanwaz
oracle’s passion



Oracle Apps Installation Question

As salamo alaikum wa rahmatullah,
There are following questions which are asked from oracle apps installation. For the installation it is good.

What is the minimum disk space requirement for installing Oracle Applications?
ans)The approximate file size in a single-node installation are:
-> Application tier file system – 26GB (including iAS/8.0.6 ORACLE_HOME COMMON_TOP and APPL_TOP)
-> Database tier file system (fresh install with a production database) -31 GB
-> Database tier file system (fresh install with a Version Demo database) – 65 GB
-> Total space for single node system, not including stage area, is 57

GB for a fresh install with production database, and 91 GB for fresh install with a Version Demo database.

How much STAGE area is required for RapidInstall?
ans)To run RapidInstall from a stage area, you need at least 24 GB to accommodate the files.

How much space an additional language needs?
ans) To install an additional language, it needs approximately around 10 GB space.

Di i need to install any other software before starting the RapidInstall?
ans)Befoer installing Oracle Applications, the JDK needs to be installed. The version of JDK which needs to be installed depends on which version of Oracle Applications yuo want to install. The latest 11.5.0 release of Oracle Applications need JDK1.4.2. Apart from JDK, you must have perl 5.0053 installed and which should be there in your PATH.

Can I start the RapidInstall with any user?
ans)RapidInstall needs to b started only with the root user. It can also be started with any other user as well, but that is not recommended as you have two different users – one for database and other for application file system.

How many operating system users I need for installing Oracle Application?
ans)Oracle recommends that you should have two Unix users for Installing Oracle Application – One Oracle user (oracle) who owns the file system of the database and one application (applmgr) user who owns the application file system.

What are the individual disks included in the release 11i Software boundle?
ans)The 11.5.10 software comes in DVD format. The individual disks included in the Release 11i software bundle are labeled as follows:
-> Start Here – Disk1
-> APPL_TOP – Disk n
-> Tools – Disk n
-> Database – Disk n

Is the NLS software included with the RapidInstallDVD bundle?
ans)No, the NLS software is not included with the RapidInstall bundle. You need to order the NLS supplement software separately for each additional language which you want to install along with Oracle

How do i create the stage area of the RapidInstall?
ans)For creating a stage area, the script needs to be run as follows:
$cd /mn/cdrom/Disk1/rapidwiz

How many directories are there in the stage area of Oracle Application?
ans)The following Six directoruis are there in the stage area of  Oracle Applications.
-> StartCD
-> oraApps
-> oraDB
-> oraiAS
-> oraAppDB
-> oraNLS (Optional only if you have a NLS Software)

What pre-install checks should I make to ensure a successful installation?
ans) -> Verify the correct users and groups have been created, as documented in installing Oracle Applications.
-> Verify the required disk space is available, as documented in installing Oracle Applications.
-> Verify the file system base install directories have write access granted to the user that will own the software (on UNIX the RapidInstall Wizard may be run as root but the install runs as the user that will on the software, therefore this user must have write access to the base install directories).
-> Verify the required ports are available for the installation.
-> Verify system parameters are sufficient for the Oracle Software (especially the database) to run.
-> Verify that all the OS patches have been applied as per Oracle documentation.

What is a Single node installation?
ans)Single node installation is the one in which all the servers (Concurrent Processing,Forms,Web,Reports), the database and all product directories are installed on a single node. In other words, in single node installation the entire Oracle Applications are installed on a single server.

Where is a single node installation generally used?
ans) The single node installation is generally used for smaller installations and also used for demonstration purpose.

What is an express configuration?
ans)Express configuration installs a fully configured single node system with either a fresh database or Vision Demo database. Only a few basic parameters such as database name, top level install directories and port settings needs to be specified in this and express configuration take care of installing Oracle Applications
without any user intervention.

What is configuration file and why is it used?
ans)During installation RapidInstall asks many questions from the user. It saves all the configuration parameters you enter in a new configuration file (config.txt) which is uses to configure the system for the new installation. In case the installation fails the same configuration file can be used for restarting the installation without answering all the question again from the scratch. For multi-node installation, the configuration file is used for the installation in other nodes.

I have started RapidInstall but nothing is coming in the screen.What could be the reason?
ans)The display might not be set properly.Set the display and start RapidInstall again.

What is a multi-node installation?
ans)A multi node installation is the one in which the database tier and the application tier are installed across two or more nodes.

In a multi-node installation how do i find what services are running from which node?
ans)The context file sid_hostname.xml in $APPL_TOP/admin will have the  information about the same. It can also be requeired from the table FND_NODES. You can query the following columns SUPPORT_CP for concurrent manager, SUPPORT_FORMS for froms server, SUPPORT_WEB for the apache host and SUPPORT_ADMIN to know the admin tier.

What benefits do i get with multi-node installations?
ans)Multi-node installation distributes teh server process across different servers. For example, in a typical example of multiple node, the database is hosted in one physical server the apache is hosted from some other server, the forms are hosted in other server, the current manager and reports server is hosted from one other server. This helps in distributing the load across various servers and as a result the overall performance of the application system increases.

In case of multi-node installation i will have multiple APPL_TOP’s. How will manage all the different APPL_TOP’s?
ans)In earlier releases of the Oracle Application, this problem was there. In case of patching, patching needs to be done from all the different nodes of the APPL_TOP. But with the introduction of the concept of shared APPL_TOP, this problem has been resolved.

What is Shared APPL_TOP and how does it help in case of multi-node installation?
ans)In case of multi-node installation, various components of the middle tiers are hosted across different physical servers. Shared APPL_TOP means the APPL_TOP will be installed only in one of the physical servers and all other servers of the application will share the file system of the APPL_TOP. Any changes made in the shared APPL_TOP file system are immediately visible on all nodes.This helps a lot in managing the application system.In case of patching, it needs to be done only once as all the servers share the same APPL_TOP. With 11.5.10 release, RapidInstall creates a shared APPL_TOP by default for multi-node installation.

What is shared application tier file system?
ans)In a shared application tier file system installation, the APPL_TOP, the COMMON_TOP, and the applications technology stack (ORACLE_HOME) are installed on a shared disk resource mounted to each
node in the system. These nodes can be used to provide standard application tier services, such as forms, Web and concurrent processing. Any changes made in the shared application tier file system are immediately visible on all nodes.

What operating systems can use the shared APPL_TOP?
ans)All RapidInstall platforms except Windows support a shared application tier infrastructure.

Can i shared the APPL_TOP across different platforms of operating system?
ans)No, sharing of the APPL_TOP is not possible across different platforms because the binaries and libraries of the application file system are platform specific.

As of now i am using two different APPL_TOP. Can i merge the existing APPL_TOP to go for the shared APPL_TOP model?
ans)Yes, you can merge APPL_TOPs which are spread across different nodes. The metalink docuemt 233428.1. mentions in details about doing the same.

Thanking you

Mohammad Shahnawaz
Oracle’s Passion

How to find Apps OUI version in EBS

As salamo alaikum wa rahamatullah,

We can find the version of the Oracle Universal Installer through the following,
Navigate to $IAS_ORACLE_HOME/appsoui/oui,
It will display a file named oraparam.ini and the contents will be look like the following,
JRE_LOCATION=../jre/1.3.1/jre OUI_LOCATION=.
In the above at last we will be able to locate the version of the Oracle Universal Installer from the parameter OUI_VERSION.
In the above case the version is

Mohammad Shahnawaz
Oracle’s Passion

Lock and Unlock the User


This post will describe how to [lock] and [unlock] the user in oracle database.

command to lock and unlock the user in oracle below

there are two type of scenario which has been described here under,

1. Existing User 
2. New User

If suppose you have [HR] user which has to be unlocked, then you follow this step, because it is already in your database but while creating database user did not enable it, means it is not unlocked. Now he/she needs to unlock the [HR] user.

oracle@localhost~]$sqlplus /NOLOG
sql>show user

probably it will show the “sys” user. Now connect with [System] user, because it has DBA rights.
Sql>connect system/manager@orcl 
[here my system user password is manager and orcl is connection string]
if you do not have the connection string then, user normal connect like as follows.

Sql>connect system/manager

Sql>show user 

Now write the command to unlock the [HR] user.

Sql> alter user HR account unlock;
user altered.

if suppose you want to change the password of HR while unlocking the user then use this command.

Sql>alter user HR identified by HR123 account unlock.
user altered

For new user follow the following step.
your supervisor told you to create an user with the name “OraEmp113” and password is “emp” and initially status should be locked.

oracle@localhost~]sqlplus /as sysdba
Sql> show user
probable it show the [SYS] user.
now you connect with the [System] user .
Sql>connect System/manager
Sql> show user

Now create a user here with given name
command to create user is here under,

create user <usrename> identified by <password> account lock|unlock;

Sql>create user OraEmp113 identified by emp account lock;
user created.
grant this user connect and resource here.
Sql>Grant connect,resource to OraEmp113

now unlock the user.

Sql>Alter user OraEmp113 account unlock;
user altered.

Thanking you

Mohammad Shahnawaz

Logical Export Data

Exporting table from scott user and Table is “Emp”
— crate a directory named export into the /home directory
Oracle@localhost]$mkdir /home/export
— give the permission of oracle and group is oinstall with change mode all.
oracle@localhost]$chown -R oracle:oinstall /home/*
oracle@localhost]$chmod 777 /home/*
oracle@localhost]$ exp USERID=scott/tiger FILE=scott_exp.dmp LOG=scott_log.log FULL=y TABLES=emp BUFFER=4096
 it has been on prompt, if you want to write it into the shell script file then you made a script file named with “”.

Here is step to create a file into the export/script directory and made a file “” here under.

oracle@localhost]cd export
oracle@export]$ mkdir script
oracle@export]$ cd script
oralce@script]$ pwd
exp USERID=scott/tiger
:wq [for saving the file of vi editor press esc then :wq] 
oralce@script]sh &

thanking you

Mohammad Shahnawaz
Oracle Apps DBA