4. Create Listener and Connect with Database

Now we will create a listener to connect with database from client machine via sql-developer tool or sqlplus.

1. Start the database and exit from sqlplus.......

2. Start the netmgr

3. Select Listener and click on "+" to add listener. After that assign a name for listener 

4. Now select "Add Address"

5. Write server hostname, port number and protocol


6. Select database services


7. Write Global Database name and SID. It must be Database name then save network configuration and exit.

8. Start the listener service 

 [oracle@test DB200]$ lsnrctl start LSNTDB200

9. Now configure netca.......

10. Select Local Net Service configuration.......


11. Select add and assign a service name DB200

12. Select network protocol TCP and write the hostname and port number... If you have multiple database then assign a different port number ex:- 1522, 1523....

13. Now perform a test to check what we have done is right... If you receive invalid username/password then select change login and give the username "system" and password "same you assigned during database creation "

14. If everything is fine you will receive Test Successful. Now save net service name "DBLSNR".

15. Now connect with database with net service name.... and unlock "hr" user

     And try to connect via hr user with database...

16. Now connect with database using SQL Developer tool...

  [oracle@test DB200]$ cd $ORACLE_HOME/sqldeveloper
  [oracle@test DB200]$ ./sqldeveloper

17. Add connection and give username, password  with other details...

No comments:

Post a Comment