DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21

Thread: Error installing Oracle10g on XP

  1. #11
    Join Date
    Dec 2005
    Posts
    39
    lsnrctl start:
    Failed to start service, error 3.
    TNS-12560: TNSrotocol adapter error
    TNS-00530: Protocol adapter error
    32-bit Windows Error: 3: No such process

  2. #12
    Join Date
    Dec 2005
    Posts
    39
    Based on some research, it is possible that we need Oracle patch 10.1.0.5. Does anyone know where I could find more info about this patch? I found out that we would need to have a valid support contract with oracle to download patches, and I'm in the process of finding out if we have one. I found Metalink and saw a list of patches, but the page that I was on did not provide links that led to info about what each patch was for.

  3. #13
    Join Date
    Dec 2005
    Posts
    39
    This is not as simple as a couple people earlier in this thread indicated when they suggested changing
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    to
    SQLNET.AUTHENTICATION_SERVICES= (NONE)
    in the sqlnet.ora file.

    I tried starting from scratch and re-installed Oracle. I once again received the ORA-12638 Credential Retrieval Failed error message during the Configuration Assistant creation phase. (Of course, this was SUPPOSED to be a COMMON error msg as someone mentioned earlier, but were they able to help me solve it? No.)

    If you edit the sqlnet.ora file at this point and change SQLNET.AUTHENTICATION_SERVICES= (NTS)
    to
    SQLNET.AUTHENTICATION_SERVICES= (NONE)
    you run into a number of additonal error messages, including Oracle not available, database not mounted, shared memory realm does not exist, create control file failed, error in identifying .dbf files, and Enterprise Manager configuration failed.

    I tried this and after it did not work, I started over. This time when I received the ORA-12638 Credential Retrieval Failed error message during the Configuration Assistant creation phase, I kept clicking the Ignore button until the installation finished.

    THEN I changed
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    to
    SQLNET.AUTHENTICATION_SERVICES= (NONE)
    in the sqlnet.ora file.

    After I did this and tried to logon to SQL*Plus, I received ORA-01034: Oracle not available and ORA-27101: shared memory realm does not exist.

    So I tried what others earlier in this thread had suggested, to no avail.

    So you see, it's not as simple as those who commented earlier in this thread and were being sarcastic in their replies have made it out to be. Of course, they've bailed out from providing help a long time ago. If anyone else has the knowledge to help me with this, I would appreciate it. Thanks.

  4. #14
    Join Date
    Dec 2005
    Posts
    39
    After investigating, I discovered that the oradata\orcl101 folder, where the database, logs, and control files, etc, should have been created, is empty. My SID is orcl101, I'm on XP Pro, and this is 10g. The DB Configuration Asst will not let me try to create these files from it because if I choose Create a Database, it won't let me use a duplicate SID. If I choose Configure Database Options and try to sign on as system, I get ORA-1031 Insufficient Options, if I try to sign on as sys, I get ORA-01078 failure in processing system parameters.

    Does anyone know how I can create the files that should have been created in oradata\orcl101 manually?

    For now, I will try to create a db with a different SID.

  5. #15
    Join Date
    Dec 2005
    Posts
    39
    Since the default orcl101 db was not successfully created during the installation, DB Config Asst let me delete it and re-create it. During this re-creation, it let me logon as sys and the db creation was successful.

    Then I was able to logon onto it in SQL*Plus. When you re-create the default orcl101 db, you have to be sure to change the passwords for system and sys when that screen comes up or you won't be able to logon to it.

  6. #16
    Join Date
    Jul 2002
    Posts
    335
    Ok, so what is your state of play now? And it is a common error, I was trying to nudge you to look in the right place.

    Bazza

  7. #17
    Join Date
    Dec 2005
    Posts
    39
    My state right now is Enterprise Mgr was not successfully created and I think I know which script to run (emca) to create it and I've tried running it, but it was unsuccessful and states to run it in stand alone mode and I'm not sure what that is. What is stand alone mode?

  8. #18
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    So, were you able to start the listener and connect to the database?
    thomasp

  9. #19
    Join Date
    Dec 2005
    Posts
    39
    Yes, I was able to start the listener and connect to the database. I described this in message 15. I'm hoping someone can now help me with the following:

    My state right now is Enterprise Mgr was not successfully created and I think I know which script to run (emca) to create it and I've tried running it, but it was unsuccessful and states to run it in stand alone mode and I'm not sure what that is. What does it mean to run the emca script in stand alone mode?

  10. #20
    Join Date
    Apr 2006
    Posts
    1
    In order to set job_queue_processes, please go to location where you had installed oracle. There will be one admin folder with pfile folder in it. open init.ora file and either modify the above parameter or add new line with value, say 5. and then restart the database.

Posting Permissions

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


Click Here to Expand Forum to Full Width