20 replies to this topic

[Rob Donovan]

Oh, BTW....

If you are still getting errors, you could try turning on the trace (TRACEALL = 15) , login and make sure you get the error and then send me the .TRC file.

I would not post the TRC file here, since it could hold your customer data etc..... And please winzip it also

Rob D.

[Vol Yip]

Joanne,

Could you show also the TNSNAMES.ORA and LISTENER.ORA? It seems that you application does not resovles TNS name.

One possibiltiy is that you have two Oracle versions running at the same and the Listener gets confused.

Does tnsping prodemos works?

Vol

[Joanne]

Hi Vol,

I have try the tnsping, it return OK.

Here is the Listener.ORa

# LISTENER.ORA Network Configuration File: D:\Oracle8iDB\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = twinhead)(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\Oracle8iDB)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = PRODEMOS)
      (ORACLE_HOME = D:\Oracle8iDB)
      (SID_NAME = PRODEMOS)
    )
  )

The Tnsname.ora :

# TNSNAMES.ORA Network Configuration File: D:\Oracle8iDB\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

PRODEMOS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = TWINHEAD)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = PRODEMOS)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = twinhead)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = PRODEMOS)
      (SERVER = SHARED)
      (PRESENTATION = [URL=http://admin)]http://admin)[/URL]
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC8))
      (ADDRESS = (PROTOCOL = TCP)(HOST = TWINHEAD)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

Thanks all for the help

Attached Files

•  listener.ora   586bytes   93 downloads

[Vol Yip]

Joanna,

Try to change your tnsnames.ora:

Before change:

PRODEMOS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TWINHEAD)(PORT = 1521))
)
(CONNECT_DATA =
(SID = PRODEMOS)
)
)

After change:

PRODEMOS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TWINHEAD)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PRODEMOS)
)
)

BTW, do you have more than 1 Oracle version installed in the same server?

Regards,

Vol

[Jeff Hon]

By the way all, if you are using Oracle8i or a higher version, avoid manually manipulating the LISTENER parameter files like TNSNAMES.ORA and LISTENER.ORA as this will lead to problems when setting up your LISTENER service. I learned this the hard way during my first server installation of Oracle8i and I don't mess around with those files anymore. Oracle recommends you configure these files using the Net8 (for Oracle8i) config tools.

[Joanne]

Hi guys .. thanks for all the help.

At last resource , i have reformat my harddisk and reinstall everything.
And .... now it's working fine

thanks again ..