Database DataWarehousing (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center