You can check the available services by issuing the lsnrctl status or lsnrctl service commands on the database server. The "sqlnet. This file will also be present on the server if client style connections are used on the server itself, or if some additional server connection configuration is required. Here is an example of an "sqlnet. There are lots of parameters that can be added to control tracing, encryption, wallet locations etc.
These are out of the scope of this article. The OS hostname command must return the correct hostname of your database server. If not, fix it so it does. If the address is entered as ab,cd , then it resolves to two listener addresses, ab and cd. In Example , a database resides on host sales1-server. On the host where the local listener resides, configure the listener. For example:. A remote listener is a listener residing on one computer that redirects connections to a database instance on another computer.
You can configure registration to remote listeners, such as with Oracle RAC, for dedicated or shared server environments. In a dedicated server environment, you must enable the LREG background process to register with a remote listener. If a comma appears in the listener address, then the entire string must be enclosed in quotation marks. In a shared server environment, you can use the same registration technique as for a dedicated server environment. For example, assume that a remote listener named listener-sales2 listens on port on host sales2-server , and a database resides on host sales1-server.
You want the listener on sales2-server to redirect connection requests to this database. Figure illustrates this scenario. Example shows how to register a remote listener in a dedicated server environment. In the example, the remote listener is sales2-server. On the host where the remote listener resides, use Oracle Net Manager to configure the listener. Resolve the listener name alias for the remote listener through a tnsnames. A network may contain multiple local and remote listeners.
By default, all listeners are cross-registered with each other. Assume there are two distinct networks, network1 and network2. On network1 , there is a local listener named local1 , and a remote listener named remote1.
On network2 , there is a local listener named local2 , and a remote listener named remote2. The following syntax sets up registration so that the listeners only redirect connections to listeners on the same network. In the preceding example, local1 is registered only with remote1 , and remote1 only redirects connections to local1.
The listener local2 is registered only with remote2 , and remote2 only redirects connections to local2. Assume that multiple listeners are listening on a network named sales-network. The following conditions are true:. A database configured for dedicated server connections resides on host sales1-server. It is the only database in the network. A local listener resides on sales1-server and listens on nondefault port A remote listener named resides on host sales2-server and listens on port Another remote listener resides on host sales3-server and listens on port The following procedure describes how to register information with all listeners in a dedicated server environment:.
On the hosts where the remote listeners reside in this example, sales2-server and sales3-server , configure the listener. Set the parameters in the initialization file for the database on host sales1-server as follows:. In the tnsnames. For example, a listener can be defined in the init. To use an alias for the listener, it can be defined in the init. To use listener name aliases, Oracle recommends you modify the tnsnames.
Multiple addresses are supported, but connect-time failover and client load balancing features are not supported. The following errors occur:. Enabling Advanced Features of Oracle Net Services for additional information about multiple address configuration.
Oracle Net Configuration Assistant configures the listening protocol address and service information for Oracle Database. During a Custom installation, Oracle Net Configuration Assistant prompts for the listener name and protocol address.
A listening IPC protocol address for external procedure calls is automatically configured, regardless of the installation type. Oracle Net Configuration Assistant also automatically configures service information for the external procedures in the listener. If you are using the IPC protocol, then you can improve performance by specifying the maximum number of concurrent IPC connection requests to match your expected connection requests.
If the default or installed configuration is not adequate for a particular environment, then you can use Oracle Net Manager to customize the listener. This technique can create listening endpoints that service IPv6 clients. October 18, - pm UTC. Dawar, October 18, - pm UTC. Hello Tom, Sorry to bug you again. I went to holidays and now I have noticed two servers does not have tnsnames. Then I run find. But they are only samples files.
But I can connect to the database via Enterprise manager console or from the command prompt using sqlplus. Next week we need to import some test data on those servers.
Any feedback will be appreciated. October 25, - pm UTC. Tom, Sorry for incomplete answer. You said: you only need those files to connect over the network. My feed back: Yes You Said: the listener. My feed back: I am connection to the database server over the network. From my desktop to the server. Without listener. Here is my assignment I need to import data to the servers remotely over the network.
Do I need listener. Williams, October 25, - pm UTC. Tom, Actually it was firewall issue with one box. Now I can connect to the Database server over the network from my desktop PC through sqlplus or enterprise manager console.
My new question with new situation is follows: Is it possible to connect Database from client window PC over the network without listener. IF yes, how? October 26, - am UTC. You technically do not need a listener. I can connect to the database from server. NO issue. But when I tried to connect from client from my PC, I got the following message. November 20, - am UTC.
I restart the database from the server and problem has solved. On one Solaris server, we have two oracle homes 9i and 10g.
December 15, - pm UTC. Service "dtdinc. The VMWare issue doesn't have any bearing on the fact that I can't connect on the local server I am using a bridged network connection, and can ssh between the environments just fine. February 06, - pm UTC. That corrected the issue with not being able to connect from the local server.
Thanks for that I missed it. From the client the windows VMWare host , I get the same error. Do you think this could be VMWare related, even though I can ssh between the two? February 07, - pm UTC. Oracle Enterprise Linux installs by default with the "hardened" linux turned on. Had to allow through. March 12, - pm UTC. This is Windows. I tried both single and double quotes. No luck. Any ideas?
March 13, - pm UTC. How to Identify where my tnsnames. Joe, May 16, - pm UTC. The computer that I am using is using a tnsname. Is there a way for me to find out where my tnsnames. Thanks Tom! May 17, - am UTC. Where is my tnsname. We have two locations for client software that connect to another remote place for database server. Why would the first name have to be different for each site? IT seems part of the name relies on the network you are on?
March 01, - pm UTC. A rose is a rose If you are worried about file proliferation - you would use a naming service instead of files. Tom: yes the client is on same network where host is. I think there is an entry in the sqlnet. This is what might be causing it because client said if they take the "ABC. I would think you have to change the domain for each site , would not you.
But it seems you do not have to set it and just have one common tnsnames. March 02, - am UTC. If you use a - then the default domain would be. YOU make the choice whether to a have a default domain b override the default domain c whatever It is your setup - you make the choice as to what you want to do.
You need not change the domain for each site, it is just a string, just a name. You don't even have to use it if you don't want to. I was not suggesting "set it". OK, since our tnsnames. The question remain is why "a. ORA is not even being used now. THe PB application refers to connection "a". Can it be in the way PB refers to the file by alias or actual service name.
Would you try to connect from sql plus and see if it works or not? How does it get setup in the first place? March 02, - pm UTC. The default domain will be used whenever the client application doesn't supply a domain - it depends on what the application specifies - NOT what the tnsnames. Since the powerbuilder application uses just A, as I've said a couple of times already - the default domain from the sqlnet. I'm afraid to tell you "what" to do here. TOm: OK i understand what you are saying.
This means it is using the sqlnet. It is probably different on each computer. Which is best to do: 1. THat means there will be nothing to append and environment will be the same.
I mean if i set it to "oracle. Thank you,. Which is best to do Please, think about this, this is simple "configuration". You have the facts: a tnsnames. There is no such thing as "being in a domain" in this sense, it is just a naming convention. The default domain just like with networking!! A reader, March 02, - pm UTC. Tom: yes, what i am thinking is remove default domain parameter or leave it blank in sqlnet. Because your tnsnames. All Rights Reserved.
A reader, March 03, - pm UTC. Tom: Yes I was going to do either A or C. WOuld you prefer having a domain in sqlnet. I also found that some machines hae sqlnet. Is not this a MUST file for oracle client. March 03, - pm UTC. All of the files are - none are needed. TOm: another small question. How does the client know where to look for in for the file tnsnames. It is not usual to find it set Any attempt to connect to the Oracle Database will result in the following error:.
Note that all connections established before the listener stopped will be unaffected. Because stopping the listener prevents the incoming connections, it does not disconnect those that are already connected. Another way to execute the listener command is through the command line without going into the listener control interface.
0コメント