OraFAQ Forum: Server Administration » Deleting a Service , ORA-44305 Error

Home » RDBMS Server » Server Administration » Deleting a Service , ORA-44305 Error (Oracle Enterprise Edition 10.2.0.2 on Solaris.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Deleting a Service , ORA-44305 Error [message #285848]

Wed, 05 December 2007 21:52

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

SQL> select name from service$;

NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
seeddataXDB
seeddata
arjuXDB
arju.net
arju

7 rows selected.

SQL>  exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL> exec dbms_service.stop_service('arju');

PL/SQL procedure successfully completed.

SQL>  exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1

How I can be able to delete service? I tried in different ways but I failed. ORA-44305 Error.

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285849 is a reply to message #285848]

Wed, 05 December 2007 21:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

44305, 0000, "service %s is running"
// *Document : Yes
// *Cause    : The specified service was running.
// *Action   : This message is informational only.

Perhaps it is a case where privs acquired via ROLE do not apply within PL/SQL procedures.

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285850 is a reply to message #285848]

Wed, 05 December 2007 22:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Below is what I see on 1 of my production servers.


SQL*Plus: Release 10.2.0.2.0 - Production on Wed Dec 5 19:56:36 2007

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select name from service$;

NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
seeddataXDB
seeddata.regress.rdbms.dev.us.oracle.com
comdb03XDB
comdb03.comdb03.example.com

6 rows selected.

I was unaware that I had anything to do with XDB on this box.
I have no idea what "seeddata" is for & from where it came.

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285852 is a reply to message #285848]

Wed, 05 December 2007 22:02

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

it is a case where privs acquired via ROLE do not apply within PL/SQL procedures.

No Anacedent it is not a case like that. Suppose when I execute,

SQL> exec dbms_service.delete_service('arju.net');

PL/SQL procedure successfully completed.

arju service can't be deleted. I tried through different way. Such as,

SQL> !lsnrctl stop

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 06-DEC-2007 09:54:06

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully

SQL>  exec dbms_service.stop_service('arju');

PL/SQL procedure successfully completed.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2069712 bytes
Variable Size             125831984 bytes
Database Buffers           37748736 bytes
Redo Buffers                6316032 bytes
Database mounted.
Database opened.
SQL> exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      arju
SQL>  exec dbms_service.create_service('amarnew', 'amarnew');

PL/SQL procedure successfully completed.

SQL>  select name from service$;

NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
seeddataXDB
seeddata
arjuXDB
amarnew
arju

7 rows selected.

SQL> exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL>  exec dbms_service.stop_service('arju');

PL/SQL procedure successfully completed.

SQL> exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string
SQL> alter system set service_names='amarnew';

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  171966464 bytes
Fixed Size                  2069712 bytes
Variable Size             125831984 bytes
Database Buffers           37748736 bytes
Redo Buffers                6316032 bytes
Database mounted.
Database opened.
SQL> exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      amarnew
SQL>  exec dbms_service.stop_service('arju');

PL/SQL procedure successfully completed.

SQL>  exec dbms_service.delete_service('arju');
BEGIN dbms_service.delete_service('arju'); END;

*
ERROR at line 1:
ORA-44305: service arju is running
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_SERVICE", line 434
ORA-06512: at "SYS.DBMS_SERVICE", line 323
ORA-06512: at line 1


SQL> show user
USER is "SYS"

Any suggestion.

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285862 is a reply to message #285848]

Wed, 05 December 2007 23:15

varu123
Messages: 754
Registered: October 2007

Senior Member

Can't you use ORADIM ?

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285865 is a reply to message #285848]

Wed, 05 December 2007 23:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

ORADIM is for windows only, I live on Solaris. Cool

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285867 is a reply to message #285848]

Wed, 05 December 2007 23:22

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Look at the heading,

 Deleting a Service , ORA-44305 Error (Oracle Enterprise Edition 10.2.0.2 on Solaris.)

Are you aware of ORA-44305 Error.

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285869 is a reply to message #285848]

Wed, 05 December 2007 23:29

varu123
Messages: 754
Registered: October 2007

Senior Member

oh yes,
please ignore my message

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285871 is a reply to message #285848]

Wed, 05 December 2007 23:39

varu123
Messages: 754
Registered: October 2007

Senior Member

after issuing the commands,did you check in service$ view?

Report message to a moderator

Re: Deleting a Service , ORA-44305 Error [message #285877 is a reply to message #285848]

Wed, 05 December 2007 23:58

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

service$ is a table.

I check it is remained same. Actually need not to check service$ as it says error while deleting. This cause only for arju. I guess it will raise error because arjuXDB remain.So I deleted arjuXDB which was successful and later tried to delete arju service but failed.

Report message to a moderator