Start Oracle from my account?
January 17th, 2006 By squidward
Not the Phil Collins song. ;)
I wish to start Oracle from my account, vice starting at boot, or starting from the Oracle account.
This command and variants have come close, but not quite:
squid@ubuntu:~$ sudo su - $ORACLE -c "/home/oracle/bin/lsnrctl start listener" Password: LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JAN-2006 05:47:10 Copyright (c) 1991, 2005, Oracle. All rights reserved. TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS[listener] squid@ubuntu:~$
The problem seems to be that the program wants to be started by the home account.
I’ve tried setting -H Oralce without luck. Admitting, I may have the syntax wrong.
January 18th, 2006 at 5:05 am
Try using sudo su – $ORACLE -c “dbstart”.
The dbstart script is in the $ORACLE_HOME/bin directory.
You might have to edit the script to hard code the value for the ORACLE_HOME_LISTNER variable.
January 18th, 2006 at 9:21 am
You need to set your TNS_ADMIN variable to point to $ORACLE_HOME/network/admin.
April 10th, 2008 at 1:22 am
I could able to resolve this issue.
my files under $ORACLE_HOME/network/mesg/ were corrupted. copied from other server. it resolved the issue.