OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » ora-12224 (10g, xp)

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

ora-12224 [message #321701]

Wed, 21 May 2008 01:47

rzkhan
Messages: 370
Registered: March 2005

Senior Member

I have installed oracle 10g on xp machine. and have installed developer 6i on client machine. When I use net 8 easy configuration and test the connection, it says ora-12224 error. tns listner.

I have checked the 'lsnrctl status'

which is already running on 10g xp machine.

my tnsnames.ora is

# tnsnames.ora Network Configuration File: c:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DATA1)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

and listener.ora is

# listener.ora Network Configuration File: c:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\oracle\product\10.1.0\Db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = DATA1)(PORT = 1521))
      )
    )
  )

Please help me sorting out the probelm.
thanks in advance.

rzkhan

[Updated on: Wed, 21 May 2008 02:03]

Report message to a moderator

Re: ora-12224 [message #321711 is a reply to message #321701]

Wed, 21 May 2008 02:05

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

You can post listener.ora for xp, tnsnames.ora from client or
you check whether SID / Service Name matches in listener /
tnsnames and Host name / IP Address.

Regards,

MSMallya

Report message to a moderator

Re: ora-12224 [message #321727 is a reply to message #321701]

Wed, 21 May 2008 02:58

rzkhan
Messages: 370
Registered: March 2005

Senior Member

tnsnames.ora on CLIENT

# C:\DEV6I\NET80\ADMIN\TNSNAMES.ORA Configuration File:C:\Dev6i\net80\admin\tnsnames.ora
# Generated by Oracle Net8 Assistant

EXAMPLE3.WORLD =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = nmp.world)(PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
    (CONNECT_DATA = (SID = ORCL))
  )

EXAMPLE1.WORLD =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = Production1)(Port = 1521))
    (CONNECT_DATA = (SID = SID1))
  )

RZ =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.154.201)(PORT = 1521))
    (CONNECT_DATA = (SID = ORCL))
  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = beq.world)(PROTOCOL = BEQ)(PROGRAM = oracle73)(ARGV0 = oracle73ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
    (CONNECT_DATA = (SID = ORCL))
  )

EXAMPLE2.WORLD =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = spx.world)(PROTOCOL = SPX)(Service = Server_lsnr))
    (CONNECT_DATA = (SID = ORCL))
  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
    (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
    (CONNECT_DATA = (SID = ORCL))
  )

Report message to a moderator

Re: ora-12224 [message #321822 is a reply to message #321727]

Wed, 21 May 2008 07:11

msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT

Member

It seems you have edited the listener.ora. Your listener.ora is not
proper. There is no entry for ORCL database in SID_LIST_LISTENER
and in client Tnsname for Host=DATA1

First Add in listener.ora (SID_DESC..)

Quote:

SID_LIST_LISTENER =
(
SID_DESC =
.
.
.
)
(
SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME = c:\oracle\product\10.1.0\Db_1)
(SID_NAME = ORCL)
)

and in Client tnsnames.ora

Quote:

ORCL.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DATA1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)

.WORLD part is for older version. Which versions (xp, client) are using? (Seems xp is using 10.1.0 and client old version).

Stop,Start / Reload listener and then try connecting from client.

Length of lines you are postin shall not exceed 80 characters.

Regards,

MSMallya

[Updated on: Wed, 21 May 2008 07:20]

Report message to a moderator

Re: ora-12224 [message #321834 is a reply to message #321822]

Wed, 21 May 2008 08:02

rzkhan
Messages: 370
Registered: March 2005

Senior Member

Thanks for being with me here. I noticed windows firewall setting. and after disabling it , it is working properly now...

thanks

Laughing

riaz

Report message to a moderator

Previous Topic:	Regarding Tnsnames
Next Topic:	TNSName Fail

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:19:48 CDT 2024