Re: Need Help with ODBC,TNSPING Po7 on NT40

In article <19970506043801.AAA09426_at_ladder01.news.aol.com> rwiltshi_at_aol.com (RWILTSHI) wrote:

> I have read through a lot of messages on this forum.
> Seems like there is a lot of difficulty using ODBC with Po7 - including
> me.
>
> I am using NT4.0 and personal Oracle 7.2 - 32 bit ODBC drivers from
> oracle.
> I would like to make Paradox 7.0 query an Oracle database.
> But, I can't even get to that point.
>
> I am able to open po7 and view the sample tables that came with po7.
> I am able to open an sql plus3.3 session and perform an sql.
>
> I used sql*net easy configuration and setup a database alias
> called aloracle using tcp-ip protocol with ORCL as sid.
>
> I downloaded the Oracle ODBC Support tool off their web site.
> I used the 32 Bit administrator that came with po7 and set up new dns
> with a setup string of aloracle (the database alias)
>
> Note: When I used connect strings like 2:aloracle or t:aloracle
> I get errors that refer to an OCI error.
> I think what is happening - is that this kind of setup string "tricks"
> oracle into thinking you want to use sql*net v1 even though you have
> sql*net v2 installed. Anybody agree?
>
> By using, the connect string of "aloracle" - the support tool is happy
> that I am using the proper sql*net version and I get a different error
> message
> from the odbc support tool: TNS Error.
>
> So, I clicked on the MS Dos prompt and dropped to a dos prompt.
> I typed in path and verified that C:\ORANT\BIN was in my path.
> I then typed in tnsping aloracle and got an error : No listener
> I then typed in a command in an attempt to start listener and
> got an error: 32 bit windows error.
>
> So, tnsping did not work - but, I can view tables with po7 and query from
> sqlplus.
>
> How do I tell if a listener service is working? How do I start one?
>
> Under control panel,settings,services, there is a listener service that is
>
> marked manual.(not automatic,not disabled) I tried to start it - no
> good.
>
> In some of the .ora files there is references to my computer name
> "wiltcow"
> This is the name I gave my computer when I installed NT.
> Does oracle need the IP address instead of a computer name?
> Do I need to use the "localhost" somewhere?
> Do I need a hosts file? If so, where do I put it?
>
> Does anybody have po7 version 7.2 hooked up with odbc?
> Do I need to upgrade to version 7.3?
> If you have odbc working with personal oracle would you share
> the content of the three .ora files with me?
> (change the names to protect the innocent of course)
>

Not having used Personal Oracle, I have assume that it works the same way. Easy SQL*Net will configure V2 SQL*Net and the connect strings you are using are V1. I have had very little luck making Easy SQL*Net work for me. I normally manually make the files. You need the SQLNET.ORA,TNSNAMES.ORA, and LISTENER.ORA files. These need to be placed in the \NETWORK\ADMIN directory of your Oracle home (C:\ORANT in my case). The following are samples of my files hopefully you can find something useful in them.

In SQLNET.ORA you need something like this:

	AUTOMATIC_IPC = OFF
	SQLNET.EXPIRE_TIME = 10
	trace_level_client = admin
	trace_file_client = sqlnet
	trace_directory_client=C:\ORANT\network\trace
	log_file_client = sqlnet
	log_directory_client=C:\ORANT\network\log

In TNSNAMES.ORA you need something like this:

	budget =
	  (DESCRIPTION = 
	    (ADDRESS_LIST = 
	        (ADDRESS = 
	          (COMMUNITY = luling.monsanto.com)
	          (PROTOCOL = TCP)
	          (HOST = paradis.monsanto.com)
	          (PORT = 1521)
	        )
	    )
	    (CONNECT_DATA = (SID = budg)
	    )
	  )

In LISTENER.ORA you need something like this:

	LISTENER =
	  (ADDRESS_LIST =
	        (ADDRESS=
	          (PROTOCOL= IPC)
	          (KEY= paradis.monsanto.com)
	        )
	        (ADDRESS=
	          (PROTOCOL= IPC)
	          (KEY= ORCL)
	        )
	        (ADDRESS= 
	          (COMMUNITY= monsanto.com)
	          (PROTOCOL= TCP)
	          (Host= paradis)
	          (Port= 1521)
	        )
	  )
	STARTUP_WAIT_TIME_LISTENER = 0
	CONNECT_TIMEOUT_LISTENER = 10
	TRACE_LEVEL_LISTENER = ADMIN
	SID_LIST_LISTENER =
	  (SID_LIST =
	    (SID_DESC = 
	      (SID_NAME = BUDG)
	    )
	  )
	PASSWORDS_LISTENER = (oracle)

You also have to make sure that the DEVICES file in \WINNT\SYSTEM32\DRIVERS\ETC also has a port 1521 defined for use by Oracle. Now this is to use TCP/IP as the protocol. I have not really looked into any other protocols.

All of the above will allow you to access the SID BUDG on paradis.monsanto.com under the Connect String of Budget. You should be able to TNSPING the Budget database and get a return.

Hope this helps. I guess it can't hurt.

D.M. (Mike) Mattix
Monsanto Company
Luling, LA
dmmatt_at_monsanto.com
(My comments do not reflect the position of Monsanto) (I know, like you thought they did..) Received on Tue May 06 1997 - 00:00:00 CDT