[hobbit] I need help DESPERATELY!! roracle script....

[Rebecca Henderson]

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