Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle DB 11.2.0.4 installtion in windows 7 64 bit ERROR : TNS PROTOCOL ERROR

user9542546Feb 26 2015 — edited Feb 28 2015

Hi

  I installed Oracle database on my local machine windows7 64 bit succesfully except net confiuration.

FYI :

single instance

database install and config

i has cleaned up the previous oracle installs before re-installation.

Now i am currently able to access the database from sqlplus but when i start lsnrctl start throwing an error tns protocol error.

I did tried with net configuration with several ports but still not able to showup the tnslistener service on window services.

Only i could see in the windows services are

Oracle ORCL VSS Writer Service  --- started

Oracle jobschedulerORCL  --- started

OracleMTSRecoveryService  --- started

OracleOraDb11g_home1ClrAgent   ---    Not started

OracleServiceORCL   --- started

but no tnslisterner service in windows services list.

I followed oracle forums and applied all the instructions like adding entry into hosts file , drop/recreate listeners etc..

My log file :

main] [ 2015-02-26 13:15:20.603 CST ] [InitialSetup.<init>:4071]  Admin location is: C:\app\\mymachine\product\11.2.0\dbhome_1\network\admin

[main] [ 2015-02-26 13:15:20.653 CST ] [ConfigureProfile.setProfileParam:136]  Setting NAMES.DIRECTORY_PATH: (TNSNAMES, EZCONNECT)

[main] [ 2015-02-26 13:15:20.653 CST ] [ConfigureProfile.setProfileParam:136]  Setting SQLNET.AUTHENTICATION_SERVICES: (NTS)

[main] [ 2015-02-26 13:15:20.653 CST ] [ConfigureProfile.setDefaultProfileParams:109]  Not setting ADR_BASE: sqlnet.ora already exist!

[main] [ 2015-02-26 13:15:20.663 CST ] [HAUtils.getCurrentOracleHome:368]  Oracle home from system property: C:\app\\mymachine\product\11.2.0\dbhome_1

[main] [ 2015-02-26 13:15:20.663 CST ] [GETCRSHOMEUtil.<init>:90]  Toolname: getcrshome.exe   ---    Tool location: C:\app\\mymachine\product\11.2.0\dbhome_1\binTool dependencies: [Ljava.lang.String;@26b4e29b

[main] [ 2015-02-26 13:15:20.663 CST ] [RuntimeExec.runCommand:75]  Calling Runtime.exec() with the command

[main] [ 2015-02-26 13:15:20.663 CST ] [RuntimeExec.runCommand:77]  C:\app\mymachine\product\11.2.0\dbhome_1\bin\getcrshome.exe

[main] [ 2015-02-26 13:15:20.683 CST ] [RuntimeExec.runCommand:142]  runCommand: Waiting for the process

[Thread-2] [ 2015-02-26 13:15:20.683 CST ] [StreamReader.run:61]  In StreamReader.run

[Thread-1] [ 2015-02-26 13:15:20.683 CST ] [StreamReader.run:61]  In StreamReader.run

[main] [ 2015-02-26 13:15:20.723 CST ] [RuntimeExec.runCommand:144]  runCommand: process returns 1

[main] [ 2015-02-26 13:15:20.723 CST ] [RuntimeExec.runCommand:161]  RunTimeExec: output>

[main] [ 2015-02-26 13:15:20.723 CST ] [RuntimeExec.runCommand:170]  RunTimeExec: error>

[main] [ 2015-02-26 13:15:20.723 CST ] [RuntimeExec.runCommand:192]  Returning from RunTimeExec.runCommand

[main] [ 2015-02-26 13:15:20.723 CST ] [CmdToolUtil.executeLocally:529]  Failed to execute command. Command = [C:\app\mymachine\product\11.2.0\dbhome_1\bin\getcrshome.exe] env = null error = []

[main] [ 2015-02-26 13:15:20.733 CST ] [HAUtils.getHASHome:940]  Failed to get HAS home.

PRCT-1011 : Failed to run "getcrshome.exe". Detailed error: []

oracle.cluster.deployment.ClusterwareInfo.getConfiguredCRSHome(ClusterwareInfo.java:486)

oracle.sysman.assistants.util.hasi.HAUtils.getConfiguredGridHome(HAUtils.java:784)

oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:936)

oracle.sysman.assistants.util.hasi.HAUtils.getHASHome(HAUtils.java:957)

oracle.sysman.assistants.util.hasi.HAUtils.isHASConfigured(HAUtils.java:531)

oracle.net.ca.InitialSetup.checkHAConfiguration(NetCA.java:4689)

oracle.net.ca.InitialSetup.<init>(NetCA.java:4105)

oracle.net.ca.NetCA.main(NetCA.java:428)

[main] [ 2015-02-26 13:15:20.733 CST ] [HAUtils.isHASConfigured:534]  HA Home is null

[main] [ 2015-02-26 13:15:20.733 CST ] [InitialSetup.checkHAConfiguration:4728]  HA Server is NOT configured.

[main] [ 2015-02-26 13:15:20.733 CST ] [NetCAResponseFile.<init>:68]  Response file initialized: C:\app\\mymachine\product\11.2.0\dbhome_1\network\install\netca_typ.rsp

[main] [ 2015-02-26 13:15:20.733 CST ] [NetCAResponseFile.getInstalledComponents:107]  Installed components from response file: server, net8, javavm

[main] [ 2015-02-26 13:15:20.733 CST ] [NetCAResponseFile.getVirtualHost:164]  Virtual Host from response file: null

[main] [ 2015-02-26 13:15:20.733 CST ] [SilentConfigure.performSilentConfigure:174]  Typical profile configuration.

[main] [ 2015-02-26 13:15:20.743 CST ] [ConfigureProfile.setProfileParam:136]  Setting NAMES.DIRECTORY_PATH: (TNSNAMES, EZCONNECT)

[main] [ 2015-02-26 13:15:20.743 CST ] [ConfigureProfile.setProfileParam:136]  Setting SQLNET.AUTHENTICATION_SERVICES: (NTS)

[main] [ 2015-02-26 13:15:20.743 CST ] [ConfigureProfile.setDefaultProfileParams:109]  Not setting ADR_BASE: sqlnet.ora already exist!

[main] [ 2015-02-26 13:15:20.743 CST ] [SilentConfigure.performSilentConfigure:182]  Typical listener configuration.

[main] [ 2015-02-26 13:15:20.743 CST ] [ConfigureListener.isHASConfigured:1513]  Calling SRVM api to check if Oracle Restart is configured ...

[main] [ 2015-02-26 13:15:20.743 CST ] [HAUtils.getCurrentOracleHome:368]  Oracle home from system property: C:\app\\mymachine\product\11.2.0\dbhome_1

[main] [ 2015-02-26 13:15:20.743 CST ] [GETCRSHOMEUtil.<init>:90]  Toolname: getcrshome.exe   ---    Tool location: C:\app\\mymachine\product\11.2.0\dbhome_1\binTool dependencies: [Ljava.lang.String;@26b4e29b

[main] [ 2015-02-26 13:15:20.743 CST ] [RuntimeExec.runCommand:75]  Calling Runtime.exec() with the command

[main] [ 2015-02-26 13:15:20.743 CST ] [RuntimeExec.runCommand:77]  C:\app\\mymachine\product\11.2.0\dbhome_1\bin\getcrshome.exe

[Thread-4] [ 2015-02-26 13:15:20.753 CST ] [StreamReader.run:61]  In StreamReader.run

[main] [ 2015-02-26 13:15:20.753 CST ] [RuntimeExec.runCommand:142]  runCommand: Waiting for the process

[Thread-3] [ 2015-02-26 13:15:20.753 CST ] [StreamReader.run:61]  In StreamReader.run

[main] [ 2015-02-26 13:15:20.813 CST ] [RuntimeExec.runCommand:144]  runCommand: process returns 1

[main] [ 2015-02-26 13:15:20.813 CST ] [RuntimeExec.runCommand:161]  RunTimeExec: output>

[main] [ 2015-02-26 13:15:20.813 CST ] [RuntimeExec.runCommand:170]  RunTimeExec: error>

[main] [ 2015-02-26 13:15:20.813 CST ] [RuntimeExec.runCommand:192]  Returning from RunTimeExec.runCommand

Appreciate your advice.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2015
Added on Feb 26 2015
4 comments
1,858 views