Page 1 of 3 123 LastLast
Results 1 to 15 of 33
  1. #1
    Join Date
    Jan 2004
    Location
    Bangalore
    Posts
    25

    Unanswered: ORACLE not available

    Hi All,

    I have some problem with the Oracle, when i tried to login as system/manager it is giving me the error :


    ERROR:
    ORA-01034: ORACLE not available

    can u please give me the solution like what might be the problem with the oracle.


    Thanks,
    clarify

  2. #2
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi,
    Assuming u r on windows platform.
    Take a look at the services ie Oracle ServiceSID whether it is started or not if not then start it .
    I hope there was no problem with ur installation.
    U can also do the following from the cmd prompt.

    Set ORACLE_SID=ORCL(say)
    svrmgrl (Not in 9i)
    connect internal (Not in 9i)
    password
    startup pfile (optional)

    For 9i
    Set ORACLE_SID=ORCL(say)
    sqlplus sys/passwd as sysdba
    startup

    Sometimes we miss certain things in hurry which are already known to us.

    But if the above does'nt solve ur problem then post the contents of alert file and check the contents of bdump,udump directory.
    Please do not forget to write the Oracle version as well as the OS u r using.

    Kaushik

  3. #3
    Join Date
    Jan 2004
    Location
    Bangalore
    Posts
    25

    ORACLE not available

    hi ,

    when i tried to run the svrmgrl and type connect internal,its asking for the password. I have given the password as "password" or is there any default password.Is it "password" is correct. Where i am getting the following error:


    SVRMGR> connect internal
    Password:
    ORA-01031: insufficient privileges
    SVRMGR>

    can u pls solve the problem.

    Thanks,
    vamshi

  4. #4
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    hi if u have the default password for the internal user not changed then it is oracle.
    Don't forget to write
    Set Oracle_sid=<the name of ur sid>



    One more thing u should let me know whether the user u r using to connect to the machine(ie OS user and not the DB user) is member of ORA_DBA group.

  5. #5
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Once you get this going, you should check the registry for
    local_machine\software\oracle\home0 ... Look for you Oracle sid. There should be a line ... Oracle_xxx_autostart (xxx is the sid). If you want the database to start when the service starts (ie, at boot time), this needs to be set to TRUE...

    HTH
    Gregg

  6. #6
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    try the sys password... Also, not sure what version you are running, but I remember the internal password being "manager" in 7.x

    Finally, you might wanna checkout this link:

    http://asktom.oracle.com/pls/ask/f?p...79970709871413

    Good-luck,
    Rip
    Last edited by the Oracle; 04-12-04 at 18:00.
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  7. #7
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    R u sure? as far as my knowledge goes manager is the default password for system user. I am not sure for oracle 7 releases.

    Kaushik

  8. #8
    Join Date
    Jan 2004
    Location
    Germantown, MD
    Posts
    34
    Originally posted by kausik_m123
    R u sure? as far as my knowledge goes manager is the default password for system user. I am not sure for oracle 7 releases.

    Kaushik
    You are correct... the default system = manager and sys = change_on_install. I guess I wasn't clear with my statement... I am pretty sure that internal defaulted to the sys password in 8, but in 6.x and 7.x it defaulted to manager. Since I wasn't sure what version he is running, I just covered both bases.
    "The world is a dangerous place, not because of those who do evil, but because of those who look on and do nothing. "
    - Albert Einstein

  9. #9
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    But did the original problem got resolved?
    Clarify do update with results when u feel..

  10. #10
    Join Date
    Jan 2004
    Location
    Bangalore
    Posts
    25

    ORACLE not available

    hi kaushik,

    Still its giving me the same problem i.e., oracle not available.

    I set oracle_sid = "SAI" and when i check in services OracleServiceSAI and OracleTNSListener are running its automatic not even manual.

    Is there any other way where i can see the log files so that we can know whats going wrong.....


    Thanks,
    vamshi

  11. #11
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    the log file is in oraclehome\admin\sai\bdump\alert_sai.log
    There are 10 types of people in the world, those that know Binary and those that don't.

  12. #12
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Hi Clarify,
    Do the following things:


    1. Post the contents of ur log file.
    2. Check the Event Viewer for any possible Oracle application error.

    I still believe the problem can be resolved by the following.
    Stop the ORacleServiceSAI restart it .
    >Svrmgrl
    >connect internal\oracle
    >startup
    See after connect internal with proper password it should show as connected.But if it shows Oracle not available at that point then there must be some problem with the installation or some files might get corrupted.
    If it shows connected then issue startup and let me know the error u encounter.
    Remember the instance running does not mean the database is also running u can very well have the instance running without the DB running but the other way is not true.
    startup command is given to start the DB , if any error occurs it will show them.

    The Oracle documentation says about this particular error that SGA requires more space than allocated to it.

    I hope in the initSAI.ora the values(specially memory management variables) are correctly set or taken from the sample init.ora file. Moreover while running the Oracle service try to keep the server resources free.Hope its not because of resource problem.



    Kaushik
    Last edited by kausik_m123; 04-13-04 at 10:26.

  13. #13
    Join Date
    Jan 2004
    Location
    Bangalore
    Posts
    25

    ORACLE not available

    kausik,

    Still i am encountering the same problem.But i have one query

    I have two files of

    LISTENER.ora
    protocol.ora
    SQLNET.ora

    is this a problem.

    thanks,
    clarify

  14. #14
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Post the last bit of your Alert log ... The service is up, BUT is the DATABASE up ... If the registry entry is not set for AUTOSTART=TRUE,
    then the database will not start will the service starts...

    Have you tried to STARTUP the database yet ???

    Gregg

  15. #15
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    ****************************************
    "kausik,

    Still i am encountering the same problem.But i have one query

    I have two files of

    LISTENER.ora
    protocol.ora
    SQLNET.ora

    is this a problem."
    **************************

    NO...

    Post the logfiles and let me know at what point u r getting oracle not available error..
    After connect internal(does it show connected)

    Or
    after startup

    Kaushik

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •