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,
DISTRIBUTION=FALSE
SOURCE=
LICENSE_LOCATION=
JRE_LOCATION=../jre/1.3.1/jre OUI_LOCATION=.
DEFAULT_HOME_LOCATION=
DEFAULT_HOME_NAME=
NLS_ENABLED=TRUE
JRE_MEMORY_OPTIONS=” -mx48m”
NO_BROWSE=/net
BOOTSTRAP=FALSE 
OUI_VERSION=2.2.0.19.0
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 2.2.0.19.0.

regards
Mohammad Shahnawaz
Oracle’s Passion
Kuwait

Advertisements

Lock and Unlock the User

Hi,

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 
connected.
[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
connected.

Sql>show user 
system

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
connected.
Sql> show user
System.


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
Granted.

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”
oracle@localhost]$pwd
/home 
— 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 “exp_table.sh”.

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

oracle@localhost]$pwd
/home
oracle@localhost]cd export
oracle@export]$ mkdir script
oracle@export]$ cd script
oralce@script]$ pwd
/home/export/scirpt
oracle@script]vi exp_table.sh
exp USERID=scott/tiger
FILE=exp_table.dmp
FULL=y
LOG=exp_table_log.log
TABLES=emp
IGNORE=y
BUFFER=y
GRANT=y
CONSTRAINTS=y
:wq [for saving the file of vi editor press esc then :wq] 
oralce@script]sh exp_table.sh &


thanking you

Mohammad Shahnawaz
Oracle Apps DBA
Kuwait