Scribd
Upload
7 views2 pages

Oracle EBS Database Setup Guide

The document outlines the steps to start the database and application tiers for Oracle E-Business Suite, including enabling users and changing passwords. It details commands to be executed as the root and oracle users, and includes instructions for verifying successful processes through log files. Additionally, it provides steps for updating the WebLogic Server administrator password and enabling the Integrated SOA Gateway.

Uploaded by

mohmmedhdx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views2 pages

Oracle EBS Database Setup Guide

The document outlines the steps to start the database and application tiers for Oracle E-Business Suite, including enabling users and changing passwords. It details commands to be executed as the root and oracle users, and includes instructions for verifying successful processes through log files. Additionally, it provides steps for updating the WebLogic Server administrator password and enabling the Integrated SOA Gateway.

Uploaded by

mohmmedhdx
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Start database tier

(logged in as root user on SSH):

service ebscdb start

Activating EBS Users

Login SSH as oracle user.


Create an empty directory for the FNDCPASS script to generate log files with the results

mkdir ~/log ; cd ~/log

Enable the SYSADMIN user using this command (note somewhere the password for this user –
Welcome01 in lecture)

/u01/install/APPS/scripts/[Link]

Enable the Vision demo users using this command (note somewhere the password for this user –
Welcome01 in lecture)

/u01/install/APPS/scripts/[Link]

Change the database passwords for the base product schemas using this command (When the script
prompts you to provide the password for the SYSTEM user, enter 'manager'.):
(note somewhere the password for base product schemas – Welcome01 in lecture)

/u01/install/APPS/scripts/[Link]

Check the log files to verify if the processes succeed (you should not have any output for second
command):
[oracle@apps log]$ grep 'changed successfully' L*.log
[oracle@apps log]$ egrep -i 'error|failed|invalid' L*.log

Database SYS passwords change

(still logged in as oracle user)


Run script to setup environment:

. /u01/install/APPS/19.0.0/EBSCDB_apps.env

Enter sqlplus to change db system user passwords:

sqlplus / as sysdba

SQL> alter user SYSTEM identified by Welcome01;


SQL> alter user SYS identified by Welcome01;
SQL> exit
Start apps tier

(logged in as root user on SSH):


service apps start

Password Change for Oracle WebLogic Server (WLS) administrator user weblogic

Source the run file system with the oracle user:

. /u01/install/APPS/[Link] run

Stop most of the application tier processes, but leave the Node Manager and Admin server running:
(When prompted, enter APPS user name (apps), desired APPS password (apps in shown lecture), and
current WebLogic Server password which is welcome1)

[Link] -skipNM -skipAdmin

Change password for the Oracle WebLogic Server administrator user weblogic

perl $FND_TOP/patch/115/bin/[Link] -action=updateAdminPassword

Confirm with Yes


Accept the default apps context file path when prompted,
Enter current WebLogic Admin password (welcome1), new WebLogic Admin password (Welcome01 in
lecture), and APPS password (apps in lecture).

Start all the application tier processes again on the run edition file system.
(when prompted enter necessary passwords, apps/apps/Welcome01 in lecture)

[Link]

Replace password in scripts for weblogic user with the following command:

cd /u01/install/APPS/scripts/
chmod 700 st*[Link]
for f in st*[Link] ;do sed -i 's/welcome1/Welcome01/' $f ;done

Enable Oracle E-Business Suite Integrated SOA Gateway (ISG)

cd ~/log
/u01/install/APPS/scripts/[Link]

You might also like