How to generate database setup
files (Oracle 8i/9i - Solaris).
Note: More specific information is contained within
file#39
which is created during the file generation process. File#39
contains the actual file names of the scripts which have been custom-generated
for a particular database instance.
1) Open the Installgen
application.
2) Enter appropriate database creation parameters in the
General,
Backup,
Files/Tablespaces,
Options
and SGA
tabs.
3) Create a folder or directory which will hold the output
files.
4) Verify that the Output directory field on the General
tab is correct.
5) Select Save As from the File menu to save the configuration
information for this particular database server.
6) Press the Generate button to generate the setup scripts/files.
7) Log into the database server, then execute the commands
in the File#1 script as the root user to create additional UNIX accounts.
8) Insert the oracle_build1 CD into the CD-ROM drive of
the Windows system where Installgen was run.
9) Execute the File#2
batch file from the Installgen build directory of the Windows system.
This script will open an ftp session to the Sun server and ftp the additional
Solaris utilities and all of the files from the build directory created
by Installgen. The ftp session is opened using the newly created oracle
owner UNIX account named oracle and the files will be placed into the
/export/oracle directory.
10) Make the File#3
script executable with the command:
chmod +x File#3.
11) Execute the
File#3 on the database server to set the file permissions on the
rest of the files in the /export/oracle directory.
12) Execute the File#4
script as root on the database server.
This script checks for the existence of various Solaris utilies including
top, less, Perl5, and ssh. Then the script requests permission to install
each of these utilies. The script creates and installs the dbora startup
script, oratab file, creates mount point directories to contain the
Oracle datafiles, sets permissions/ownership of these directories. Permission
is requested and if granted, the script creates/installs vfstab, defaultrouter,
hosts, system, profile files, creates/installs /opt/server_scripts and
rotateoraclefiles.sh script for rotating/removing log files, and creates/installs
the sshd startup script file.
13) Insert the 1st Oracle installation CD into the Sun
server, then execute the File#5
script as root. This script copies the contents from each of the three
Oracle installation CDs into the /export/oracle directory, then creates
NFS shares of the directories so that the software can be copied to
other servers within the network.
14) Transfer the File#6
script to additional Sun servers where Oracle will be installed (such
as the OEM server). Execute the File#6 on each of those servers after
executing the appropriate versions of the File#1, File#2, File#3, and
File#4 scripts for the server.
Note: OEM servers should use the File#12
in place of the File#11 file renamed to /etc/init.d/dbora to start up
the database and the OMS.
15) Restart the Sun server to permit the kernel modifications
in the /etc/system file to become effective.
16) Execute the File#7
script to initiate the installation process using the Oracle Java based
installer on the server.
17) Select "y" when prompted by the File#7 script
to start the process of building the database using script File#8.
This process may take several hours, depending upon the number of features
installed and the performance of the server.
18) Execute the File#9
script to create Oracle dba accounts, change default database passwords,
apply the latest patchfile to the database, and configure backup and
recovery features.
19) Perform a full backup of the database to test the
backup process (and a full export too if possible).
