This discussion is archived
11 Replies Latest reply: May 3, 2012 1:44 PM by DB Steve RSS

Oracle installation question

user409261 Newbie
Currently Being Moderated
Hi:
This is my first time installing Oracle 11g on linux. I have done some screens up to missing prereqesit. I have noticed that I have not be prompted to enter a SID name? Where do I define a SID name?
Thanks.
  • 1. Re: Oracle installation question
    sb92075 Guru
    Currently Being Moderated
    907485 wrote:
    Hi:
    This is my first time installing Oracle 11g on linux. I have done some screens up to missing prereqesit. I have noticed that I have not be prompted to enter a SID name? Where do I define a SID name?
    Thanks.
    If you have not satisfied the prerequisites, you have not gotten far enough to enter the SID.

    Oracle DB is much easier to install on Oracle Enterprise Linux (OEL), than any other flavor.
    What specific flavor of Linux is on your system?
  • 2. Re: Oracle installation question
    karan Pro
    Currently Being Moderated
    Mention rhe Linux flavour or version details... Prerequisite faliure can be any like kernel configurations not met in /etc/sysctl.conf or any rpm package missing or swap insufficient.. And for your SID if it is prompting you just enter the value once you have the screen or invoke dbca after installation..

    Oracle SID is a unique system identifier of a database in your system, this way you cannot have more than 1 database with the same SID on your system

    Regards
    Karan
  • 3. Re: Oracle installation question
    user409261 Newbie
    Currently Being Moderated
    Karen and SB:

    thanks.
    I got from $cat /etc/*-release
    ===
    Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)
    Red Hat Enterprise Linux Server release 5.5 (Tikanga)
    ===

    Do i have Enterprise Linux or Red Hat linux?
  • 4. Re: Oracle installation question
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    Pl identify the exact database version you are installing. You will need to follow the steps in the Install Guide

    11gR2 - http://docs.oracle.com/cd/E11882_01/install.112/e24321/toc.htm
    11gR1 - http://docs.oracle.com/cd/B28359_01/install.111/b32002/toc.htm

    Pay particular attention to the software pre-requisites.

    HTH
    Srini
  • 5. Re: Oracle installation question
    user409261 Newbie
    Currently Being Moderated
    I found the place to enter a db name. thank you all.
  • 6. Re: Oracle installation question
    user409261 Newbie
    Currently Being Moderated
    Go warnings at end. One of them is
    1) listener prot 1521 provided is incorret.
    2)listener isnot up
    3) database service ORCL is not registered with listener.

    I don't see a listener.ora and tnsname.ora under $TNS_ADMIN.
  • 7. Re: Oracle installation question
    sb92075 Guru
    Currently Being Moderated
    907485 wrote:
    Go warnings at end. One of them is
    1) listener prot 1521 provided is incorret.
    2)listener isnot up
    3) database service ORCL is not registered with listener.

    I don't see a listener.ora and tnsname.ora under $TNS_ADMIN.
    files only exist after they have been created.

    open Command Window & issue follow OS commands

    lsnrctl start
    lsnrctl status
    lsnrctl service

    COPY command & results then PASTE all back here
  • 8. Re: Oracle installation question
    user409261 Newbie
    Currently Being Moderated
    $ lsnrctl start ORCL

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-MAY-2012 10:50:40

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Starting /u02/app/oraoid1/product/11.2.0/dbhome_2/bin/tnslsnr: please wait...

    TNSLSNR for Linux: Version 11.2.0.2.0 - Production
    Log messages written to /u02/app/oraoid1/product/11.2.0/dbhome_2/log/diag/tnslsnr/todidb02/orcl/alert/log.xml
    TNS-01151: Missing listener name, ORCL, in LISTENER.ORA

    Listener failed to start. See the error message(s) above...

    ====
    $lsnrctl status ORCL

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-MAY-2012 10:50:57

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    TNS-01101: Could not find service name ORCL

    ====
    $ lsnrctl service

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 02-MAY-2012 10:51:10

    Copyright (c) 1991, 2010, Oracle. All rights reserved.

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    The listener supports no services
    The command completed successfully
  • 9. Re: Oracle installation question
    sb92075 Guru
    Currently Being Moderated
    now I understand the root cause.
    Problem Exists Between Keyboard And Chair.

    It appears you have a problem regarding reading & following directions.
    I have serious doubts that you & Oracle will ever peacefully coexist.
  • 10. Re: Oracle installation question
    DB Steve Newbie
    Currently Being Moderated
    I realize that I have been reading posts re. connecting to 11g but I am having problems with starting 10g using the sql command line prompt. Can u please help me with this [problem]?
  • 11. Re: Oracle installation question
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    You have already posted this question - Need help w. connecting to oracle 10g express

    Hijacking threads and posting duplicates are frowned upon ;-)

    Srini

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points