Home » RDBMS Server » Networking and Gateways » ora-12224 (10g, xp)
ora-12224 [message #321701] Wed, 21 May 2008 01:47 Go to next message
rzkhan
Messages: 345
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 Go to previous messageGo to next message
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
Re: ora-12224 [message #321727 is a reply to message #321701] Wed, 21 May 2008 02:58 Go to previous messageGo to next message
rzkhan
Messages: 345
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))
  )

Re: ora-12224 [message #321822 is a reply to message #321727] Wed, 21 May 2008 07:11 Go to previous messageGo to next message
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 Go to previous message
rzkhan
Messages: 345
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
Previous Topic: Regarding Tnsnames
Next Topic: TNSName Fail
Goto Forum:
  


Current Time: Tue Dec 06 04:28:43 CST 2016

Total time taken to generate the page: 0.12637 seconds