Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Report question
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)
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Jun 03 2004 - 11:14:04 CDT
![]() |
![]() |