#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2004
    Posts
    16
    Rep Power
    0

    Define environment variable ORACLE_SID


    I have tried to run my ORACLE 10 G manually by typing

    [oracle@routerPC02 bin]$ cd $ORACLE_HOME/bin
    [oracle@routerPC02 bin]$ ./emctl

    And it seems that i need to define environment variable ORACLE_SID

    TZ set to Asia/Japan
    Environment variable ORACLE_SID not defined. Please define it.

    How to define environment variable ORACLE_SID?...
  2. #2
  3. No Profile Picture
    Senior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    308
    Rep Power
    11
    syntax:
    -------
    $export ORACLE_SID = <instance name>

    example:
    --------
    $export ORACLE_SID = ORCL
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    28
    Rep Power
    0
    I'm sure you've already done this, but do put the env variable in your .profile or .bash_profile file so that it will be automated.

    jim


    Originally Posted by shafique
    syntax:
    -------
    $export ORACLE_SID = <instance name>

    example:
    --------
    $export ORACLE_SID = ORCL
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0
    I entered this:

    $export ORACLE_SID = ORCL

    the db is prompting an error;
    'export' is not recognized as an internal or external command,
    operable program or batch file.
  8. #5
  9. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    848
    Rep Power
    387

    Talking


    What OS are you using?
    The "$" is the OS prompt, do not include (type) it.
    Originally Posted by kicap
    . . .
    And it seems that i need to define environment variable ORACLE_SID
    . . .
    How to define environment variable ORACLE_SID?...
    It is not enough to set ORACLE_SID, you also may need to set other environment variables by executing the oraenv script:


    Code:
    $ . /usr/local/bin/oraenv {oracle sid}
    $ ## Example:
    $ . /usr/local/bin/oraenv ORCL
    PS: Notice the {dot}-Space before the script
    Last edited by LKBrwn_DBA; January 15th, 2014 at 11:36 AM.
  10. #6
  11. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    Originally Posted by Rizwanjoo
    I entered this:

    $export ORACLE_SID = ORCL

    the db is prompting an error;
    'export' is not recognized as an internal or external command,
    operable program or batch file.
    Sounds like you are on Windows. You need to use the SET command then:
    Code:
    set ORACLE_SID=ORCL
    More details in the online help: http://www.microsoft.com/resources/d....mspx?mfr=true
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
    http://forums.devshed.com/misc.php?do=bbcode#code

    Tips on how to ask better questions:
    http://tkyte.blogspot.de/2005/06/how-to-ask-questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

IMN logo majestic logo threadwatch logo seochat tools logo