Red Hat 8.1 Installation Manual download pdf (Page 10)

lsnrctl start

Note that Oracle recommends NOT using prespawned dedicated servers in Oracle 8.1.6.

Check to see if the Oracle Server is running:

ps -ef | grep pmon

If no process is displayed, you can manually start the database by typing the following commands:

sqlplus /nolog

connect internal

startup

exit

Verify that the Oracle server has been successfully started and that the database is accessible. Type:

sqlplus system/manager

select count(*) from dba_tables;

exit

The "select count" statement should display a count in excess of 100 tables. If so, the database has been

successfully created.

Fix the dbstart script:

Due to an Oracle Bug 1154931, the supplied $ORACLE_HOME/bin/dbstart script does not start any

8.1.6 instances if they are down. dbstart will report "Database <SID> warm started" rather than

starting the instance. This is due to a change in the banner that Oracle displays in svrmgrl or SQL*Plus.

For the Oracle Enterprise Edition, a workaround of changing the dbstart script to look for the

string "Oracle8i Enterprise Edition" instead of "PL/SQL" can be used to fix this problem:

1) Save a copy of the 8.1.6 $ORACLE_HOME/bin/dbstart script.

2) Edit the script and change the 'awk' lines from:

/PL\/SQL (Release|Version)/ {substr($3,1,3) ;

print substr($3,1,3)}'`

to:

/PL\SQL: (Release|Version)/ {

print substr($3,1,3); exit }

/Oracle7 Server (Release|Version)/ {

print substr($4,1,3); exit }

/Oracle8i Enterprise Edition (Release|Version)/ {

print substr($5,1,3); exit }'`

3) Fix the definition for LD_LIBRARY_PATH from:

LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:${ORACLE_HOME}/lib

to:

LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${LD_LIBRARY_PATH}

Note: This workaround will only work for Oracle8 Enterprise Editions. Similar

workarounds may be used for other editions.

Configure the server to automatically start the Oracle database (and Net8) at system startup and shutdown the

Oracle database at system shutdown:

Automating database startup is optional, but automatic shutdown is recommended because it guards

against improper shutdown of the database.

1 2 ... 5 6 7 8 9 10 11 12 13 14 15 ... 18 19

No comments

Red Hat 8.1 Installation Manual Page 10