We recently installed Oracle 9i on Redhat and have discovered that there is no listener.ora and tnsnames.ora file in the usual location: /u01/app/oracle/product/9.2.0/network/admin
The server has been running fine and we have performed imp's and exp's without any issues, clients have also been connecting without issue.
We discovered the files were missing when attempting to run sqlplus on the server, it gave an: ORA-12514: TNS:listener could not resolve SERVICE_NAME........ ,
and upon investigation discovered the missing files.
aprinsloo@sagetelecom.net wrote:> We recently installed Oracle 9i on Redhat and have discovered that> there is no listener.ora and tnsnames.ora file in the usual location:> /u01/app/oracle/product/9.2.0/network/admin>
The server has been running fine and we have performed imp's and exp's> without any issues, clients have also been connecting without issue.>
We discovered the files were missing when attempting to run sqlplus on> the server, it gave an:> ORA-12514: TNS:listener could not resolve SERVICE_NAME........ ,>
and upon investigation discovered the missing files.>
Anyone seen this before?> Thx>
When the system is installed by default, those files don't necessarily get created. You actually don't need the listener.ora file on the system, unless you're listening on a different port than 1521. tnsnames, would only help you if you make outgoing sqlplus/em connections to other servers....
Vladimir M. Zakharychev 6 August 2006 13:09:26 [ permanent link ]
aprinsloo@sagetelecom.net wrote:> We recently installed Oracle 9i on Redhat and have discovered that> there is no listener.ora and tnsnames.ora file in the usual location:> /u01/app/oracle/product/9.2.0/network/admin>
The server has been running fine and we have performed imp's and exp's> without any issues, clients have also been connecting without issue.>
We discovered the files were missing when attempting to run sqlplus on> the server, it gave an:> ORA-12514: TNS:listener could not resolve SERVICE_NAME........ ,>
and upon investigation discovered the missing files.>
Anyone seen this before?> Thx
If TNS_ADMIN environment variable is set, its value takes precedence for Net configuration files location. Check if you have it set and if it points to a different location than the default. The listener actually doesn't need the listener.ora file to operate: if started without the config file, it will listen on default TCP port and local Oracle instances will register themselves with the listener dynamically. tnsnames.ora file is not necessary, too, it is only used for local naming. If you have a compatible LDAP server or Oracle Names server then you don't need to bother with tnsnames.ora. However, if you don't use a directory server and don't have the tnsnames.ora file, Net will be unable to resolve names (throwing exactly the error you're getting.)
More information is in Net Services Administrator's Guide for your Oracle release.
I have installed oracle software 10.2 on mac 10.5 server.
I created database through dbca but tnsnames.ora and listener.ora files not get created as its location e.g /Users/oracle/oracle/product/10.2.0/db_a/network/admin.
I created both files and configured it.
Now, when I start listener by using:
oracle:~ oracle$ lsnrctl start
LSNRCTL for MacOS X Server: Version 10.2.0.4.0 - Production on 27-MAY-2009 15:16:07
Copyright (c) 1991, 2007, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
when try to start database: it shows
dbstart ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener Usage: //Users/oracle/oracle/product/10.2.0/db_1/bin/dbstart ORACLE_HOME Processing Database instance "rsg": log file /Users/oracle/oracle/product/10.2.0/db_1/startup.log Processing Database instance "rsg": log file /Users/oracle/oracle/product/10.2.0/db_1/startup.log
when try to connect it :
oracle:~ oracle$ sqlplus hr/hr@rsg
SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 27 15:16:56 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR: ORA-28547: connection to server failed, probable Oracle Net admin error
B]when try to connect it by other user/B]
Enter user-name: hr Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Mac OS X Error: 2: No such file or directory
I created database through dbca but tnsnames.ora and listener.ora files not get created as its location e.g /u01/app/oracle/product/10.2.0/db_a/network/admin I created both files and configured it. Now, when I start listener by using: oracle:~ oracle$ lsnrctl start TNS-01106: Listener using listener name LISTENER has already been started when try to connect it : oracle:~ oracle$ sqlplus hr/hr@rsg SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 27 15:16:56 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. ERROR: ORA-12514: TNS:Listener does not currently know of service requested in connect description
Can you tell me the perblem i want to connect to database Please
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
