Re: Personal Oracle 8 and Dev/2000

From: <sharadudyawar_at_my-dejanews.com>
Date: Sun, 22 Nov 1998 10:37:15 GMT
Message-ID: <738pgq$gp2$1@nnrp1.dejanews.com>

Getting Personal Oracle 8 to connect to Dev/2000

Unfortunately PO8 does not allow direct connection from Developer 2000. You will have to do a few more things.

This is what worked for me.
1. Set up TCPIP protocal on you machine. 2 Give your PC a TCPIPIP address using Settings/Control Panel/Network eg your TCPIP address may be 200.100.50.25 3. Install complete PO8(you may have already done it) 4. Create or edit the file C:\ORAWIN95\NET80\ADMIN\LISTENER.ORA as follows LISTENER =
(ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = 200.100.50.25)


          (Port = 1521)


        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )

5.In your Windows 95 registry, change the value of HKLM\Software\ORACLE\LISTENER_STARTUP to "AUTO".

6. Using SQL Net Easy Configuration create a new service called "colm" with values for "server" = 200.100.50.25 and "service" = ORCL.

Your C:\ORAWIN95\NET80\ADMIN\TNSNAMES.ORA file should now have an entry like the following.

colm.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host =  200.100.50.25)


          (Port = 1521)


        )
        (ADDRESS =


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host =  200.100.50.25)


          (Port = 1526)


        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

7 Restart your PC once . Now you should be able to connect from D2K using SCOTT/TIGER_at_colm.

Hope this helps.

Sharad

In article <7320tg$5kj$1_at_newnews.global.net.uk>, "Paul Rosenthal" <paul.rosenthal_at_fastrack-it.co.uk> wrote:

> I have done a std install of PO8.
>
> The supplied sqlplus 8 connects fine, no connect string required.
>
> Then Dev/2k R2.1 (i.e. forms5)
>
> But it won't connect without a connect string.
>
> But what is the connect string when using PO8 under W95 standalone.
>
> Am I missing something obvious here?
>
> Thanks in advance.
>
> Paul Rosenthal
>
>

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

Received on Sun Nov 22 1998 - 04:37:15 CST