Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Oracle 12c New Features

Online Oracle Training


Create a net service name using the netca tool


In this, you will create the mypdb1 net service name for the mypdb1 pluggable database of mycdb in the tnsnames.ora file.


To run the netca tool:

Run the mycdb profile.

# cd ~

# . ./.profile


Execute the netca tool.

# netca


Step 1:

Select the "Local Net Service Name configuration" and then click "Next."


Step 2:

Accept "Add" and then click "Next."


Step 3:

On the Service Name page, type the mypdb1 service name and then click "Next."


Step 4:

Select the TCP protocols and click "Next."


Step 5:

On the TCP/IP Protocol page, type your host name and use the 1521 port number. Then click "Next."


Step 6:

If the mypdb1 pluggable database was opened, then you can test. If not select "No, do not test,"  then click "Next."


Step 7:

Accept the mypdb1 service name as Net Service Name and then click "Next."


Step 8:

If you have more service name to create, then select "Yes." If not, then select "No."


Step 9:

Click Next and Finish.


Check the tnsnams.ora file and make sure your entries was added to the file.

# vi $ORACLE_HOME/network/admin/tnsnames.ora


Use the tnsping tool.

# tnsping mypdb1


Access to the mypdb1 pluggable database by using created mypdb1 service name:

# sqlplus /nolog

SQL> connect  system/mypass@mypdb1


Good Luck!



Web web site