Re: configuring oracle 9i with Oracle developer6i
Date: Sun, 16 Mar 2003 12:30:20 +0000
Message-ID: <2649627.1047817820_at_dbforums.com>
Hi,
[Quoted] I have tried replaceing the TNSnames.ora and editing certain lines but
cannot get to connect using developer. I have pasted the both
TNSnames.ora hoping you could point me to the right directions
thanks again
[oracle9i TNSnames.ora]
# TNSNAMES.ORA Network Configuration File: # C:\Oracle\Ora91\network\admin\tnsnames.ora # Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rahman)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rahman)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc) (PRESENTATION = RO)
)
)
[developer6i TNSnames.ora]
Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = BEQ) (PROGRAM = oracle80) (ARGV0 = oracle80ORCL) (ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))') )
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) )
)
(CONNECT_DATA = (SID = ORCL)
)
)
TcpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (Host = Production1) (Port = 1521) )
)
(CONNECT_DATA = (SID = ORCL)
)
)
SpxExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = SPX) (Service = Server_lsnr) )
)
(CONNECT_DATA = (SID = ORCL)
)
)
NmpExample.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = NMP) (Server = FinanceServer1) (Pipe = ORAPIPE) )
)
(CONNECT_DATA = (SID = ORCL)
)
)
CMExample.world =
(DESCRIPTION=(address_list=
(ADDRESS= (PROTOCOL=tcp)(PORT=1610)(HOST=CM_SERVER)) (ADDRESS= (PROTOCOL=tcp)(PORT=1521)(HOST=LSNR_SERVER))) (CONNECT_DATA=(SID=ORCL)) (SOURCE_ROUTE=yes)
)
extproc_connection_data.world =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = IPC) (KEY = EXTPROC%ORACLE_HOME_ID%)
)
(CONNECT_DATA = (SID = extproc)
)
)
Originally posted by Da Morgan
> sjrahman wrote: > [Quoted] > > Hi all, > > I installed developer6i followed by a typical installation of > oracle9i > > which created a local database. I cannot log onto developer, as > i > > understand i have change things on the TNSnames.ora but dont > know what. > > Can anyone help me? > > Thanks > > Syed > > -- > > Posted via > http://dbforums.com/http://dbforums.com > > Developer, in its separate ORACLE_HOME, has a tnsnames.ora at > \network\admin. Copy your 9i tnsnames.ora to this location and > replace any > tnsnames file that is there. > > Provided you have your default ORACLE_HOME set properly you > should be able > to connect. >
Daniel Morgan
-- Posted via http://dbforums.comReceived on Sun Mar 16 2003 - 13:30:20 CET