[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 956
  • Last Modified:

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?
0
missymadi
Asked:
missymadi
  • 6
  • 4
  • 3
  • +1
1 Solution
 
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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
 
schwertnerCommented:

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 6
  • 4
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now