CS5226 Database Tuning (Lab 0: FAQ)

 

Prob 1

 

I encountered some strange problems when I was doing lab0. I followed all

the steps exactly before creating the database. The process of the

database creating took several minutes and printed some error messages

saying that it could not find $HOME/oradata/disk1/system01.dbf and

$HOME/oradata/disk2/control01.ctl. I've repeated those steps for 7 or 8

times and got nothing better. Can you help me with it?

 

Sol 1

 

I suspect you aborted the previous installation process, but fall short of
(1) stopping the already running instance and (2) remove the oradata
directory. Before you redo the lab, do a force shutdown of that running
instance.

(1)
SQL> shutdown abort     (use '/ as sysdba' to login)

(2)
rm -rf $HOME/oradata

rm ¨Cf $HOME/lab/lab0/*.log

 

 

Prob 2

 

In lab0, I ran "$HOME/lab/lab0/cs5226.sh" before replacing YOUR_SID in the
four files. Then, I changed YOUR_SID in the four files and reran the
cs5226.sh, and it didn't run correctly, indicating "database not open".
When typing the command "startup pfile=$HOME/lab/lab0/init.ora", the error
is "ORA-00205:error in identifying controlfile, ....".

 

Sol 2

 

You did not (1) stop the wrong (YOUR_SID) instance, and (2) remove
$HOME/oradata before the reinstallation steps.

For (1),
$ pkill -9 -u YOUR_LOGIN_ID

For (2),
$ rm -rf $HOME/oradata

 

 

Prob 3

 

I was creating the database over VPN from outside NUS. During the creation

process, there was a

 

network problem and I was disconnected from Secure Shell client.

After about an hour, when I logged in, I could access all the 5 user

accounts and SQL Plus was starting normally.

 

However, I am not sure whether the database creation is totally successful.

 

Sol 3

 

Check that the file $HOME/lab/lab0/log/postDBCreation.log is present, and

the last portion of the file should read:

 

SQL> Rem

=======================================================================

====

SQL> Rem END utlrp.sql

SQL> Rem

=======================================================================

====

SQL> shutdown ;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup pfile="$HOME/lab/lab0/init.ora";

ORACLE instance started.

 

Total System Global Area   51991620 bytes

Fixed Size                   455748 bytes

Variable Size              46137344 bytes

Database Buffers            4194304 bytes

Redo Buffers                1204224 bytes

Database mounted.

Database opened.

SQL> exit;

 

 

Prob 4

 

When I try to shutdown the instance with one ssh, may it impact the other instance opened in another ssh.

 

Sol 4

 

An instance can be connected by multiple sessions. When you shutdown the instance from one session (in a ssh shell), the other connections to the same instance will also be lost.

 

 

Prob 5

 

I made an error while editing the following 4 files :

 

$HOME/.profile

 

$HOME/lab/lab0/CreateDB.sql

 

$HOME/lab/lab0/cs5226.sh

 

$HOME/lab/lab0/init.ora

 

The instructions were to replace YOUR_SID in the above 4 files with your dbtune account id. However I overlooked that and replaced with a different SID (from that of dbtune account). Qn: is this fatal. Meaning do I have to do another installation or is it just ok to replace the YOUR_SID value in the 4 files even though the installation is complete.

 

What I want to know is if the YOUR_SID value is written into the database installation or is more like an environment variable that is read from the 4 files.

 

Sol 5

 

You have to re-install as the SID is recorded in the database created.

 

 

Prob 6

 

get this - ORA-01109 'database not open' - error at number of places when i try to run the cs5226.sh file. And the execution stops in 10 mins. In the end i get ORA-00205:error in identifying controlfile, ....".

 

Have replaced the right settings for your_sid as given in the instructions, but i still get the error. Process killing, removing oradata and exiting have also not helped. Can you please help on making me understand what is the issue ? Really stuck since a long time.

 

Sorry for the trouble

 

Sol 6

 

Do the following to remove the 'idle' processes first (where username is your dbtune login id), before re-installing the instance.

 

$ ipcs | grep username

 

 

m       12345   0x4eefab5c --rw------- username      dba

s       67890   0x997b80a0 --ra------- username      dba

 

 

$ ipcrm -m 12345

 

$ ipcrm -s 67890