This discussion is archived
11 Replies Latest reply: Nov 23, 2012 5:44 AM by EdStevens RSS

Can't access database home page

750060 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    [.....]$ 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 Newbie
    Currently Being Moderated
    Thank you for your help it's helpful for me.......
  • 7. Re: Can't access database home page
    EdStevens Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Once I set ORACLD_UNQNAME, then I need to restart or not, to make changes?
  • 9. Re: Can't access database home page
    EdStevens Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

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