OraQA

Oracle Question and Answer


Latest Comments

  • Laurent Schneider:
    if you like a Base64 format, maybe this… select utl_raw.cast_to_varchar 2(...

  • hsafra:
    You need to give more specs for the question: What letter are acceptable? What letters aren’t? Do you...

  • ragunathansd:
    I am not inserting sequence numbers from database. I need to populate the data in a grid. If a user...

  • gamyers:
    “redo log file gets full” That is the nature of a redo log file. It gets full, switched and...

Comments RSS feed


  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed
« How to Write “Good” SQL

Alternatives to using a job? »

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.

Filed under Administration, Question. Follow any responses to this entry through this RSS 2.0 feed.  

3 Responses to “Start Oracle from my account?”

  1. rajeev Says:
    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.

  2. TFox Says:
    January 18th, 2006 at 9:21 am

    You need to set your TNS_ADMIN variable to point to $ORACLE_HOME/network/admin.

  3. prashant.pawar Says:
    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.

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question
« How to Write “Good” SQL

Alternatives to using a job? »