 | | | Report question | Report question 2004-06-03 - By Nestor Florez
Muchas Gracias Segnor Reyes,
I actually look at my tnsnames.ora and where you have 'SOAB.WORLD = '
I had 'EXTPROC_CONNECTION_DATA = ' and I changed to 'orcle10g = '
and now it is showing me the database so that I can pick the tables and
fields to choose from.
I manage to create my first report, I am dangerous now!!!
TNX :-)
Néstor Alberto Flórez Torres
> > > jreyes@(protected) 6/3/2004 9:13:20 AM > > >
I think you must read a lot.
In the server You must create a database first, configure the listener and
tnsnames.ora and start up.
In the client you must modify the tnsnames.ora to create a conection to the
server.
Then you must do a tnsping databasename, and you must get an answer.
For example in tnsnames.ora
SOAB.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.5)(PORT = 1521))
(CONNECT_DATA = (SID = SOAB))
)
C:\Documents and Settings\JReyes >tnsping soab.world
TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on
03-JUN-20
04 12:11:52
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Archivos de parßmetros utilizados:
c:\oracle\ora92\network\admin\sqlnet.ora
Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192
168.
1.5)(PORT = 1521)) (CONNECT_DATA = (SID = SOAB)))
Realizado correctamente (7120 mseg)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|