Help with Listener

From: Arthur <mechhunter_at_rocketmail.com>
Date: Sat, 17 Feb 2001 17:27:14 GMT
Message-ID: <3a8eb07b.1499522@news.iinet.net.au>

Hi,

I am running Oracle developer 6.0 on a win98 platform. I am trying to connect Form Builder onto a Database that is running on the same machine - a local database. I have gotten this to work before with Listener and such from the help of this NG. However, I took a break from form and report learning and did a few weeks of SQL.

Now, I am trying to get back into form and it does not work anymore. I have check the TNSNAMES.ORA, LISTENER.ORA, SQLNET.ORA and NAME.ORA and they are identitical on both the D:\ORAWIN95\NET80\ADMIN and the D:\Oracle\Ora81\NETWORK\ADMIN.

	When I try to connect via Form builder, it is coming up with
this error: 	ORA-12154: TNS:could not resolve service name  


	(if I am on the internet)
	When I test the connection via Net8 Assistance Connection
Test, I get this error: 	ORA-12541:TNS:no listener  

	(if I am not on the internet)
	When I test the connection via Net8 Assistance Connection
Test, I get this error: 	ORA-12560: TNS:protocol adapter error


_________________________________________________________________
	Below is a copy of my TNSNAMES.ORA

# D:\ORACLE\ORA81\NETWORK\ADMIN\TNSNAMES.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle Net8 Assistant

ORCL.ORACLE =
  (DESCRIPTION =
    (SOURCE_ROUTE = OFF)
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = orcl)

    )
  )

Below is a copy of my LISTENER.ORA
# D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle Net8 Assistant

SAVE_CONFIG_ON_STOP_LISTENER = TRUE USE_PLUG_AND_PLAY_LISTENER = ON LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))     (PROTOCOL_STACK =
(PRESENTATION = TTC)
(SESSION = NS)

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = Orcl.Oracle)
(SID_NAME = ORCL)

    )
    (SID_DESC =
(GLOBAL_DBNAME = Orcl.Oracle)
(PROGRAM = extproc.exe)
(SID_NAME = ORCL)

    )
  )

TRACE_LEVEL_LISTENER = USER

Below is a copy of my SQLNET.ORA
# D:\ORACLE\ORA81\NETWORK\ADMIN\SQLNET.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle Net8 Assistant

NAMES.PREFERRED_SERVERS =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521)) )

NAMES.DEFAULT_DOMAIN = oracle8

USE_DEDICATED_SERVER = on

USE_CMAN = true

SQLNET.EXPIRE_TIME = 0 NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)

Below is a copy of my NAMES.ORA
# D:\ORACLE\ORA81\NETWORK\ADMIN\NAMES.ORA Configuration File:d:\Oracle\Ora81\NETWORK\ADMIN\names.ora # Generated by Oracle Net8 Assistant

NAMES.SERVER_NAME = data1.doomsday

NAMES.ADDRESSES =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL)) Changes since : I honestly can't remember. I know that I inslalled an updated network driver but I believe the network WAS working before. I installed IPX/SPX on the machine but I have not removed it and the error still persist.

As mentioned before, I am actually doing the developer path, thus, this admin. side of issue is very confusing to me. Any help on the matter will be greatly appriciated.

-Arthur Received on Sat Feb 17 2001 - 11:27:14 CST