I am in the process of creating Standards and best practices for creating RAC Services.
Wondering what is the maximum length/characters I can use in a RAC service name ?
The documentation
https://docs.oracle.com/database/121/RACAD/GUID-6BC01F04-C46F-47BD-9AAC-CFA88F3D5911.htm#RACAD5013 says "The -service parameter has a 4 kilobyte (KB) limit for its value. Therefore, the total length of the names of all services assigned to an instance cannot exceed 4 KB."
How do I calculate the value of all the total services created for a particular instance in Kilo Bytes ?
Regards,
Suri Babu
You can get the list of services via srvctl, eg
$ srvctl status service -db apps
Service erp is running on nodes: apps02,apps03
Service hr is running on nodes: apps02,apps03
Service sales is running on nodes: apps01,apps04
I know on our cloud our service names are quite long, eg, "wkrfs4xeq12a1jcu_qwed1ddbatp_tp.atp.oraclecloud.com", so unless you go ridiculously large, I contend you should be fine.