Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PDB SERVICES

NelateJul 1 2016 — edited Jul 15 2016

Hello guys, I have a problem creating services for my pdbs. The 12c documentation say that when you create a pdb a default service with the same name as the pdb is created. So I created pdbs with the create pluggable database statement and indeed when I check the v$services view I can see new services with names like those of  my pdbs. But I fail to get a clear difference between the columns name and network_ name of the v$services. The documentation says as follows


NAME VARCHAR2(64) Service name for a queue
NAME_HASHNUMBER Hash of the short name for the service
NETWORK_NAMEVARCHAR2(512) Network name used to connect to the service

So i created by own services using the dbms_service package and made name pdb2 and network_name pdb2a. I then added name to my tnsname.ora instead of network name and I find that I am able to connect to the pdb. So what exactly is network_name for?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2016
Added on Jul 1 2016
2 comments
1,774 views