Ok, I did check the perms and that is fixed, here is what I get:

$ sqlplus SQL*Plus: Release 10.2.0.3.0 - Production on Thu Mar 27 13:48:52 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. Enter user-name: hobbit Enter password: Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEM Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production With the Partitioning and Data Mining options

SQL>

But I am still red in the web page here is what I'm checking for

LOCAL ADB1PLS1 hobbit aBEfijk LISTENER_MAC2

-----Original Message----- From: hobbit at hswn.dk [mailto:hobbit at hswn.dk] Sent: Thursday, March 27, 2008 1:16 PM To: Rebecca Henderson; hobbit at hswn.dk Subject: RE: [hobbit] I need help DESPERATELY!! roracle script.... Importance: Low

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[h obbit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_mu ltipart/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[hob bit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_mult ipart/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[hob bit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_mult ipart/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[hob bit]%20I%20need%20help%20DESPERATELY!!%20roracle%20script.....EML/1_mult ipart/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.

To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk