Oracle 8i/9i/10g Manual installation steps on new server using binaries files.

Oracle 8i/9i/10g  Manual installation steps  on new server using binaries files.

Step 1:-Copy all binary files from backup.

Step 2:-Copy all dbfiles, logfiles,controlfiles and tempfles

Step 3:-Copy pfile from backup and edit them as current database structure.

Step 4:- Grant permission on all datafiles and controlfiles to oracle

Step 4:-Set parameter as below

Set Environment Variables

export ORACLE_HOME=/home1/home/hris/ora8i

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

export PATH=$ORACLE_HOME/bin:$PATH

export ORACLE_SID=HRIS

or

PATH=$PATH:$ORACLE_HOME/bin

export PATH

Under:- oracle home.

$ Cd /home1/home/hris/ora8i

$ which sqlplus

/home1/home/hris/ora8i/bin/sqlplus

$ sqlplus /nolog

/home1/home/hris/HRISDB/controlfiles

/home1/home/hris/ora8i/admin/PROD/udump

$sqlplus /nolog

SQL>conn / sys as sysdba

 Connected

SQL>starup nomount pfile='pfile.ora';

Check then db files,logfile and controlfile location and update it as located on server.

SQL> alter database mount;

SQL> select name from v$datafiles;

SQL> select member from v$logfiles;

SQL> select file_name from v$tempfile;

In Mount mode do as :-

SQL> alter database rename file 'old file name ' to 'location.filename.dbf';

Rename  all datafile and logfile.

then alter database tempfile 'filename' drop;

alter tablespace temp file size reuse;

SQL>alter database open;

SQL> SELECT MEMBER FROM V$LOGFILE;

MEMBER

--------------------------------------------------------------------------------

/oradata/HRIS/hrisdata/redofiles/redo03HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo03mHRIS.log

/oradata/HRIS/hrisdata/redofiles/redo02HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo02mHRIS.log

/oradata/HRIS/hrisdata/redofiles/redo01HRIS.log

/oradata/HRIS/hrisdata/redofiles/redo01mHRIS.log

SQL> select file#,ts#,status,enabled,bytes,RFILE# from v$tempfile;

     FILE#        TS# STATUS  ENABLED         BYTES     RFILE#

---------- ---------- ------- ---------- ---------- ----------

         5          2 ONLINE  READ WRITE          0          5

         6          2 ONLINE  READ WRITE          0          6

         7          2 ONLINE  READ WRITE          0          7

         8          2 ONLINE  READ WRITE          0          8

ALTER TABLESPACE lmtemp ADD TEMPFILE '/u02/oracle/data/lmtemp02.dbf' SIZE 18M REUSE;