How to start or stop Database Tier in Oracle EBS?

1. Open a new terminal window and setup environment to run scripts on Database Tier (for more info see )

2. Start the listener

cd $ORACLE_HOME/appsutil/scripts/VIS_ebs12

./addlnctl.sh start VIS

where VIS is your SID (Oracle System ID)

If you don't know the directory for $ORACLE_HOME then use the following directory:

cd /u01/apps/[hostname]/db/tech_st/11.1.0/appsutil/scripts/[SID]_[hostname]

./addlnctl.sh start VIS

3. Start the database. Option 1 - using script

cd $ORACLE_HOME/appsutil/scripts/[SID]_[hostname]
./addbctl.sh start

If you don't know the directory for $ORACLE_HOME then use the following directory:

cd /u01/apps/[SID]/db/tech_st/11.1.0/appsutil/scripts/[SID]_[hostname]
./addbctl.sh start

4. Option 2 - manually You can also start the database manually without using the above script. To do that first login into SQL as SYSDBA:

$ sqlplus '/ as sysdba';

6. Start the Database

startup

How to stop the Database?

7. Option 1 - using script. Using the following commands:

cd $ORACLE_HOME/appsutil/scripts/[SID]_[hostname]
./addbctl.sh stop

If you don't know the directory for $ORACLE_HOME then use the following directory:

cd /u01/apps/[SID]/db/tech_st/11.1.0/appsutil/scripts/[SID]_[hostname]
./addbctl.sh stop

8. Option 2 - manually. First login into SQL as SYSDBA

$ sqlplus '/ as sysdba';

shutdown

How to Stop the Listnener?

9. Option 1 - using script. Using the following commands:

cd $ORACLE_HOME/appsutil/scripts/[SID]_[hostname]
./addlnctl.sh stop VIS

where VIS is your SID (Oracle System ID)

If you don't know the directory for $ORACLE_HOME then use the following directory:

cd /u01/apps/[SID]/db/tech_st/11.1.0/appsutil/scripts/[SID]_[hostname]
./addlnctl.sh stop VIS

Assumptions

Environment