11 Replies Latest reply: Nov 23, 2012 7:44 AM by EdStevens RSS

    Can't access database home page

    750060
      I have install Oracle 11g release 2 in Ubuntu 9.10
      but i can't access database home page

      my database name = archbase

      ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1/bin
      ORACLE_SID = archbase

      i try to configure database console, but
      i can't configure ORACLE_UNQNAME environment variable.

      how to fix it step by step.....
      help me please.......

      Edited by: aries_record@yahoo.com on Feb 23, 2010 9:39 PM
        • 1. Re: Can't access database home page
          sb92075
          i try to turn on database console but the computer say
          that i need to set ORACLE_UNQNAME environment variable
          Too bad CUT & PASTE are broken for you.
          We don't know exactly what you did or how Oracle really responded.
          • 2. Re: Can't access database home page
            Mahesh Menon
            Start your instance and find out the db_unique_name value.

            show parameter db_unique_name.

            Most probably it will be archbase itself....

            Now set the ORACLE_UNQNAME env variable value to the value found from db_unique_name.

            If the db_unique_name value you got is archbase,

            In windows , set oracle_unqname=archbase

            Linux, oracle_unqname=archbase;export oracle_unqname
            • 3. Re: Can't access database home page
              750060
              Thank you for your help........

              i will try it at home...
              but i don't know the syntax in Linux how to Start instance and find out the db_unique_name value.

              because I'm a beginner in Oracle and Linux...
              • 4. Re: Can't access database home page
                Mahesh Menon
                Please tell me whether you could configure the EM. If the solution was correct, then please mark it as correct...
                • 5. Re: Can't access database home page
                  Mahesh Menon
                  [.....]$ oracle_home=/u01/app/oracle/10.2.0/product/db_1;export oracle_home
                  [.....]$ oracle_sid=archbase;export oracle_sid
                  sqlplus / as sysdba

                  If it is saying like connected to idle instance, then issue

                  SQL>startup

                  ---
                  --
                  Database opened.

                  Else if it connects you directly to the instance, then in sql query the status of the instance...

                  SQL>select status from v$instance;

                  If the status is not OPEN, (i mean if it is in NOMOUNT or MOUNT)

                  SQL>alter database open;


                  SQL>show parameter db_unique_name

                  (To issue the above command , the instance need not be in OPEN state. It can be run in NOMOUNT or MOUNT state)

                  ==========================

                  HTH,
                  Mahesh.

                  Edited by: Mahesh Menon on Feb 24, 2010 10:12 AM

                  Edited by: Mahesh Menon on Feb 24, 2010 10:14 AM
                  • 6. Re: Can't access database home page
                    750060
                    Thank you for your help it's helpful for me.......
                    • 7. Re: Can't access database home page
                      EdStevens
                      aries_record@yahoo.com wrote:
                      Thank you for your help it's helpful for me.......
                      But beware that in all *nix, everything is case sensitive, and those environment variables should be upper case:

                      export ORACLE_HOME=....
                      export ORACLE_SID=...

                      Oracle knows to look for ORACLE_HOME and ORACLE_SID; it does NOT know what 'oracle_home' and 'oracle_sid' are.
                      • 8. Re: Can't access database home page
                        962858
                        Once I set ORACLD_UNQNAME, then I need to restart or not, to make changes?
                        • 9. Re: Can't access database home page
                          EdStevens
                          959855 wrote:
                          Once I set ORACLD_UNQNAME, then I need to restart or not, to make changes?
                          Why are you hijacking someone else's thread that is well over 2 years old?

                          Your question has no real context. Please start your own thread, state your complete version of oracle AND operating system and a complete description of YOUR problem.
                          • 10. Re: Can't access database home page
                            44094
                            In my experience the oracle_unqname error is trigger by the Oracle database installation process.

                            The Time Zone in the installation computer should be set to a 'Oracle valid' time zone like London, UK.

                            It seem like there is a time zone match up between the Installation computer and the Oracle database. When the computer time zone is set to an 'unkown' time zone it messes up the installation.

                            Do a clean installation with the computer time zone set to a prominent time zone. This works on Windows 7 and Windows Server 2008. May work with other OS.
                            • 11. Re: Can't access database home page
                              EdStevens
                              rajindrar wrote:
                              In my experience the oracle_unqname error is trigger by the Oracle database installation process.

                              The Time Zone in the installation computer should be set to a 'Oracle valid' time zone like London, UK.

                              It seem like there is a time zone match up between the Installation computer and the Oracle database. When the computer time zone is set to an 'unkown' time zone it messes up the installation.

                              Do a clean installation with the computer time zone set to a prominent time zone. This works on Windows 7 and Windows Server 2008. May work with other OS.
                              That's FIVE old and unrelated threads you've pulled up to post this same response .... whether or not the action you recommend has anything at all to do with the dormant thread you resurrected.