Check and make sure the hobbit user can run sqlplus and tnsping, when oracle installs it sets permissions on some libraries that stops users from accessing the oracle binaries unless the user is in the same group as oracle, usually dba.

Mike

From: Rebecca Henderson [mailto:rebecca_henderson at link.freedom.com] Sent: Thu 27/03/2008 20:03 To: hobbit at hswn.dk Subject: [hobbit] I need help DESPERATELY!! roracle script....

Here is what I;m getting I have checked the path, the ORACLE_HOME

I'm in dire need to get this going.

Thank you in advance.

Process Check (ADB1PLS1)

green<https://lo-mail.rightmove.com/exchange/mike.rawell/Drafts/RE:%20[hobbit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_multipart/image001.gif> Database ADB1PLS1 UP processes: ckpt dbw0 lgwr pmon reco smon

Database Checks (ADB1PLS1)

red<https://lo-mail.rightmove.com/exchange/mike.rawell/Drafts/RE:%20[hobbit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_multipart/image002.gif> Database check: ADB1PLS1 is down or in hung state FUNC_DATABASE_CHECK[16]: /oraclebin2/app/oracle/product/10.2: cannot execute

red<https://lo-mail.rightmove.com/exchange/mike.rawell/Drafts/RE:%20[hobbit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_multipart/image002.gif> Tablespace check disabled since db is down or check is disabled red<https://lo-mail.rightmove.com/exchange/mike.rawell/Drafts/RE:%20[hobbit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_multipart/image002.gif> Extent check disabled since db is down or check is disabled

This email has been scanned for all viruses by the MessageLabs service.

This email has been scanned for all viruses by the MessageLabs service.