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