11 Replies Latest reply: May 3, 2012 3:44 PM by DB Steve RSS

    Oracle installation question

    user409261
      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
          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
            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
              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
                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
                  I found the place to enter a db name. thank you all.
                  • 6. Re: Oracle installation question
                    user409261
                    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
                      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
                        $ 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
                          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
                            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
                              You have already posted this question - Need help w. connecting to oracle 10g express

                              Hijacking threads and posting duplicates are frowned upon ;-)

                              Srini