Hi Jack!
Check the listener services and see what is available. You can also
rename the PDB using 'alter database rename global_name to
'mydb.company.com'; The pluggable database name is the global name.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> show parameter global_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
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
Connected.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 YODA READ WRITE YES
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 11.2.0.4 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.
