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 ..

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

Could anyone give the full sample of the proiv.ini as reference ?

Hi Rob,

As i installing the Oracle 8.1.7, i remember there is a setting where you could set how many people can
simultaneously.

Hi ..

Try the SQLPLUS, can login using SQLPLUS PROFIT/PROFIT1888@PRODEMOS.

As i'm debuging, i found that when i login through VIP, the listener.log is not written anything there.