Error installing Oracle10g on XP

Hello,

I'm receiving an error in the Oracle install program that I'm seeking help for. The install program gets to the Configuration Assisstants window and completes the Oracle Net Configuration Assistant and iSQL*Plus Configuration Assistant successfully, but during the progress of the Oracle Database Configuration Assistant, another window pops up with a progress bar, and when this progress bar hits 2%, I receive an error message stating "ORA-12638 Credential Retrieval Failed."

If I keep clicking the Ignore button for this error msg, the progress bar keeps moving and I can get it to 100%. But when it reaches 100%, I receive the following msg: "Enterprise manager configuration failed due to the following error- 'job_queue_processes' must be greater or equal to 1. Fix the error(s) and run EM Configuration Assistant again in standalone mode. You can retry configuring this database with Enterprise Manager later by manually running c:\oracle\product\10.1.0\Db_4\bin\emca script.

First, why would I get the original ORA-12638 error during this install? Second, how do I set job_queue_processes equal to 1? Third, how would I start the EM Configuration Assistant in standalone mode?

I have a Symantic firewall, but I turned it off prior to starting the installation.

Thanks for your help.

Have you actually tried looking at metalink for the original error? Suggest you fix that before worrying about subsequent errors that may be related.

Its a fairly common error, to start you off, look at notes 185897.1 and 334002.1

Bazza

Check your sqlnet.ora. I faced a similar issue when SQLNET.AUTHENTICATION_SERVICES= (NTS). Change this to SQLNET.AUTHENTICATION_SERVICES= (NONE) and create your database afresh. It will succeed.

HTH.

ggnanaraj, the solution you give is correct, its in the second metalink note I quoted. I was however trying to encourage Alan to use metalink which is what it is there for, and help him to solve the issue of his own violition.

Regards,
Bazza

What is metalink?

"Check your sqlnet.ora. I faced a similar issue when SQLNET.AUTHENTICATION_SERVICES= (NTS). Change this to SQLNET.AUTHENTICATION_SERVICES= (NONE) and create your database afresh. It will succeed."

I actually found this doing searches on other msg boards and tried it, and it resolved the original ORA-12638 error, but it led to a host of additional error messages as the installation finished.

So, despite these error messages, I finished the installation of Oracle10g on XP Pro and created a database called cassure. When I attempt to logon with system/manager1@cassure, I get the following error msg: ORA-12500: TNS:listener failed to start a dedicated server process.

Here is my listener.ora file:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_4)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = C:\oracle\product\10.1.0\Db_4)
(SID_NAME = orcl101)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = alanv)(PORT = 1521))
)
)
)

All paths are correct. When I try to start the listener in command prompt, I get the following messages:

TNS-12560: TNS:protocol adapter error
TNS-00530: protocol adapter error
32-bit windows error: 1056: unknown error

I've also tried to launch Enterprise Mgr and logon to this database, but am getting vague error messages (no ORA or TNS numbers).

This is my sqlnet.ora file:

# sqlnet.ora Network Configuration File: C:\oracle\product\10.1.0\Db_4\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

This is my tnsnames.ora file:

# tnsnames.ora Network Configuration File: C:\oracle\_products_\10.1.0\Db_4\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

CASSURE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Alanv)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cassure)
)
)

ORCL101 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Alanv)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl101)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

how are you trying to start the listener? what is the status of your listener ?
c:\> lsnrctl status

In your listener file, you have an entry for orcl101. you may want to add an entry for your cassure database. But before that, try to get your listener up and running.

Thomas, thanks for you help. I did make a change in my listener.ora file to include cassure as the SID (see below). When I run
lsnrctl status
I get the following error msg:
TNS-12560 TNS:protocol adpater error
TNS-00530 protocol adpater error
32-bit windows error: 2 no such file or directory

I also found on another message board this advice and applied it to my pc (to no avail):

Try setting the TNS_ADMIN entry in your windows registry and give appropriate value.
To add this entry perform the following actions.
Click on Start -> Run then press Enter the type regedit.
Add the TNS_ADMIN environment variable to the HKEY_LOCAL_MACHINE\Software\Oracle\Home key by right mouse clicking, then selecting New -> Key -> String Value.
I think your network files are on
E:\oracle\product\10.1.0\db_1\network\admin
(Verify if thats the correct path of your listener.ora, sqlnet.ora etc) and assign the above mentioned path as value for TNS_ADMIN in registry.
Then open a command prompt and type this
E:\oracle\product\10.1.0\db_1\bin\lsnrctl start (press enter)

lets keep it simple

lsnrctl stop
lsnrctl start

what does that give

lsnrctl stop:
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
32-bit Windows Error: 2: No such file or directory

lsnrctl status:
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Alanv)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

lsnrctl start:
Failed to start service, error 3.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 3: No such process

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.

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.

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.

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.

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

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?

So, were you able to start the listener and connect to the database?

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?

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.

Quote:

---

Originally Posted by msdba1

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.

---

and what if you have an spfile???