Re: issue while connecting database oracle 11g (244 Views)
Reply
Frequent Advisor
YadigarBakir
Posts: 41
Registered: ‎08-11-2011
Message 1 of 2 (270 Views)

issue while connecting database oracle 11g

hi all,

 

8688( 10232) 08/28/2012 02:13:45 RTE E Failure connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:13:54 RTE E Error: SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:13:54 RTE E SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:13:54 RTE E statement=Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:13:54 RTE E Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:13:54 RTE I Going to sleep for 15 seconds and try again to connect
8688( 10232) 08/28/2012 02:14:18 RTE E Error: SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:14:18 RTE E SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:14:18 RTE E statement=Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:14:18 RTE E Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:14:18 RTE I Going to sleep for 15 seconds and try again to connect
8688( 10232) 08/28/2012 02:14:43 RTE E Error: SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:14:43 RTE E SQL code=12154 message=ORA-12154: TNS:could not resolve the connect identifier specified
8688( 10232) 08/28/2012 02:14:43 RTE E statement=Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:14:43 RTE E Connecting to dbtype 'oracle10' Oracle server 'SMDB' as user 'SM'
8688( 10232) 08/28/2012 02:14:43 RTE I Going to sleep for 15 seconds and try again to connect
8688( 10232) 08/28/2012 05:15:07 RTE I -Memory : S(273832) O(128116) MAX(414236) - MALLOC's Total(1222)
8688( 10232) 08/28/2012 05:15:07 RTE I Thread termination in progress
8688( 10232) 08/28/2012 05:15:07 RTE I Shutdown of HP Service Manager environment has completed
8688( 10232) 08/28/2012 05:15:07 RTE I Process termination cleanup complete
8688( 10232) 08/28/2012 05:15:07 RTE D Total number of recorded stacks: 0
6492( 7392) 08/28/2012 05:20:46 RTE I smservice: stop service event received for service smservice
6492( 7572) 08/28/2012 05:20:46 RTE I smservice: processing shutdown request
6688( 8972) 08/28/2012 05:20:47 RTE I Using "utalloc" memory manager
6688( 8972) 08/28/2012 05:20:47 RTE I Command line: sm -shutdown
6688( 8972) 08/28/2012 05:20:47 RTE I Process sm 7.11.462 (462) System: 13080 (0x784DFB00) on PC (x86 64-bit) running Windows Server 2008 R2 Enterprise (6.1 Build 7600) from 2ESA2MSM (110.4.192.39) 

6688( 8972) 08/28/2012 05:20:47 RTE I Creating resources for system '13080' with key 0x784DFB00
6688( 8972) 08/28/2012 05:20:47 RTE I Created shared memory of size 96000000 using key 0x784DFB00 and attached to it at address 0x50000000
6688( 8972) 08/28/2012 05:20:47 RTE I iinfo is initialized: 50000278
6688( 8972) 08/28/2012 05:20:47 RTE I JVM successfully created

 

 


Two application server look one database and these servers work active.

We have problem when try to work both of them.When One server works normally but other doesn't work at the same time.

When we have problem,this error write at sm.log file. We dont have this problem ,we want connect via ORACLE 10g.But 11g is problem.

 

Many Thanks

 

 

Trusted Contributor
Randall Harvey
Posts: 230
Registered: ‎03-29-2010
Message 2 of 2 (244 Views)

Re: issue while connecting database oracle 11g

Are the two SM application servers independent of each other or are they in a server group?
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.