DBA Hub

📋Steps in this guide1/1

LISTENER

In this Blog i have shown how to configure dynamic and static listener service registration.

oracle configurationintermediate
by OracleDba
12 views
1

Task is to create a connection string to connect to Batch33 database. Assumption is you already have oracle client installed on your laptop. If not, you will want to install it first.

Solutions: # Description Command / Details / Screenshots 1 - Click on magnifier on windows 10. Click on magnifier on windows 10. - Type cmd Type cmd - Right click on cmd Right click on cmd - Click on Run as Administrator Click on Run as Administrator 2 Type netca in command prompt to start “network configuration assistant” 3 Click on LOCAL NET SERVICE NAME CONFIGURATION Click on ADD 4 Add the service name you want to add. SERVICE NAME: Batch33 Similarly, if your database name is called “MarsDB” then the service name you want to put in as “MarsDB”. 5 Use “TCP” as the protocol. Click NEXT. 6 Give the IP Address or the Hostname where database is hosted. If you are my student, use the following: Hostname: ssh.**********.com Port: 1521 Note-1 : If you do not know the hostname, send me an email and I will provide you the hostname. 7 Click on “No, do not test” and click Next. 8 Provide your database name for “Net Service Name” and click Next. 9 Since we do not want to configure another new service name, lets select NO and click NEXT 10 Click NEXT to proceed. 11 Click FINISH. 12 Verify the connection string is created in TNSNames.ora file. Tnsnames.ora file resides in: C:\u01\app\oracle\product\12.2.0\client_1 13 Change permission of tnsnames.ora file so that you can edit it manually. Right click on tnsnames.ora file and click “Properties. 14 Click on SECURITY Click the AUTHENTICATED USERS Click EDIT 15 Click on checkbox of FULL CONTROl Click APPLY Additionally, you may repeat the same for all users. 16 Double click on tnsnames.ora file to open it. 17 Verify the connection string is created. You want to verify the following: - Hostname: sql.*********.com Hostname: sql.*********.com - Port: 1521 Port: 1521 - Protocol: TCP Protocol: TCP - SERVICE_NAME: Batch33 SERVICE_NAME: Batch33

Comments (0)

Please to add comments

No comments yet. Be the first to comment!