Hello,
since a few weeks I try to install an Oracle 12c database and the Oracle Enterprise Manager on a Microsoft Windows Server 2008 R2 VM. Last time I had some issues connecting to the PDB, so I deleted the CDB and started over. Then I couldn't even connect to the CDB.
I chose an easy global name: "WS2014" without any domain name. Whatever I tried, I couldn't connect. So I suspect that the domain name is necessary, isn't it?
Now I created a fake domain name in my hosts file:
| 192.168.73.2 | local.com |
| 192.168.73.128 | orcl.local.com | orcl |
The new global name is now orcl.local.com, the service name of the CDB is also orcl.local.com (the Installer set it on it's own to this value) and the pdb is pdborcl.local.com.
After opening the PDB (alter pluggable database all open; why do I have to explicitly open them?) I can connect to the CDB and the PDB as well.
So my questions as stated above:
- is the domain name necessary, although it's only a fake one I set in the hosts file?
- what could have been the problem on my last setup when I chose WS2014 as the global name/service name?
- why do I have to run alter pluggable database all open; explicitly?
Thanks in advance!