Re: 10G linux, no tnsnames.ora

ccote_msl_at_yahoo.com wrote:
> HIm I am a linux newbie. I thought that creating a database with dbca
> created it automatically. Do I need to modify the one form .../sample?
>
> Thank you!
>

You don't need a listener. only if you work remotely, then you need one:

[oracle9_at_csdb01 oracle9]$ lsnrctl stop

LSNRCTL for Linux: Version 9.2.0.6.0 - Production on 25-MAR-2005 20:11:00

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=csdb01.cs.nl)(PORT=1521) ))
The command completed successfully
[oracle9_at_csdb01 oracle9]$ env|grep SID
ORACLE_SID=o920
[oracle9_at_csdb01 oracle9]$ sqlplus hr/hr

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Mar 25 20:11:12 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.6.0 - Production

-- 
Regards,
Frank van Bortel