OraFAQ Forum: Windows » oracle 10g problem

Home » Infrastructure » Windows » oracle 10g problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

oracle 10g problem [message #222835]

Tue, 06 March 2007 10:50

ddkdhar
Messages: 68
Registered: February 2007

Member

i have just installed 10g on windows xp sp2.
i can access my database through cmd( command prompt --ms dos)
where as
in isqlplus it returns error like
-----------------------------
ERROR - ORA-12500: TNS:listener failed to start a dedicated server process
----------------
and em page(enterprise manager) opened automatically after installation
( i clicked startup icon )
oracle asking
Host Credentials

Database Credentials
what are these credentials .please explain in detail.and also jvm(java) returned error like unable to open a file ( first time).i knoe database credentials. what are host credentials.

details about my oracle 10g

SQL> select * from v$version
2 ;

BANNER
----------------------------------------------------------------
Personal Oracle Database 10g Release 10.1.0.2.0 - Production
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production

operating system windows xp sp2
java 2 platform standard edition
Version 1.5.0 (build 1.5.0_11-b03)

thank you all

[Updated on: Tue, 06 March 2007 11:01]

Report message to a moderator

Re: oracle 10g problem [message #222852 is a reply to message #222835]

Tue, 06 March 2007 13:16

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Quote:

ORA-12500: TNS:listener failed to start a dedicated server process

Check you listener.log file for error details. The most likely scenario is that your server was too busy/resource constrained to start another process.

Report message to a moderator

Re: oracle 10g problem [message #222919 is a reply to message #222835]

Tue, 06 March 2007 23:38

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

HI,

http://dbataj.blogspot.com/2007/03/ora-12500.html

hope this helps
Taj

Report message to a moderator

Re: oracle 10g problem [message #223049 is a reply to message #222835]

Wed, 07 March 2007 06:38

ddkdhar
Messages: 68
Registered: February 2007

Member

06-MAR-2007 22:18:37 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVICE_NAME=oracle)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.60.95)(PORT=3171)) * establish * oracle * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error

above errors showing inlistener.log what to do now

Report message to a moderator

Re: oracle 10g problem [message #223052 is a reply to message #222835]

Wed, 07 March 2007 06:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
what are host credentials.

You windows ( OS) HOST NAME AND PASSWORD.
and OS user you have to grant LOGON AS AN BATCH JOB privs.
start > controlpanel > administrative tools > user assignment > LOGON AS AN BATCH JOB.

TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
32-bit Windows Error: 109: Unknown error

In your OS you already install oracle 9i. if yes then just stop oracle 9i listener and start and use only oracle 10g listener.

TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12537: TNS:connection closed
  TNS-12560: TNS:protocol adapter error
   TNS-00507: Connection closed
    32-bit Windows Error: 109: Unknown error

I get this error when I start 9.2 TNS listener to serve a 10g database and
attempt to connect to the 10g database. The fix is simply to use 10g listener.

http://rootshell.be/~yong321/oranotes/12500.txt

REGARDS
Taj

Report message to a moderator

Re: oracle 10g problem [message #223057 is a reply to message #222835]

Wed, 07 March 2007 07:21

ddkdhar
Messages: 68
Registered: February 2007

Member

this is also showing when i start lsnrctl

C:\Documents and Settings\dharanidhar>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 07-MAR-2007 18:43
:14

Copyright (c) 1991, 2004, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=karimojj-c876e5)(PORT=15
21)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error

Report message to a moderator

Re: oracle 10g problem [message #223069 is a reply to message #223057]

Wed, 07 March 2007 07:52

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
YOu do only one thing.

delete all configuration files.
1.listener.ora, tnsnames.ora , sqlnet.ora

and create all files through NETCA.

first create listner.ora
second create sqlnet.ora
third create tnsnames.ora

You should be take backup of all three configuration files before delete.

http://dbataj.blogspot.com/2007/02/ora-12162-on-linux-after-oracle.html

regards
Taj

Report message to a moderator

Re: oracle 10g problem [message #223070 is a reply to message #222835]

Wed, 07 March 2007 07:54

ddkdhar
Messages: 68
Registered: February 2007

Member

taj please explain step by step .
i stopped my 9i listener and even now its not working. and for my os there is no password . what to do now .please explain in detail

Report message to a moderator

Re: oracle 10g problem [message #223071 is a reply to message #223070]

Wed, 07 March 2007 07:55

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
go through my mention link in previous post i was mention all step for how to create all configuration files.

if you have any problem please let us know.

regards
Taj

Report message to a moderator

Re: oracle 10g problem [message #223090 is a reply to message #222835]

Wed, 07 March 2007 08:54

ddkdhar
Messages: 68
Registered: February 2007

Member

taj

net configuration finished successfully (test connection also).but one problem

isqlplus error again after login

Error
ERROR - ORA-12545: Connect failed because target host or object does not exist

[Updated on: Wed, 07 March 2007 09:08]

Report message to a moderator

Re: oracle 10g problem [message #223093 is a reply to message #223090]

Wed, 07 March 2007 09:20

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
ERROR - ORA-12545: Connect failed because target host or object does not exist

Actually i am too luzy i know this happen... and i want to alert about this error ...but forget to mention in my last post any way.

ORA-12545 >>

Suggestion :
1.Always use IP ADDRESS instead of COMPUTER NAME.
2.Change computer name alwarid-Oa49914 to alwarid-taj.

http://dbataj.blogspot.com/2007/03/tns-12545.html

REGARDS
Taj

Report message to a moderator

Re: oracle 10g problem [message #223094 is a reply to message #222835]

Wed, 07 March 2007 09:25

ddkdhar
Messages: 68
Registered: February 2007

Member

this is standalone system and my ip address is dynamic .can i add this ip to netconfig
it is asking enter valid service name if i enter 192.168.60.92
and in your blog
Suggestion :
1.Always use IP ADDRESS instead of COMPUTER NAME.
2.Change computer name alwarid-Oa49914 to alwarid-taj.

that means change computer name in my computer or change service name in oracle

[Updated on: Wed, 07 March 2007 09:32]

Report message to a moderator

Re: oracle 10g problem [message #223097 is a reply to message #223094]

Wed, 07 March 2007 09:32

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
it is asking enter valid service name if i enter 192.168.60.92
You should try if not successed then use your correct computer name.

if not solve then let us know
regards
Taj

Report message to a moderator

Re: oracle 10g problem [message #223103 is a reply to message #223097]

Wed, 07 March 2007 09:52

ddkdhar
Messages: 68
Registered: February 2007

Member

taj
thank a lot for giving immediate response .at last succeded
but one thing
i always changes my ip ( ie LAN Address regurly) any problem in future .and EM page automatically changed without asking host crdentials after logon as sys
this page giving brief information about database( user sys) showing invalid objects and severity.
could please drop some links to understand things in em page and it looks good

and again thank you very much taj for guiding

[Updated on: Wed, 07 March 2007 09:54]

Report message to a moderator

Re: oracle 10g problem [message #223106 is a reply to message #223103]

Wed, 07 March 2007 10:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

i always changes my ip ( ie LAN Address regurly) any problem in future

Yes it should be problem with you em respository.

you should configure permanent ip address and hostname for your computername.

and after that configure OEM repository.

go through below link about oem repository configuration.

http://www.oracle.com/pls/db102/portal.portal_db?selected=21

http://dbataj.blogspot.com/2007/01/oc4j-configuration-issue.html
http://dbataj.blogspot.com/search/label/EMCA

and again thank you very much taj for guiding
You'r most welcome !!!

regards
Taj

[Updated on: Wed, 07 March 2007 10:07]

Report message to a moderator

Previous Topic:	How can I login as SYSDBA in C#
Next Topic:	odbc call oracle instant client

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:49:36 CST 2024