after autoupgrade, service name not in dba_services and cannot be deleted
HI everyone,
Please help
service is not working afterwards. service name not in dba_services, so I created and it says it already exists .
also cannot delete
SQL> select NAME from dba_services;
NAME
------------------------------
grhqa004
SQL> BEGIN
DBMS_SERVICE.create_service(
service_name => 'grhqa004_tp',
network_name => 'grhqa004_tp'
);
END;
/
BEGIN
*
ERROR at line 1:
ORA-44303: service name exists
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 21
ORA-06512: at "SYS.DBMS_SERVICE", line 316
ORA-06512: at line 2
SQL> BEGIN
DBMS_SERVICE.delete_service(
service_name => 'grhqa004_tp'
);
END;
/
BEGIN
*
ERROR at line 1:
ORA-44304: service grhqa004_tp does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86