Re: 18c Service Names

From: Mladen Gogala <>
Date: Sun, 5 Jul 2020 21:10:05 -0400
Message-ID: <>

Hi Jack!

Check the listener services and see what is available. You can also rename the PDB using 'alter database rename global_name to ''; The pluggable database name is the global name.

SQL> show pdbs


---------- ------------------------------ ---------- ----------

SQL> alter session set container=ORCLPDB;

Session altered.

SQL> show parameter global_name;


------------------------------------ ----------- ------------------------------
global_names			     boolean	 FALSE

SQL> alter database rename global_name to yoda; alter database rename global_name to yoda *
ERROR at line 1:
ORA-65045: pluggable database not in a restricted mode

SQL> alter system enable restricted session;

System altered.

SQL> alter database rename global_name to yoda;

Database altered.

SQL> connect / as sysdba
SQL> show pdbs


---------- ------------------------------ ---------- ----------

SQL> Of course, you can use any other name, like Aniken, Vader, Palpatine, Obivan, or Skywalker.

May the force be with you!

On 7/5/20 5:01 PM, Jack Applewhite wrote:
> New environment: 18c EE on X8-2M Bare Metal at ODA 18.8 - Single Instances
> I've been testing for migration of DBs on an X5 ODA to the
> new environment above, multi-tenant. We have ThisDB and ThatDB on the X5.
> †-- I created CDB1 on the X8 with ThisDBX and ThatDBX PDBs. Did
> exports from 11g DBs and imported them into 18c DBs. Opened them for
> testing by Users, which is why I wanted the X suffix so they'd know
> where they were.
> -- In the iterative process, I created CDB2 as well and cloned ThisDBX
> and ThatDBX to it as ThxxDBX1,2,3,etc. and ThxxDBX1,2,3,etc., each
> time then unplugging ThxxDBX1,2,3 to separate .pdb files. I used those
> to plug in to CDB1 for startover points. It all worked great.
> -- Now, when I want to do the final cutover from 11g ThisDB and
> ThatDB, I drop the current 18c ThxxDBX PDBs and attempt to create new
> PDBs from the last .pdb files. I want to name them ThisDB and ThatDB,
> and can create them OK. However, when I attempt to open them I get:
> Alter Pluggable Database ThisDB Open Read Write ;
> Error report -
> ORA-44303: service name exists
> ORA-44775: Pluggable database service cannot be created.
> 44303. 0000 - †"service name exists"
> *Document: Yes
> *Cause: † †This service name was already in existence.
> *Action: † Provide a new unique service name.
> I query v$Services and there is no ThisDB service. I've looked through
> the 18c docs and on MOS, but can't find anywhere that there's a
> restriction on Service Names. It looks to me like I can have ThisDBX
> and ThisDBY, but can't have the subset ThisDB. Is that a fact? If so,
> where is it documented? If not, can I fix this?
> I've tried it by using the Service_Name_Convert function, but that
> didn't work either and the error message said to try to use the
> "appropriate" Service_Name_Convert string but, of course, no clue as
> to what that might be.
> I'm at a loss.
> Thanks.
> --
> Jack C. Applewhite - Database Administrator
> Austin I.S.D. - MIS Department
> 512.414.9250 (wk)
> I cannot help but notice that there is no problem between us that
> cannot be solved by your departure. †-- Mark Twain
> Confidentiality Notice: This email message, including all attachments,
> is for the sole use of the intended recipient(s) and may contain
> confidential student and/or employee information. Unauthorized use of
> disclosure is prohibited under the federal Family Educational Rights &
> Privacy Act (20 U.S.C. ß1232g, 34 CFR Part 99, 19 TAC 247.2, Govít
> Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not
> the intended recipient, you may not use, disclose, copy or disseminate
> this information. Please call the sender immediately or reply by email
> and destroy all copies of the original message, including attachments.

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Mon Jul 06 2020 - 03:10:05 CEST

Original text of this message