Hi, Farrukh,

The oratab file is like
ORACLE_SID:ORACLE_HOME:Y

In my previous reply, I put "<>" around the variables and it came out as ::Y.

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

Hi, Jeff,

The database got startup but listener not. The /tmp/db.log file got updated and it showed 'Database started'.

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

Hi, Sam,

Here is what I got in the listener.log after I reboot the machine.

03-DEC-2001 16:54:16 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=dino)(USER=oracle))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER) (VERSION=135294976)) * stop * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dino)(PORT=1521)))

I am going to switch the preceedence of database and listener in dbora file and see whether it will work.

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

Hi, Daniel,

I am going to try to drop '&' in dbora and see if that works.

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

Thank you all,
Jiong