This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Oct 15, 2013 6:53 AM by user12075536123 RSS

Issue running Orace DB

BasuD Newbie
Currently Being Moderated

Hi,

I've installed Oracle 11g R2 on Windows 7 Home Basic around 6 mont hs back. It was working fine that time, I've implemented Golden Gate on the same. Today(after a long time) when I tried working with the DB I'm getting errors as below-

 

I logged in using "sqlplus / as sysdba" command, it shows connected, but still getting errors

ORA-01012: not logged on

 

I've tried shutting down the db with below command

SQL> shutdown immediate

ORA-24324: service handle not initialized

ORA-01041: internal error. hostdef extension doesn't exist

 

Then Tried strting it-

SQL> STARTUP

ORACLE instance started.

 

 

Total System Global Area 1670221824 bytes

Fixed Size                  2176328 bytes

Variable Size            1191185080 bytes

Database Buffers          469762048 bytes

Redo Buffers                7098368 bytes

Database mounted.

ORA-03113: end-of-file on communication channel

Process ID: 4348

Session ID: 191 Serial number: 3

 

 

When I give correct Id/Password I'm getting below

 

ERROR:

ORA-12514: TNS:listener does not currently know of service requested in connect

descriptor

Enter user-name:

 

Please suggest how can I troubleshoot the issue. Thanks in advance.!

  • 1. Re: Issue running Orace DB
    sybrand_b Guru
    Currently Being Moderated

    No version of Oracle is certified to run on any Home edition of Windows.

     

    Online documentation and Google exists for a reaosn

    The answer to FAQs can be found easily using those resources.

    You can troubleshoot the issue by actually using them.

     

    ----------

    Sybrand Bakker

    Senior Oracle DBA

  • 2. Re: Issue running Orace DB
    user12075536123 Pro
    Currently Being Moderated

    please post the output of alert.log from startup


    please post the output of below cmd
    select * from v$recovery_file_dest;

  • 3. Re: Issue running Orace DB
    Aman.... Oracle ACE
    Currently Being Moderated

    BasuD wrote:

     

    Hi,

    I've installed Oracle 11g R2 on Windows 7 Home Basic around 6 mont hs back. It was working fine that time, I've implemented Golden Gate on the same. Today(after a long time) when I tried working with the DB I'm getting errors as below-

     

    I logged in using "sqlplus / as sysdba" command, it shows connected, but still getting errors

    ORA-01012: not logged on

     

    I've tried shutting down the db with below command

    SQL> shutdown immediate

    ORA-24324: service handle not initialized

    ORA-01041: internal error. hostdef extension doesn't exist

     

    Then Tried strting it-

    SQL> STARTUP

    ORACLE instance started.

     

     

    Total System Global Area 1670221824 bytes

    Fixed Size                  2176328 bytes

    Variable Size            1191185080 bytes

    Database Buffers          469762048 bytes

    Redo Buffers                7098368 bytes

    Database mounted.

    ORA-03113: end-of-file on communication channel

    Process ID: 4348

    Session ID: 191 Serial number: 3

     

     

    When I give correct Id/Password I'm getting below

     

    ERROR:

    ORA-12514: TNS:listener does not currently know of service requested in connect

    descriptor

    Enter user-name:

     

    Please suggest how can I troubleshoot the issue. Thanks in advance.!

    The very first thing is that you run oracle db on a supported OS. Any Home version of Windows is not supported. For the errors mentioned, search in this forum as they are discussed here quite a lot of times already.

     

    Aman....

  • 4. Re: Issue running Orace DB
    Aman.... Oracle ACE
    Currently Being Moderated

    user12075536123 wrote:

     

    please post the output of alert.log from startup


    please post the output of below cmd
    select * from v$recovery_file_dest;

    Though I can see the relevance of the alert log information to some extent in the current thread but why the output of the 2nd query? How that would help in this thread?

     

    Aman....

  • 5. Re: Issue running Orace DB
    JohnWatson Guru
    Currently Being Moderated

    Do not worry about people saying that you shouldn't use "home" Windows editions. They are not "certified", which is very different from not "supported". If you run on a certified OS, then Oracle will fix any problems that are operating system related. If you run on an uncertified OS, they won't.

    Home editions are perfectly reliable, I'm using one right now. No one has EVER given an example of a problem caused by running on home Windows. Why not? Because there aren't any.

     

    You can't run those queries, because you can't start your instance. So look at the alert log, it will tell you what is wrong.

  • 6. Re: Issue running Orace DB
    sybrand_b Guru
    Currently Being Moderated

    My experience with running Oracle on Windows Home is different. I experienced problems with sqlnet, and you often see problems with sqlnet posted here.

    Also by design it shouldn't work, as Windows Home doesn't have accounts, and products like dbcontrol require accounts.

    So I consider your assertion there aren't any problems running Oracle as incorrect, and your ridiculing of people who say it doesn't work on Windows Home to be unjustified.

    Also Oracle states everywhere it doesn't run on Windows Home, so why are you contradicting this and ridiculing people who just repeat this message?

     

    ------------

    Sybrand Bakker

    Senior Oracle DBA

  • 7. Re: Issue running Orace DB
    JohnWatson Guru
    Currently Being Moderated

    sybrand_b wrote:

     

    My experience with running Oracle on Windows Home is different. I experienced problems with sqlnet, and you often see problems with sqlnet posted here.

    Also by design it shouldn't work, as Windows Home doesn't have accounts, and products like dbcontrol require accounts.

    So I consider your assertion there aren't any problems running Oracle as incorrect, and your ridiculing of people who say it doesn't work on Windows Home to be unjustified.

    Also Oracle states everywhere it doesn't run on Windows Home, so why are you contradicting this and ridiculing people who just repeat this message?

     

    ------------

    Sybrand Bakker

    Senior Oracle DBA

    Sorry, Sybrand, this is not correct. Home windows does have accounts. And where has Oracle stated that the database does not run on home editions? There is no such statement in the installation guides or the Certify site.

    All Oracle knows is the release of windows. To determine this, run ver (or winver, if you are a GUI person). My Windows is 6.2.9200 which is marketed as Windows 8. The binaries are identical no matter what edition you have. The only difference is legal and some configuration.  That is why no-one has ever found a problem that was caused by home Windows. There are none. I did once hit an issue with the maximum TCP connections, because of a registry setting that had a different default in home editions (dozens rather than hundreds). That is it.

     

    So why am I contradicting you? Because telling people that to run Oracle on Windows one must buy Professional or Ultimate Windows licences is incorrect, unhelpful, and very discouraging to impecunious learners.

     

    Incidentally, you do not need to feel "ridiculed". I have reviewed my post, and I see nothing insulting.

  • 8. Re: Issue running Orace DB
    SomeoneElse Guru
    Currently Being Moderated

    You should go back a few years in these forums when people were trying to install Oracle (probably 10.x) on a Windows XP Home machine.

     

    From the messages I remember it was a roll of the dice.  Some got it to work, with others it was a nightmare and never worked.

     

    I don't know if the Windows 7 line is more compatible regarding Oracle installs but I don't intend to find out.

  • 9. Re: Issue running Orace DB
    JohnWatson Guru
    Currently Being Moderated

    SomeoneElse wrote:

     

    You should go back a few years in these forums when people were trying to install Oracle (probably 10.x) on a Windows XP Home machine.

     

    From the messages I remember it was a roll of the dice.  Some got it to work, with others it was a nightmare and never worked.

     

    I don't know if the Windows 7 line is more compatible regarding Oracle installs but I don't intend to find out.

    You are possibly talking about the problem that forced Oracle to make release 10.2.0.4 (if I remember correctly) available for free download, the only time I know of when a patchset (rather than a base release) has been available without a support contract.. I did think that the problem was Oracle's, not Windows.

    Windows 7 does have two kernel versions: 6.1.7600 is Windows 7 and Windows Server 2008 R2. 6.1.7601 is Windows 7 SP1. The same Oracle binaries run on all editions of all of these.

     

    Of course it is your choice. My choice is not to buy unnecessary Windows licences for the PCs I have kicking around.

  • 10. Re: Issue running Orace DB
    Aman.... Oracle ACE
    Currently Being Moderated

    John,

     

    From time to time, many people post here their issues with using the Home editions of Windows and on the same note, non-certified Linux distros. Yes, may be running Oracle database over a Home edition of Windows probably won't have any issues as that database would be used only for learning-I agree but than any one else reading such thread(s) would also believe the same. The installation guides clearly mention that use the Professional, Enterprise release and the supported distros of Linux (or Unix) only. May be, and it's just a guess of mine only, the other platforms are not so well tested by oracle so if there are going to be any issues, they may not be having much help available for them. The biggest reason to ask people to switch over to a certified platform is this IMHO. If I am asked by someone who is having a laptop running Home edition , I recommend them to install Vbox and within it Linux .

     

    That said, thanks a bunch for the reply. Always a delight to read your reply as almost every time, there is something to learn from it for me.

     

    Regards

    Aman....

  • 11. Re: Issue running Orace DB
    BasuD Newbie
    Currently Being Moderated

    I'm not getting the location of alert.log. Please suggest.

  • 12. Re: Issue running Orace DB
    sunner Newbie
    Currently Being Moderated

    Alert.log For 11gr2 destination is $ORACLE_BASE/diag/rdbms/lower($ORACLE_SID))/Upper($ORACLE_SID)/trace/

  • 13. Re: Issue running Orace DB
    BasuD Newbie
    Currently Being Moderated

    Here are the output of alert.log for today's date-

     

    Sat Oct 12 08:23:11 2013

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_arc3_3896.trc:

    ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 100.00% used, and has 0 remaining bytes available.

    ************************************************************************

    You have following choices to free up space from recovery area:

    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

       then consider changing RMAN ARCHIVELOG DELETION POLICY.

    2. Back up files to tertiary device such as tape using RMAN

       BACKUP RECOVERY AREA command.

    3. Add disk space and increase db_recovery_file_dest_size parameter to

       reflect the new space.

    4. Delete unnecessary files using RMAN DELETE command. If an operating

       system command was used to delete files, then use RMAN CROSSCHECK and

       DELETE EXPIRED commands.

    ************************************************************************

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_arc3_3896.trc:

    ORA-19809: limit exceeded for recovery files

    ORA-19804: cannot reclaim 47238144 bytes disk space from 4102029312 limit

    ARC3: Error 19809 Creating archive log file to 'C:\APP\BASU\FLASH_RECOVERY_AREA\ORCL11G\ARCHIVELOG\2013_10_12\O1_MF_1_842_%U_.ARC'

    ARCH: Archival stopped, error occurred. Will continue retrying

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_arc3_3896.trc:

    ORA-16038: log 2 sequence# 842 cannot be archived

    ORA-19809: limit exceeded for recovery files

    ORA-00312: online log 2 thread 1: 'C:\APP\BASU\ORADATA\ORCL11G\REDO02.LOG'

    Sat Oct 12 08:23:11 2013

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_arc1_3888.trc:

    ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 100.00% used, and has 0 remaining bytes available.

    ************************************************************************

    You have following choices to free up space from recovery area:

    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

       then consider changing RMAN ARCHIVELOG DELETION POLICY.

    2. Back up files to tertiary device such as tape using RMAN

       BACKUP RECOVERY AREA command.

    3. Add disk space and increase db_recovery_file_dest_size parameter to

       reflect the new space.

    4. Delete unnecessary files using RMAN DELETE command. If an operating

       system command was used to delete files, then use RMAN CROSSCHECK and

       DELETE EXPIRED commands.

    ************************************************************************

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_arc1_3888.trc:

    ORA-19809: limit exceeded for recovery files

    ORA-19804: cannot reclaim 8176128 bytes disk space from 4102029312 limit

    ARC1: Error 19809 Creating archive log file to 'C:\APP\BASU\FLASH_RECOVERY_AREA\ORCL11G\ARCHIVELOG\2013_10_12\O1_MF_1_845_%U_.ARC'

    Sat Oct 12 08:23:15 2013

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_ora_3240.trc:

    ORA-19815: WARNING: db_recovery_file_dest_size of 4102029312 bytes is 100.00% used, and has 0 remaining bytes available.

    ************************************************************************

    You have following choices to free up space from recovery area:

    1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

       then consider changing RMAN ARCHIVELOG DELETION POLICY.

    2. Back up files to tertiary device such as tape using RMAN

       BACKUP RECOVERY AREA command.

    3. Add disk space and increase db_recovery_file_dest_size parameter to

       reflect the new space.

    4. Delete unnecessary files using RMAN DELETE command. If an operating

       system command was used to delete files, then use RMAN CROSSCHECK and

       DELETE EXPIRED commands.

    ************************************************************************

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_ora_3240.trc:

    ORA-19809: limit exceeded for recovery files

    ORA-19804: cannot reclaim 47238144 bytes disk space from 4102029312 limit

    ARCH: Error 19809 Creating archive log file to 'C:\APP\BASU\FLASH_RECOVERY_AREA\ORCL11G\ARCHIVELOG\2013_10_12\O1_MF_1_842_%U_.ARC'

    Errors in file c:\app\basu\diag\rdbms\orcl11g\orcl11g\trace\orcl11g_ora_3240.trc:

    ORA-16038: log 2 sequence# 842 cannot be archived

    ORA-19809: limit exceeded for recovery files

    ORA-00312: online log 2 thread 1: 'C:\APP\BASU\ORADATA\ORCL11G\REDO02.LOG'

    USER (ospid: 3240): terminating the instance due to error 16038

    Instance terminated by USER, pid = 3240

     

     

     

    Here is the output from orcl11g_arc3_3896.trc -

     

    ORA-19809: limit exceeded for recovery files

    ORA-19804: cannot reclaim 47238144 bytes disk space from 4102029312 limit

    *** 2013-10-12 08:23:11.727 4132 krsh.c

    ARC3: Error 19809 Creating archive log file to 'C:\APP\BASU\FLASH_RECOVERY_AREA\ORCL11G\ARCHIVELOG\2013_10_12\O1_MF_1_842_%U_.ARC'

    *** 2013-10-12 08:23:11.727 2747 krsi.c

    krsi_dst_fail: dest:1 err:19809 force:0 blast:1

     

     

    *** 2013-10-12 08:23:12.182

    DDE rules only execution for: ORA 312

    ----- START Event Driven Actions Dump ----

    ---- END Event Driven Actions Dump ----

    ----- START DDE Actions Dump -----

    Executing SYNC actions

    ----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----

    Successfully dispatched

    ----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----

    Executing ASYNC actions

    ----- END DDE Actions Dump (total 0 csec) -----

    *** 2013-10-12 08:23:12.258 4529 kcrr.c

    ORA-16038: log 2 sequence# 842 cannot be archived

    ORA-19809: limit exceeded for recovery files

    ORA-00312: online log 2 thread 1: 'C:\APP\BASU\ORADATA\ORCL11G\REDO02.LOG'

     

     

     

    Please suggest how can I resume working on the database... for learning purpose only.

    Thanks in advance..!

  • 14. Re: Issue running Orace DB
    user12075536123 Pro
    Currently Being Moderated

    How about testing the following?


    #sqlplus
    startup nomount
    alter system set db_recovery_file_dest_size=5G scope=spfile;
    shutdown immediate
    startup

1 2 Previous Next

Legend

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