I'm having trouble getting connected

From: naheed <NAHEEDA_at_msmail1.ans.alcatel.co.uk>
Date: 1997/07/29
Message-ID: <01bc9c0a$db889a60$d3793ec2_at_naheed.abbas.ans.alcatel.co.uk>#1/1

I'm working with SQL*NET 2.0.15.*.* and TCP/IP Protocol Adapter 2.0.15.*.* I am still having problems accessing two databases on the same form I have 3 databases the 1st called ALPHA works fine. It is the other two BETA and GAMMA which I need to get on the same form. BETA is on a machine named ALEX. GAMMA is on a machine called RUSS. I have altered the ORA configeration files to.

TNSNAMES.ORA FOR ALEX ALIAS=

	(DESCRIPTION= (ADDRESS_LIST=
			(ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))
	    (CONNECT_DATA= (SID=ALPHA) ))
BETA=
	(DESCRIPTION= (ADDRESS_LIST=
			(ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))


		(CONNECT_DATA= (SID=BETA) ))


GAMMA=
	(DESCRIPTION= (ADDRESS_LIST=
			(ADDRESS= (PROTOCOL=TCP) (HOST=RUSS) (PORT=1521) ))


		(CONNECT_DATA= (SID=GAMMA) ))

LISTENER.ORA FOR ALEX LISTENER=(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=IPC) (KEY=ALPHA) )

		    (ADDRESS= (PROTOCOL=IPC) (KEY=ALIAS) )
            (ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521)	 ))
SID_LIST_LISTENER= (SID_LIST=


		(SID_DESC=(SID_NAME=ALPHA) (ORACLE_HOME=/oracle/user) ))


ALEXBETA= (ADDRESS_LIST=
		    (ADDRESS= (PROTOCOL=IPC) (KEY=GAMMA) )
		    (ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))
SID_LIST_ALEXBETA= (SID_LIST=


		(SID_DESC= (SID_NAME=BETA) (ORACLE_HOME=/oracle/user) ))


ALEXGAMMA= (ADDRESS_LIST=
		    (ADDRESS= (PROTOCOL=IPC) (KEY=GAMMA) )
		    (ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))
SID_LIST_ALEXGAMMA= (SID_LIST=


		(SID_DESC= (SID_NAME=GAMMA) (ORACLE_HOME=/oracle/user) ))

TRACE_DIRECTORY_LISTENER=/oracle/user/network/trace TRACE_FILE_LISTENER=listener.trc
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER=0 TNSNAMES.ORA FOR RUSS ALIAS=
(DESCRIPTION= (ADDRESS_LIST=

			(ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))


		(CONNECT_DATA= (SID=ALPHA) ))


BETA=
	(DESCRIPTION= (ADDRESS_LIST=
			(ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))
        (CONNECT_DATA= (SID=BETA) ))
GAMMA=
	(DESCRIPTION= (ADDRESS_LIST=
			(ADDRESS= (PROTOCOL=TCP) (HOST=RUSS) (PORT=1521) ))


		(CONNECT_DATA= (SID=GAMMA) ))

LISTENER.ORA FOR RUSS LISTENER= (ADDRESS_LIST=
(ADDRESS= (PROTOCOL=IPC) (KEY=ALPHA) )
(ADDRESS= (PROTOCOL=IPC) (KEY=ALIAS) )
(ADDRESS= (PROTOCOL=TCP) (HOST=RUSS) (PORT=1521) ))
SID_LIST_LISTENER= (SID_LIST=
(SID_DESC=(SID_NAME=ALPHA) (ORACLE_HOME=/oracle/user) ))

ALEXBETA= (ADDRESS_LIST=
    (ADDRESS= (PROTOCOL=IPC) (KEY=GAMMA) )
    (ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))

SID_LIST_ALEXBETA= (SID_LIST=
    (SID_DESC= (SID_NAME=BETA) (ORACLE_HOME=/oracle/user) )) ALEXGAMMA= (ADDRESS_LIST=

		    (ADDRESS= (PROTOCOL=IPC) (KEY=GAMMA) )
		    (ADDRESS= (PROTOCOL=TCP) (HOST=ALEX) (PORT=1521) ))
SID_LIST_ALEXGAMMA= (SID_LIST=
        (SID_DESC=(SID_NAME=GAMMA) (ORACLE_HOME=/oracle/user) ))

TRACE_DIRECTORY_LISTENER=/oracle/user/network/trace TRACE_FILE_LISTENER=listener.trc
STARTUP_WAIT_TIME_LISTENER=0
CONNECT_TIMEOUT_LISTENER=0 I am working on machine RUSS and trying to make a synonym to BETA, so I can access it from FORMS 4.0
So I enter

CREATE DATABASE LINK BETA_LINK
CONNECT TO BETA_USER_NAME IDENTIFIED BY BETA_PASSWORD USING T:[ALEX's IP ADDRESS]:BETA;
and then
CREATE SYNONYM BETA_TABLE_SYN
FOR BETA_TABLE_at_BETA_LINK;

on RUSS at the SQL prompt. However when I try to select BETA_TABLE_SYN It gives an error message.
Could a very kind and noble computer user give me a hand either by pointing out my mistakes, or directing me to any other files that might be needed to access BETA.

			SMILE if you think things could be simpler
			SMILEY a.k.a ALEXANDER CAIRNS

Received on Tue Jul 29 1997 - 00:00:00 CEST