How do I resolve a TNS:protocol adaptor error after an automated Oracle 11g installation?

experts,

      I cannot connect to the database after an automated Oracle 11g installation. I am getting an TNS protocol error. I do not see a TNSnames.ora file under my oracle home app\admin\product\11.1.0\db_1\NETWORK\ADMIN.

Is there something in my automated install that did not create this file?
missymadiAsked:
Who is Participating?
 
schwertnerConnect With a Mentor Commented:

http://youngcow.net/doc/oracle10g/install.102/b19075/app_nonint.htm

You can run NetCA in silent mode to configure and start an Oracle Net listener on the system, configure naming methods, and configure Oracle Net service names. To run NetCA in silent mode, you must copy and edit a response file template. Oracle provides a response file template named netca.resp in the response directory in the db/response directory on the DVD.


You can run Database Configuration Assistant in noninteractive or silent mode to configure and start an Oracle Database on your system. To run Database Configuration Assistant in noninteractive or silent mode, you must copy and edit a response file template. Oracle provides a response file template named dbca.resp in the db/response directory on the DVD.


This is for 10g, but possibly it is applicable for 11g

0
 
logictankCommented:
Is your local environment setup correctly after automated install:

%ORACLE_HOME%
%TNS_ADMIN%
%ORACLE_SID%
etc...

Also check your installation logs to validate that the automated installation completed successfully.  The installation logs should be under your Oracle\Inventory\logs directory or if the log directory was specified duing the automated install check there.  If you're %ORACLE_HOME\NETWORK\ADMIN files are missing you can run the Network Configuration Assistant to recreate the Listener/Tnsames files.
Once these are setup correctly verify that you can tnsping your instance and then try connecting with the service name:
sqlplus@ORCL

If you're still having problems verify that the settings in your response file were/are correct.
0
 
slightwv (䄆 Netminder) Commented:
Check the status of your listener.  From a command prompt: lsnrctl status

What OS and How are you trying to connect?

If windows and you are trying 'as sysdba', the service might not be running.

>>Is there something in my automated install that did not create this file?

Depends on what you mean by automated install.

0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
schwertnerCommented:
If you are on Windows start the Oracle Services:
Listener
Oracleservice<yourSID>SID

As Administrator of the machine.
Also the installation of Oracle should be done as Administrator.

If this is Unix:

% lsnrctl start

and to tray to start the instance over SQl*Plus

You need to do this as Oracle user.


If you need remote access do static registration:

Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Ora10g)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
  )

Add the entry
    (SID_DESC =
      (SID_NAME = test)
      (ORACLE_HOME = D:\Ora10g)
    )
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start
0
 
missymadiAuthor Commented:
I looked at my oraInstall log file, here are the errors I received.

Setup was successful
Configuration assistant "oracle net config. assistant" succeeded
Configuration assistant "Oracle database config. assistant" failed
SEvere:OUI:Some of the configuration assistants failed/were cancelled.

How do I get them to run successfully with the automation process. I need this to run without errors or the higher ups will not be pleased with a failed peer review on a bad Oracle install.
I have added the response file I am using for the automated Oracle install. This is a .rsp file but I had to change it to a .txt for the file to upload.
Thanks for your help! MissyMadi
Ora11g.txt
0
 
logictankCommented:
We need to find the extended errors from the Configuration assistant that failed:
 'Configuration assistant "Oracle database config. assistant" failed'

you should be able to find these logs under:
 %ORACLE_HOME\cfgtoollogs
See if you can find the error that relates to the failed assistant.
0
 
missymadiAuthor Commented:
Here are the issues I encountered - file attached.
Something about an unrecognized prompt  - not sure  how to fix?
oracle.assistants.server-2010-01.log
0
 
logictankCommented:
What version of Windows are you running for this installation?
0
 
missymadiAuthor Commented:
I think I found the problem. We have one of those crazy passwords that has a special charactor in it , I forgot to put " " around it. I'm thinking this is the problem because the error said unrecognized prompt. I am going to uninstall Oracle once again and re-install. I will post my outcome.
Thanks for all your help!
0
 
missymadiAuthor Commented:
I tried to reinstall Oracle with the response file but the oracle.assistant.server failed. The error is the same where unrecognized prompt is(see read vs write) ANy ideas?

Thanks Missymadi
0
 
logictankCommented:
You're not running Windows 2008 Server by chance?  Also have you tried to run the Database Configuration Assistant manaully to see if it works or gives any further error message?
0
 
missymadiAuthor Commented:
This is Windows server 2003. Oracle 11g. If I run throught the whole installation manually everything works great. When I try to install with the answer file the oracle.assistant.server is failing. The only error I see is that an unknown prompt is causing an error and the config. assistant stops.  
0
 
schwertnerCommented:
Even by manual installation you will run into a non registered by the Listener instance
as mentioned in ID:26210917
0
 
missymadiAuthor Commented:
Schwertner - Yes, I know the non-registered by listener well. You have helped me numerous times on other installs. However - this manual install on my VM works like a charm - everytime. But not with the answer file.
I'm wondering if I need to run another script , dbca with answer file, to configure the database. Or does the installation of standard.rsp include the last part of the dbca to run configuration? Have you ever automated Oracle 11g?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.