Q
Problem solve Get help with specific problems with your technologies, process and projects.

Listener could not resolve SID

I am new in Oracle. When I try to log in to Oracle SQL*Plus I get the error: "listener could not resolve SID given in connect description." If my computer name is "abc" for example, how do I set listener.ora and tnsnames.ora?

I am new in Oracle. When I try to log in to Oracle SQL*Plus I get the error: "listener could not resolve SID given in connect description." If my computer name is "abc" for example, how do I set listener.ora and tnsnames.ora? I cannot create a database in the Oracle enterprise manager console, the same error occured. Whenever I must type some username and password I get an error.
This type of error usually indicates that there is no entry in tnsnames.ora for the database that you are attempting to connect to. As a consequence, Oracle has no way to find or locate the remote database that you are attempting to connect to. An entry in tnsnames.ora should look similar to this:
ORCL.ANYWHERE.COM  =                    <-- V805 is the service alias, 
                                            ANYWHERE.COM is the domain
   (DESCRIPTION =  
      (ADDRESS_LIST = 
         (ADDRESS =                      <-- section matches LISTENER.ORA
    (PROTOCOL = TCP)              <-- protocol
    (Host = HOSTA.ANYWHERE.COM)   <-- Database server host name
                                             or IP address 
    (Port = 1521)                 <-- port the session will connect to
         )
       )
       (CONNECT_DATA = (SID = ORCL))     <-- sid = the database sid
    )
The tnsnames.ora file should reside where your Oracle client software is installed in the folder networkadmin. The listener.ora will reside on the database server; in some cases, this may be your local machine if you have an Oracle database on your workstation or laptop. The listener.ora will contain information for your listener. When the listener is started, it will use the information in this file.

You can use the Oracle Net Configuration Assistant to create these files for you. On Windows NT, choose Start --> Programs --> Oracle – HOME_NAME --> Configuration and Migration Tools --> Net Configuration Assistant.

Dig Deeper on Oracle DBA jobs, training and certification

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close