Oracle Vision Installation Information

Documentation

Prepared by: Felice Meneses

Version:V1.1

Release Date:07 December 2011

Revision V1.1 (added Backup procedure)

Table of Contents

Oracle Vision Installation Information1Account details3Folder / partition details3Host Information (/etc/hosts entry)3RedHat Version4Vision Installation Version Information4Top Level Application Directory Structure4How to access the Oracle Vision?5Startup and Shutdown6Shutdown / Startup Sample Scenario7Database File Backup Procedure8

Account detailsThe main login account details for the oracle server are:1. Root account and password: root / ghitoracle2. Linux application and database account and password: applvis / applvis1233. Vision sysadmin account and password: sysadmin / sysadmin4. Apps database login account and password: apps/appsFolder / partition detailsThe disk is configured in RAID-5 and sizing as follows:

Host Information (/etc/hosts entry)

RedHat Version

Vision Installation Version InformationApplication version12.0.1

Database version11.1.0.7

Developer ORACLE_HOME version10.1.2

Web Java ORACLE_HOME version10.1.3

Top Level Application Directory Structure

Where: DB/u01/oracle/VIS01/db

INST/u01/oracle/VIS01/inst

APPS/u01/oracle/VIS01/apps

How to access the Oracle Vision?1. Open internet explorer2. Copy the URL: http://lxorclebs010.ghit.com.sg:8010 to the URL address box.3. Key in application user name and password (e.g. sysadmin) and choose the responsibility.

Startup and ShutdownTo perform a shutdown of the database and application, you must login to unix as applvis. To do this, launch putty connection and login.To perform shutdown and startup, refer to below table. NOTE: ONLY applvis account should perform the startup and shutdown. Root account should no execute the command below.CommandDescription

apps_stopThis will stop the application services, concurrent manager, etc

apps_startThis will start all application services, concurrent manager, etc.

db_stopThis will shutdown the database and the listener

db_startThis will start up the database and the listener

stop_allThis will stop all the services including database, application and listener services, etc.

start_allThis will start all the services including database, application and listener services, etc.

Shutdown / Startup Sample ScenarioA. You need to reboot the server. Refer to below steps:1. Go to console of the server or from putty, and log in as applvis2. In the terminal session, type stop_all to stop all services. This include application services (concurrent manager, forms, applets, etc.), database and listener3. Verify if the shutdown is successful by executing: ps ef| grep applvis. There should be maximum of 8 processes displayed.4. Once the shutdown completes, execute shutdown -r now. This command will reboot the system but will not automatically start the oracle services 5. Again, go to console or connect applvis from putty6. In the terminal session, type start_all to start all services. This include application services (concurrent manager, forms, applets, etc.), database and listener7. To test, log in to the oracle applications using the procedure outline in How to access Oracle Vision? section.

B. You need to shutdown only the application services. Refer to below steps:1. Go to console of the server or from putty, and log in as applvisC. In the terminal session, type apps_stop to stop all application services. This include application services (concurrent manager, forms, applets, etc.), database and listener

C. You need to startup only the application services. Refer to below steps:1. Go to console of the server or from putty, and log in as applvis2. In the terminal session, type apps_start to stop all application services. This include application services (concurrent manager, forms, applets, etc.), database and listener

D. If you need to shutdown the database services, you must make sure that no application services is running. Refer to below steps:1. Verify concurrent manager services, execute ps ef| grep applvis| grep FNDLIBR. This should not return any rows. Only the pmon, smon, mmon, etc (which are database services) must be up and running at this time2. Once confirmed that no application service is up and running, proceed to shutdown the database by executing db_stop.

E. If you need to startup the database services only, refer to below steps:1. Go to console of the server or from putty, and log in as applvis2. In the terminal session, type db_start to start database and listener services.

Database File Backup ProcedureThis section describes how to perform a simple database file backup for the Vision instance. The steps includes the following:1. Go to console of the server or from putty, and log in as applvis2. In the terminal session, type /home/applvis/scripts/backup/ db_bkup.sh. This script will perform the following:a. Shutdown applications servicesb. Shutdown database and listener servicesc. Perform database file tar and gzip to the backup folderd. Start the database and listener servicese. Start the application services3. Verify the backup and review the logs as listed in the folder mentioned below.FolderDescription

/home/applvis/scripts/backupLocation of the script to run the backup

/home/applvis/logsLocation of backup log

/u01/oracle/backupLocation of backup file (tar.gz).

Sheet1FilesystemSizeUsedAvailUse%Mounted onUsage/dev/sda39.9G321M9.1G4%//dev/sda1289M18M257M7%/bootnone7.9G6.6M7.9G1%/dev/shm/dev/sda89.9G88M9.3G1%/home/dev/sda59.9G55M9.3G1%/opt/dev/sda104.0G41M3.7G2%/tmp/dev/sda11757G335G384G47%/u01partition for oracle install/dev/sda79.9G3.3G6.2G35%/usr/dev/sda94.0G41M3.7G2%/usr/local/dev/sda69.9G181M9.2G2%/var