we have created a database and we wanted to create an listener for the client machines to work..there is no listener..how do i create
Printable View
we have created a database and we wanted to create an listener for the client machines to work..there is no listener..how do i create
Check $ORACLE_HOME/network/admin and there would be a sample file to configure your listener. The listener works on the server side (i.e on the server where your instance resides) the clients should have tnsnames.ora file under the same directory on the client side. The tnsnames.ora would have the entry on the service information. This again you can find under your client's $ORACLE_HOME/network/admin/samples directory.
BTW, you could modify them and then would have it under $ORACLE_HOME/network/admin directory.
If this was not the answer you were looking for, please go ahead and let us know your question in more detail.
Sam
You can also use netca to configure client and listener files...