No Listener found for the Oracle Database after in...

Hi,

After installing the Oracle 11.2.03 and NW 7.3 AS Java as per SAP Install guide, When I try to check saplikey -show I get error "Could not connect to DB".

When I check the Oracle Net Manager installed along with Oracle Installation I find no entry for Listener.

/nwa is also not opening - Error: 500 Internal Server error: Error Application error occurred during the request processing.

Apart from http://localhost:50000/StartPage no other pages are opening.

Should I create a Listener Manually?

Could not even login to Oracle DB via SqlPlus Error: ORA-12543: TNS: destination host unreachable.

Both my SQLPlus and DB server is in SAME Host, I don't understand why it say destination host unreachable?

Please help on this I tries both Oracle Support and SAP Support but of no use...

SAP Managed Tags:
NW AS Java Administrator (NWA)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (4)

pls attach

dev_jstart

dev_jcmon

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

---------------------------------------------------

trc file: "dev_jstart.5336", trc level: 1, release: "720"

---------------------------------------------------

trc file: "dev_jstart.new", trc level: 1, release: "720"

---------------------------------------------------

sysno 00

sid TCN

systemid 562 (PC with Windows NT)

relno 7200

patchlevel 0

patchno 63

intno 20020600

make multithreaded, Unicode, 64 bit, optimized

profile \\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

pid 5336

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS All, egi

Sun Nov 11 15:16:38 2012

* trace logging activated, max size = 52428800 bytes, 2 versions

arguments :

arg[ 0] : C:\usr\sap\TCN\J00\exe\jstart.EXE

arg[ 1] : pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

F Sun Nov 11 15:16:38 2012

F ********************************************************************************

F Java environment properties (C:\usr\sap\TCN\J00\work\jstart.jvm)

F root directory : C:\usr\sap\TCN\J00\exe\sapjvm_6

F vendor : SAP AG

F version : 1.6.0_17

F cpu : amd64

F java vm type : server

F java vm version : 6.1.018

F jvm library name : jvm.dll

F library path : C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin\server;C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin

F executable path : C:\usr\sap\TCN\J00\exe\sapjvm_6\bin

F ********************************************************************************

F SAP extensions : available

F ********************************************************************************

I [Thr 6668] MtxInit: 30002 0 2

---------------------------------------------------

trc file: "dev_jstart", trc level: 1, release: "720"

---------------------------------------------------

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS All, egi

F [Thr 6668] *** LOG => connected to Enqueue Server.

F [Thr 6668] *** LOG => connected to Message Server.

F [Thr 6668] *** LOG => Starting run level 1.

F ********************************************************************************

F Java process [deployment] properties:

F section name : deployment

F config file : C:\usr\sap\TCN\J00\exe\startup.properties

F node name : Deploy_offline

F home directory : C:\usr\sap\TCN\J00\j2ee\cluster

F shutdown timeout : 136000 ms

F exit timeout : 7000 ms

F debuggable : false

F debugger active : false

F ********************************************************************************

F [Thr 6668] *** LOG => Instance state is "Deploying offline components" (STARTING @ 0, INACTIVE).

F [Thr 6668] *** LOG => Starting nodes: runlevel 1.

F ********************************************************************************

F Starting process: C:\usr\sap\TCN\J00\exe\jstart.EXE

F arg[ 1] = -nodeId=0

F arg[ 2] = pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

F arg[ 3] = -hostvm

F arg[ 4] = -nodeName=deployment

F arg[ 5] = -file=C:\usr\sap\TCN\J00\exe\startup.properties

F arg[ 6] = -jvmFile=C:\usr\sap\TCN\J00\work\jstart.jvm

F arg[ 7] = -traceFile=C:\usr\sap\TCN\J00\work\dev_deployment

F arg[ 8] = -javaOutFile=C:\usr\sap\TCN\J00\work\jvm_deployment.out

F env : NODNSSAPTRANSHOST=1

F exePath : PATH=C:\usr\sap\TCN\J00\exe\sapjvm_6\bin;C:\usr\sap\TCN\J00\exe;D:\oracle\TDB\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\idmu\common;C:\Windows\System32\WindowsPowerShell\v1.0;C:\usr\sap\TCN\SYS\exe\uc\NTAMD64

F libPath : PATH=C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin\server;C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin;C:\usr\sap\TCN\J00\j2ee\os_libs;C:\usr\sap\TCN\J00\exe\sapjvm_6\bin;C:\usr\sap\TCN\J00\exe;D:\oracle\TDB\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\idmu\common;C:\Windows\System32\WindowsPowerShell\v1.0;C:\usr\sap\TCN\SYS\exe\uc\NTAMD64

F stdout : C:\usr\sap\TCN\J00\work\std_deployment.out

F stderr : C:\usr\sap\TCN\J00\work\std_deployment.out

F console : no

F debugger: no

F nice : no

F ********************************************************************************

F Process Deploy_offline started with pid 480

F ********************************************************************************

F [Thr 6668] *** LOG => Process deployment started (pid 480).

F [Thr 6668] Sun Nov 11 15:16:40 2012

F [Thr 6668] *** LOG => Process deployment stopping (pid 480).

F [Thr 6228] Sun Nov 11 15:16:40 2012

F [Thr 6228] *** LOG => Signal 13 SIGCHLD.

F [Thr 6668] *** LOG => Process deployment stopped (pid 480).

F [Thr 6668] *** LOG => Instance state is "Deploying offline components" (STOPPING @ 0, INACTIVE).

F [Thr 6668] *** LOG => Run level 1 completed.

F [Thr 6668] *** LOG => Starting run level 2.

F ********************************************************************************

F Java process [bootstrap] properties:

F section name : bootstrap

F config file : C:\usr\sap\TCN\J00\exe\startup.properties

F node name : Instance_bootstrap

F home directory : C:\usr\sap\TCN\J00\j2ee\cluster

F shutdown timeout : 136000 ms

F exit timeout : 7000 ms

F debuggable : false

F debugger active : false

F ********************************************************************************

F [Thr 6668] *** LOG => Instance state is "Synchronizing binaries" (STARTING @ 0, INACTIVE).

F [Thr 6668] *** LOG => Starting nodes: runlevel 2.

F ********************************************************************************

F Starting process: C:\usr\sap\TCN\J00\exe\jstart.EXE

F arg[ 1] = -nodeId=0

F arg[ 2] = pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

F arg[ 3] = -hostvm

F arg[ 4] = -nodeName=bootstrap

F arg[ 5] = -file=C:\usr\sap\TCN\J00\exe\startup.properties

F arg[ 6] = -jvmFile=C:\usr\sap\TCN\J00\work\jstart.jvm

F arg[ 7] = -traceFile=C:\usr\sap\TCN\J00\work\dev_bootstrap

F arg[ 8] = -javaOutFile=C:\usr\sap\TCN\J00\work\jvm_bootstrap.out

F env : NODNSSAPTRANSHOST=1

F stdout : C:\usr\sap\TCN\J00\work\std_bootstrap.out

F stderr : C:\usr\sap\TCN\J00\work\std_bootstrap.out

F console : no

F debugger: no

F nice : no

F ********************************************************************************

F Process Instance_bootstrap started with pid 7068

F ********************************************************************************

F [Thr 6668] *** LOG => Process bootstrap started (pid 7068).

F [Thr 6668] Sun Nov 11 15:16:44 2012

F [Thr 6668] *** LOG => Process bootstrap running (pid 7068).

F [Thr 6668] *** LOG => Instance state is "Synchronizing binaries" (RUNNING @ 0, INACTIVE).

F [Thr 6668] Sun Nov 11 15:16:46 2012

F [Thr 6668] *** LOG => Process bootstrap stopping (pid 7068).

F [Thr 4436] Sun Nov 11 15:16:46 2012

F [Thr 4436] *** LOG => Signal 13 SIGCHLD.

F [Thr 6668] *** LOG => Process bootstrap stopped (pid 7068).

F [Thr 6668] *** LOG => Instance state is "Synchronizing binaries" (STOPPING @ 0, INACTIVE).

F [Thr 6668] *** LOG => Run level 2 completed.

F [Thr 6668] *** LOG => Starting run level 3.

F ********************************************************************************

F Java process [debugproxy] properties:

F section name : debugproxy

F config file : C:\usr\sap\TCN\J00\exe\dproxy.properties

F node name : Debug_Proxy

F home directory : C:\usr\sap\TCN\J00/j2ee/rdbg.proxy

F shutdown timeout : 136000 ms

F exit timeout : 7000 ms

F debuggable : false

F debugger active : false

F ********************************************************************************

F ICM process [icm] properties:

F section name : icm

F config file : C:\usr\sap\TCN\J00\exe\icm.properties

F node name : ICM

F home directory : C:\usr\sap\TCN\J00\work

F shutdown timeout : 122000 ms

F exit timeout : 7000 ms

F ********************************************************************************

F Java process [server0] properties:

F section name : ID8295850

F config file : C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties

F node name : server0

F home directory : .

F shutdown timeout : 136000 ms

F exit timeout : 7000 ms

F debuggable : true

F debugger active : false

F ********************************************************************************

F [Thr 6668] *** LOG => Instance state is "Starting the processes" (STARTING @ 0, INACTIVE).

F [Thr 6668] *** LOG => Starting nodes: runlevel 3, phase 0.

F ********************************************************************************

F Starting process: C:\usr\sap\TCN\J00\exe\icman.EXE

F arg[ 1] = pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

F arg[ 2] = -nodeId=1

F arg[ 3] = -f

F arg[ 4] = C:\usr\sap\TCN\J00\work\\dev_icm

F env : NODNSSAPTRANSHOST=1

F exePath : PATH=C:\usr\sap\TCN\J00\exe;D:\oracle\TDB\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\idmu\common;C:\Windows\System32\WindowsPowerShell\v1.0;C:\usr\sap\TCN\SYS\exe\uc\NTAMD64

F libPath : PATH=C:\usr\sap\TCN\J00\exe;D:\oracle\TDB\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\idmu\common;C:\Windows\System32\WindowsPowerShell\v1.0;C:\usr\sap\TCN\SYS\exe\uc\NTAMD64

F stdout : C:\usr\sap\TCN\J00\work\std_icm.out

F stderr : C:\usr\sap\TCN\J00\work\std_icm.out

F console : no

F debugger: no

F nice : no

F ********************************************************************************

F Process ICM started with pid 3348

F ********************************************************************************

F [Thr 6668] *** LOG => Process icm started (pid 3348).

F [Thr 6668] Sun Nov 11 15:16:47 2012

F [Thr 6668] *** LOG => Process icm running (pid 3348).

F [Thr 6668] *** LOG => Starting nodes: runlevel 3, phase 1.

F ********************************************************************************

F Starting process: C:\usr\sap\TCN\J00\exe\jstart.EXE

F arg[ 1] = -nodeId=2

F arg[ 2] = pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

F arg[ 3] = -DSAPINFO=TCN_00_server0

F arg[ 4] = -hostvm

F arg[ 5] = -nodeName=ID8295850

F arg[ 6] = -file=C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties

F arg[ 7] = -jvmFile=C:\usr\sap\TCN\J00\work\jstart.jvm

F arg[ 8] = -traceFile=C:\usr\sap\TCN\J00\work\dev_server0

F arg[ 9] = -javaOutFile=C:\usr\sap\TCN\J00\work\jvm_server0.out

F env : NODNSSAPTRANSHOST=1

F stdout : C:\usr\sap\TCN\J00\work\std_server0.out

F stderr : C:\usr\sap\TCN\J00\work\std_server0.out

F console : no

F debugger: no

F nice : no

F ********************************************************************************

F Process server0 started with pid 6564

F ********************************************************************************

F [Thr 6668] *** LOG => Process server0 started (pid 6564).

F [Thr 6668] Sun Nov 11 15:17:30 2012

F [Thr 6668] *** LOG => Process server0 running (pid 6564).

F [Thr 6668] *** LOG => Instance state is "All processes running" (RUNNING @ 1, ACTIVE).

---------------------------------------------------

trc file: "dev_jcmon", trc level: 1, release: "720"

---------------------------------------------------

node name : jcmon

pid : 5844

system name : TCN

system nr. : 00

started at : Sun Nov 11 13:38:23 2012

arguments :

arg[00] : jcmon

arg[01] : pf=C:\usr\sap\TCN\SYS\profile\TCN_J00_TCNTAS

**********************************************************************

Used property files

-> files [00] : C:\usr\sap\TCN\J00\exe\icm.properties

-> files [01] : C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties

**********************************************************************

Bootstrap nodes

**********************************************************************

Worker nodes

-> [00] icm : C:\usr\sap\TCN\J00\exe\icm.properties

-> [01] ID8295850 : C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties

**********************************************************************

JStartupReadInstanceProperties: read instance properties [C:\usr\sap\TCN\J00\exe\icm.properties;C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties]

-> ms host : TCNTAS

-> ms port : 3901

-> OS libs : C:\usr\sap\TCN\J00\j2ee\os_libs

-> Admin URL :

-> run mode : NORMAL

-> run action : NONE

-> enabled : yes

**********************************************************************

[Thr 5848] Sun Nov 11 13:38:41 2012

[Thr 5848] *** ERROR => Can't attach to administration shared memory (rc = 3) [jcmonxx.c 228]

try out this

stop the j2ee instance
go to C:\usr\sap\TCN\J00\j2ee\os_libs
type command
- jcontrol pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS -c
restart j2ee instance.

this mite help out as error is /////////////////

ERROR => Can't attach to administration shared memory (rc = 3) [jcmonxx.c

228]

////////////////

Thanks for all,

Nikhil now the problem is solved by starting the *nwa* services from MMC

and the browser should be viewed in compatibility mode.

Now the /nwa is working but the rest of the issues may not be solved but for our case these services are more than enough to proceed.

Thanks a lot.

My problem is after installation of NW 7.3 AS Java J2EE 7.20,

in MMC I get the following Current Alerts

under Operating Sytem -> Memory -> Free -4%

and under Services -> Keystore -> System Entries : At least one entry has expired

DaysToExpire: -1 day

Its a new installation, I don't think it requires key for next 3 months.

All over problem is in MMC Instance shows : All Processes Running but we cannot open /nwa page.

We have not used any Solution manager nor SLD configured.

Is this a problem, won't the fresh unpatched installation won't open /nwa for NW 7.3?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Suresh,

paste output for following file.

/usr/sap/TCN/JC00/work/dev_jcontrol

and check if

instance.properties @ /usr/sap/TCN/JC00/j2ee/cluster have usr:group as sidtcn:sapsys

Nikhil,

I don't find dev_jcontrol instead I have

dev_jstart

dev_jcmon

and in instance.properties

ID8295850.ClassPath=C:\usr\sap\TCN\J00/j2ee/cluster/bin/boot/sap.com~tc~bl~jkernel_boot~impl.jar;C:\usr\sap\TCN\J00/j2ee/cluster/bin/boot/jaas.jar;C:\usr\sap\TCN\J00/j2ee/cluster/bin/system/sap.com~tc~bl~bytecode~library.jar;C:\usr\sap\TCN\J00/j2ee/cluster/bin/boot/memoryanalyzer.jar

ID8295850.Console=no

ID8295850.DebugMode=no

ID8295850.DebugPort=50021

ID8295850.Debuggable=yes

ID8295850.Execute=yes

ID8295850.JavaParameters=-XX:PermSize=1024m -Xmx2048m -XX:MaxNewSize=410m -XX:MaxPermSize=1024m -Xms2048m -XX:NewSize=410m -Dorg.omg.CORBA.ORBClass=com.sap.engine.system.ORBProxy -Djavax.management.builder.initial=com.sap.pj.jmx.server.interceptor.InterceptorChainBuilder -Djmx.invoke.getters=true -Djava.security.policy=./../bin/kernel/java.policy -Djava.security.egd=file:/dev/urandom -Djava.awt.headless=true -Dorg.omg.CORBA.ORBSingletonClass=com.sap.engine.system.ORBSingletonProxy -Drdbms.driverLocation=C:\usr\sap\TCN\J00\exe\ojdbc6.jar -Djava.io.tmpdir=./temp -Dsun.lang.ClassLoader.allowArraySyntax=true -Djava.protocol.handler.pkgs=com.sap.engine.httpdsrclient.protocols|iaik.protocol -Dnetworkaddress.cache.ttl=10 -DSAPJVM_EXTENSION_COMMAND_HANDLER=com.sap.tools.memory.protocol.ProtocolHandler -Dsys.global.dir=C:\usr\sap\TCN\SYS\global -Djco.jarm=1 -Djavax.rmi.CORBA.PortableRemoteObjectClass=com.sap.engine.system.PortableRemoteObjectProxy -XX:+UseConcMarkSweepGC -XX:TargetSurvivorRatio=90 -verbose:gc -XX:+DumpDetailedClassStatisticOnOutOfMemory -XX:+PrintGCDetails -XX:MaxErrorQueueLength=200 -XX:+PrintGCTimeStamps -XX:+DisableExplicitGC -XX:SoftRefLRUPolicyMSPerMB=1 -XX:-StringInternTableInPermGen -XX:SurvivorRatio=9 -XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=OOM.hprof -XX:-TraceClassUnloading

ID8295850.JavaPath=C:\usr\sap\TCN\J00\exe\sapjvm_6

ID8295850.LoadBalanceRestricted=no

ID8295850.LogName=server0

ID8295850.MainClass=com.sap.engine.boot.Start

ID8295850.Name=server0

ID8295850.NodeIndex=00

ID8295850.Parameters=

ID8295850.RootPath=C:\usr\sap\TCN\J00/j2ee/cluster/server0

ID8295850.Type=server

instance.install.dir=C:/usr/sap/TCN/J00/j2ee

instance.numAliases=6000

instance.numApplications=6000

instance.numBrSessions=4096

instance.numCaches=70

instance.numEjbSessions=1000

instance.numEjbs=200

instance.numEntryPoints=100

instance.numProcesses=20

instance.numRoConnections=1000

instance.numThreads=600

instance.numWebSessions=40960

instance.osLibsPath=C:/usr/sap/TCN/J00/j2ee/os_libs

instance.runAction=NONE

instance.runMode=NORMAL

Suresh,

Attach also dev_server0, dev_dispatcher.

Cheers.

I don't find dev_dispatcher

---------------------------------------------------

trc file: "dev_server0", trc level: 1, release: "720"

---------------------------------------------------

sysno 00

sid TCN

systemid 562 (PC with Windows NT)

relno 7200

patchlevel 0

patchno 63

intno 20020600

make multithreaded, Unicode, 64 bit, optimized

profile \\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

pid 6564

* ACTIVE TRACE LEVEL 1

* ACTIVE TRACE COMPONENTS All, egi

Sun Nov 11 15:16:48 2012

* trace logging activated, max size = 52428800 bytes, 2 versions

arguments :

arg[ 0] : C:\usr\sap\TCN\J00\exe\jstart.EXE

arg[ 1] : -appTrc

arg[ 2] : -nodeId=2

arg[ 3] : pf=\\TCNTAS\sapmnt\TCN\SYS\profile\TCN_J00_TCNTAS

arg[ 4] : -DSAPINFO=TCN_00_server0

arg[ 5] : -hostvm

arg[ 6] : -nodeName=ID8295850

arg[ 7] : -file=C:\usr\sap\TCN\J00\j2ee\cluster\instance.properties

arg[ 8] : -jvmFile=C:\usr\sap\TCN\J00\work\jstart.jvm

arg[ 9] : -traceFile=C:\usr\sap\TCN\J00\work\dev_server0

arg[10] : -javaOutFile=C:\usr\sap\TCN\J00\work\jvm_server0.out

F Sun Nov 11 15:16:48 2012

F ********************************************************************************

F Java environment properties

F root directory : C:\usr\sap\TCN\J00\exe\sapjvm_6

F vendor : SAP AG

F version : 1.6.0_17

F cpu : amd64

F java vm type : server

F java vm version : 6.1.018

F jvm library name : jvm.dll

F library path : C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin\server;C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin

F executable path : C:\usr\sap\TCN\J00\exe\sapjvm_6\bin

F SAP extensions : available

F ********************************************************************************

I [Thr 6304] MtxInit: 10002 0 2

I [Thr 6304] MPI: dynamic quotas disabled.

I [Thr 6304] MPI init: pipes=4000 buffers=1279 reserved=383 quota=10%

M [Thr 6304] NiInit3: NI already initialized; param 'maxHandles' ignored (init=2;par=32768;cur=2048)

M [Thr 6304] CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Ext.

M [Thr 6304] CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Ext.

M [Thr 6304] CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

M [Thr 6304] CCMS: CCMS Monitoring Initialization finished, rc=0.

F Sun Nov 11 15:16:48 2012

F ********************************************************************************

F SAP Java VM arguments:

F arg[ 0] = vfprintf

F arg[ 1] = abort

F arg[ 2] = exit

F arg[ 3] = -XmonGcCallback

F arg[ 4] = -XdebugStateChangeCallback

F arg[ 5] = -DSAPJStartVersion=720, patch 68, changelist 1198183, NTAMD64, optU (Oct 20 2010, 01:55:49)

F arg[ 6] = -Xjvmx

F arg[ 7] = -XsapSystem:00

F arg[ 8] = -DSAPSTARTUP=1

F arg[ 9] = -DSAPSYSTEM=00

F arg[10] = -DSAPSYSTEMNAME=TCN

F arg[11] = -DSAPMYNAME=TCNTAS_TCN_00

F arg[12] = -DSAPDBHOST=TCNTAS

F arg[13] = -DSAPINFO=TCN_00_server0

F arg[14] = -Dj2ee.dbhost=TCNTAS

F arg[15] = -Dsun.java.launcher=jstart

F arg[16] = -Dsun.java.command=com.sap.engine.boot.Start

F arg[17] = -Djstartup.mode=JSTART

F arg[18] = -Djstartup.whoami=server

F arg[19] = -Djstartup.ownProcessId=6564

F arg[20] = -Djstartup.ownHardwareId=S0961348237

F arg[21] = -Djstartup.debuggable=yes

F arg[22] = -DLoadBalanceRestricted=no

F arg[23] = -XdebugPortRange:50021-50021

F arg[24] = -Denv.class.path=

F arg[25] = -Dsys.global.dir=C:\usr\sap\TCN\SYS\global

F arg[26] = -Dapplication.home=C:\usr\sap\TCN\J00\exe

F arg[27] = -Djava.class.path=C:\usr\sap\TCN\J00\exe\jstart71.jar;C:\usr\sap\TCN\J00\exe\sapjvm_6\lib\jvmx.jar;C:\usr\sap\TCN\J00\exe\sapjvm_6\lib\jvmx_tools.jar;C:\usr\sap\TCN\J00\exe\jre\lib\iqlib.jar;C:\usr\sap\TCN\J00\exe\sapjvm_6\lib\tools.jar;C:\usr\sap\TCN\J00\j2ee\cluster\bin\boot\sap.com~tc~bl~jkernel_boot~impl.jar;C:\usr\sap\TCN\J00\j2ee\cluster\bin\boot\jaas.jar;C:\usr\sap\TCN\J00\j2ee\cluster\bin\system\sap.com~tc~bl~bytecode~library.jar;C:\usr\sap\TCN\J00\j2ee\cluster\bin\boot\memoryanalyzer.jar

F arg[28] = -Djava.library.path=C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin\server;C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\bin;C:\usr\sap\TCN\J00\j2ee\os_libs;C:\usr\sap\TCN\J00\exe\sapjvm_6\bin;C:\usr\sap\TCN\J00\exe;D:\oracle\TDB\11203\bin;C:\Program Files\HP\NCU;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\idmu\common;C:\Windows\System32\WindowsPowerShell\v1.0;C:\usr\sap\TCN\SYS\exe\uc\NTAMD64

F arg[29] = -XX:PermSize=1024m

F arg[30] = -Xmx2048m

F arg[31] = -XX:MaxNewSize=410m

F arg[32] = -XX:MaxPermSize=1024m

F arg[33] = -Xms2048m

F arg[34] = -XX:NewSize=410m

F arg[35] = -Dorg.omg.CORBA.ORBClass=com.sap.engine.system.ORBProxy

F arg[36] = -Djavax.management.builder.initial=com.sap.pj.jmx.server.interceptor.InterceptorChainBuilder

F arg[37] = -Djmx.invoke.getters=true

F arg[38] = -Djava.security.policy=./../bin/kernel/java.policy

F arg[39] = -Djava.security.egd=file:/dev/urandom

F arg[40] = -Djava.awt.headless=true

F arg[41] = -Dorg.omg.CORBA.ORBSingletonClass=com.sap.engine.system.ORBSingletonProxy

F arg[42] = -Drdbms.driverLocation=C:\usr\sap\TCN\J00\exe\ojdbc6.jar

F arg[43] = -Djava.io.tmpdir=./temp

F arg[44] = -Dsun.lang.ClassLoader.allowArraySyntax=true

F arg[45] = -Djava.protocol.handler.pkgs=com.sap.engine.httpdsrclient.protocols|iaik.protocol

F arg[46] = -Dnetworkaddress.cache.ttl=10

F arg[47] = -DSAPJVM_EXTENSION_COMMAND_HANDLER=com.sap.tools.memory.protocol.ProtocolHandler

F arg[48] = -Djco.jarm=1

F arg[49] = -Djavax.rmi.CORBA.PortableRemoteObjectClass=com.sap.engine.system.PortableRemoteObjectProxy

F arg[50] = -XX:+UseConcMarkSweepGC

F arg[51] = -XX:TargetSurvivorRatio=90

F arg[52] = -verbose:gc

F arg[53] = -XX:+DumpDetailedClassStatisticOnOutOfMemory

F arg[54] = -XX:+PrintGCDetails

F arg[55] = -XX:MaxErrorQueueLength=200

F arg[56] = -XX:+PrintGCTimeStamps

F arg[57] = -XX:+DisableExplicitGC

F arg[58] = -XX:SoftRefLRUPolicyMSPerMB=1

F arg[59] = -XX:-StringInternTableInPermGen

F arg[60] = -XX:SurvivorRatio=9

F arg[61] = -XX:+HeapDumpOnOutOfMemoryError

F arg[62] = -XX:HeapDumpPath=OOM.hprof

F arg[63] = -XX:-TraceClassUnloading

F arg[64] = -Xss2097152

F ignore unrecognized options : no

F ********************************************************************************

J JVMX version - Sep 16 2010 15:40:24 - 61_REL - optU - windows amd64 - 6 - bas2:142976 (mixed mode)

J (CompilerOracle read from file C:\usr\sap\TCN\J00\exe\sapjvm_6\jre\.hotspot_compiler )

F [Thr 6136] *** LOG => SfCJavaVm: Java VM started.

F ********************************************************************************

F Main method call:

F com/sap/engine/boot/Start.main()

F ********************************************************************************

J Sun Nov 11 15:16:49 2012

J 1.518: [GC 1.519: [ParNew: 343552K->3725K(381696K), 0.0046968 secs] 343560K->3733K(2059008K), 0.0047826 secs] [Times: user=0.00 sys=0.00, real=0.00 secs]

F [Thr 6136] Sun Nov 11 15:16:50 2012

F [Thr 6136] *** LOG => State changed from 0 (Initial) to 1 (Waiting to start).

F [Thr 6136] *** LOG state real time: 2.949 CPU time: 0.483 sys, 3.447 usr

F [Thr 6136] *** LOG total real time: 2.949 CPU time: 0.483 sys, 3.447 usr

F [Thr 6136]

F [Thr 6136] *** LOG => State changed from 1 (Waiting to start) to 2 (Starting framework).

F [Thr 6136] *** LOG state real time: 0.000 CPU time: 0.000 sys, 0.000 usr

F [Thr 6136] *** LOG total real time: 2.949 CPU time: 0.483 sys, 3.447 usr

F [Thr 6136]

J Sun Nov 11 15:16:51 2012

J 3.172: [GC 3.173: [ParNew: 347277K->10687K(381696K), 0.0151697 secs] 347330K->10740K(2059008K), 0.0152605 secs] [Times: user=0.00 sys=0.00, real=0.02 secs]

J Sun Nov 11 15:16:55 2012

J 7.325: [GC 7.325: [ParNew: 354239K->38144K(381696K), 0.0481638 secs] 354783K->50531K(2059008K), 0.0482864 secs] [Times: user=0.36 sys=0.02, real=0.05 secs]

J Sun Nov 11 15:17:02 2012

J 13.841: [GC 13.841: [ParNew: 381696K->38144K(381696K), 0.0917000 secs] 394871K->109792K(2059008K), 0.0918055 secs] [Times: user=0.51 sys=0.11, real=0.09 secs]

M [Thr 6476] Sun Nov 11 15:17:02 2012

M [Thr 6476] CCMS: openMonitoringSegment(): inside static JMON Lib: already connected.

J Sun Nov 11 15:17:03 2012

J 15.608: [GC 15.608: [ParNew: 381696K->38144K(381696K), 0.0647815 secs] 454944K->140455K(2059008K), 0.0648884 secs] [Times: user=0.50 sys=0.03, real=0.06 secs]

J Sun Nov 11 15:17:07 2012

J 19.549: [GC 19.549: [ParNew: 381696K->38144K(381696K), 0.0557920 secs] 484145K->168719K(2059008K), 0.0559117 secs] [Times: user=0.34 sys=0.00, real=0.06 secs]

F [Thr 6136] Sun Nov 11 15:17:21 2012

F [Thr 6136] *** LOG => State changed from 2 (Starting framework) to 10 (Starting apps).

F [Thr 6136] *** LOG state real time: 31.316 CPU time: 2.043 sys, 60.575 usr

F [Thr 6136] *** LOG total real time: 34.265 CPU time: 2.527 sys, 64.022 usr

F [Thr 6136]

J Sun Nov 11 15:17:21 2012

J 33.493: [GC 33.493: [ParNew: 381696K->33958K(381696K), 0.0339391 secs] 512337K->181973K(2059008K), 0.0340561 secs] [Times: user=0.20 sys=0.02, real=0.03 secs]

J 33.651: [GC 33.651: [ParNew: 377510K->38144K(381696K), 0.0192962 secs] 525578K->190149K(2059008K), 0.0193956 secs] [Times: user=0.16 sys=0.00, real=0.02 secs]

J 33.773: [GC 33.773: [ParNew: 381660K->29769K(381696K), 0.0338595 secs] 533696K->199761K(2059008K), 0.0339633 secs] [Times: user=0.17 sys=0.00, real=0.03 secs]

J Sun Nov 11 15:17:22 2012

J 33.936: [GC 33.936: [ParNew: 373290K->32880K(381696K), 0.0127110 secs] 543304K->202894K(2059008K), 0.0128152 secs] [Times: user=0.16 sys=0.00, real=0.01 secs]

J 34.137: [GC 34.137: [ParNew: 376426K->36043K(381696K), 0.0136110 secs] 546515K->206131K(2059008K), 0.0137139 secs] [Times: user=0.16 sys=0.00, real=0.01 secs]

J 34.315: [GC 34.315: [ParNew: 379551K->38144K(381696K), 0.0157063 secs] 549673K->208433K(2059008K), 0.0158045 secs] [Times: user=0.13 sys=0.00, real=0.02 secs]

F [Thr 6960] Sun Nov 11 15:17:22 2012

F [Thr 6960] *** WARNING => ShmComponent_findAlias: Cannot find alias for URL '/' (rc = 4 object not found). [sfxxjshm.c 2141]

J Sun Nov 11 15:17:24 2012

J 36.303: [GC 36.303: [ParNew: 381696K->38144K(381696K), 0.0205833 secs] 552289K->209107K(2059008K), 0.0206954 secs] [Times: user=0.19 sys=0.00, real=0.02 secs]

J Sun Nov 11 15:17:25 2012

J 37.593: [GC 37.594: [ParNew: 381696K->38144K(381696K), 0.0268328 secs] 552880K->218415K(2059008K), 0.0269394 secs] [Times: user=0.22 sys=0.00, real=0.03 secs]

J Sun Nov 11 15:17:26 2012

J 38.313: [GC 38.313: [ParNew: 381696K->38144K(381696K), 0.0266445 secs] 562049K->223653K(2059008K), 0.0267531 secs] [Times: user=0.20 sys=0.00, real=0.03 secs]

J Sun Nov 11 15:17:27 2012

J 39.047: [GC 39.047: [ParNew: 381696K->38144K(381696K), 0.0287430 secs] 567585K->233377K(2059008K), 0.0288484 secs] [Times: user=0.17 sys=0.02, real=0.03 secs]

J 39.738: [GC 39.738: [ParNew: 381696K->38144K(381696K), 0.0322674 secs] 576981K->247557K(2059008K), 0.0323849 secs] [Times: user=0.22 sys=0.08, real=0.03 secs]

J Sun Nov 11 15:17:28 2012

J 40.564: [GC 40.564: [ParNew: 381696K->38144K(381696K), 0.0336285 secs] 591161K->257349K(2059008K), 0.0337349 secs] [Times: user=0.26 sys=0.02, real=0.03 secs]

F [Thr 6960] Sun Nov 11 15:17:30 2012

F [Thr 6960] *** LOG => State changed from 10 (Starting apps) to 3 (Running).

F [Thr 6960] *** LOG state real time: 8.836 CPU time: 3.447 sys, 37.455 usr

F [Thr 6960] *** LOG total real time: 43.101 CPU time: 5.974 sys, 101.478 usr

F [Thr 6960]

J Sun Nov 11 15:57:45 2012

J 2457.864: [GC 2457.865: [ParNew: 381696K->38144K(381696K), 0.0404975 secs] 600958K->267847K(2059008K), 0.0406608 secs] [Times: user=0.34 sys=0.00, real=0.04 secs]

Hello Suresh,

1) can u ping the host server

2) Is firewall installed.( check if port is not blocked)

3) tnsping sid (paste output)

4) check if contents of tnsnames.ora,& listener.ora

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi nikhil,

1) Both SQLPlus and Oracle server are in the same host.

2) No, I turned off all the fire walls. I checked the port is reachable via telnet.

3) tnsping tdb

OUTPUT:

C:\Users\tcnadm>tnsping tdb

TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 11-NOV-2

012 15:34:40

Used parameter files:

\\TCNTAS\sapmnt\TCN\SYS\profile\oracle\sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP

.WORLD) (PROTOCOL = TCP) (HOST = TCNTAS) (PORT = 1521))) (CONNECT_DATA = (SID =

TDB) (GLOBAL_NAME = TDB.WORLD)))

OK (0 msec)

################

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/TNSNAMES.ORA#2 $

################

TDB.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = TCNTAS)

(PORT = 1521)

)

(CONNECT_DATA =

(SID = TDB)

(GLOBAL_NAME = TDB.WORLD)

)

################

# Filename......: sqlnet.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bas/720_REL/src/krn/tpls/ora/SQLNET.ORA#1 $

################

AUTOMATIC_IPC = ON

TRACE_LEVEL_CLIENT = OFF

NAMES.DEFAULT_DOMAIN = WORLD

# 05.01.06 unsorported parameter now

#NAME.DEFAULT_ZONE = WORLD

# 05.01.06 set the default to 10

SQLNET.EXPIRE_TIME = 10

SQLNET.AUTHENTICATION_SERVICES = (NTS)

# 05.01.06 set to default

#TCP.NODELAY=YES

# 05.01.06 set to 32768

DEFAULT_SDU_SIZE=32768

What I guess is will the default SAP Based Oracle installation blocks SQLPLUS or any other client connections.?

Hi,

Did you use ora<sid> user ?

Did you get an error setting up the oracle database?

Can you check OUI logs in order to see if listerer was created correctlly?

Cheers

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sargan,

The oraInstallxx.out

You can find the log of this install session at:

C:\Program Files\Oracle\Inventory\logs\installActions2012-11-11_10-13-37AM.log

Dll to load is C:\Users\ADMINI~1\AppData\Local\Temp\OraInstall2012-11-11_10-13-37AM\Win64RunProcesses.dll

Loading psapi.dll from C:\Users\ADMINI~1\AppData\Local\Temp\OraInstall2012-11-11_10-13-37AM\psapi.dll

PersistEnv

INFO: d:\oracle\tdb\11203\odp.net\bin\2.x\oracle.dataaccess.dll is registered successfully in GAC.

INFO: Configuration Section "oracle.dataaccess.client" removed!

INFO: Oracle.DataAccess.Dll Provider Factory entry removed!

INFO: The following section has been added.

INFO: The following element added under DbProviderFactories.

INFO: Counters registered successfully in the system.

INFO: d:\oracle\tdb\11203\odp.net\publisherpolicy\2.x\policy.2.102.oracle.dataaccess.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\odp.net\publisherpolicy\2.x\policy.2.111.oracle.dataaccess.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\odp.net\publisherpolicy\2.x\policy.2.112.oracle.dataaccess.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\odp.net\bin\4\oracle.dataaccess.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\odp.net\publisherpolicy\4\policy.4.112.oracle.dataaccess.dll is registered successfully in GAC.

INFO: Configuration Section "oracle.dataaccess.client" removed!

INFO: Oracle.DataAccess.Dll Provider Factory entry removed!

INFO: The following section has been added.

INFO: The following element added under DbProviderFactories.

INFO: Counters registered successfully in the system.

INFO: d:\oracle\tdb\11203\asp.net\bin\2.x\oracle.web.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\asp.net\publisherpolicy\2.x\policy.2.111.oracle.web.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\asp.net\publisherpolicy\2.x\policy.2.112.oracle.web.dll is registered successfully in GAC.

INFO: Following entries added in GroupedProviders.xml file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: d:\oracle\tdb\11203\asp.net\bin\4\oracle.web.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\asp.net\publisherpolicy\4\policy.4.112.oracle.web.dll is registered successfully in GAC.

INFO: Following entries added in GroupedProviders.xml file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: Following entry added to machine.config file.

INFO: d:\oracle\tdb\11203\ode.net\bin\2.x\oracle.database.extensions.dll is registered successfully in GAC.

INFO: d:\oracle\tdb\11203\ode.net\bin\4\oracle.database.extensions.dll is registered successfully in GAC.

I guess some of the client access provision is removed purpose fully.

Ask a Question

Top Q&A Solution Author

User

Count