Thanks for the question, Paul.
Asked: July 16, 2025 - 11:33 am UTC
Last updated: August 01, 2025 - 4:05 am UTC
Version: 21c
Viewed 1000+ times
You Asked
Hi Tom,
I recently changed the name of a database using DBNEWID and I have a question about the resulting situation with system generated service names.
I now see the folllowing list of services (obfuscated):
SQL> select CON_ID , NAME , NETWORK_NAME from cdb_services
CON_ID NAME NETWORK_NAME
---------- ---------------------------------------------------------------- --------------------
1 SYS$BACKGROUND
1 SYS$USERS
1 newnameXDB newnameXDB
1 newname newname
1 oldnameXDB oldnameXDB
1 oldname oldname
3 PDBABC PDBABC
I would like to know if it is OK to remove the two services represented by "oldname" and "oldnameXDB"?
If so, what would be the recommended method to achieve this given that my database is a standalone database running in Standard Edition.
Best Regards,
Paul.
and Connor said...
Yes you can remove them but first ensure you are not still using them anywhere, so check things like
- sqlnet.ora, listener.ora, tnsnames.ora
- service_names parameter
- anywhere in clusterware if you're using it
Perhaps look at stopping the services first, making sure no-one or nothing "screams" and then remove at a later time.