Home » RDBMS Server » Server Administration » Deleting a Service , ORA-44305 Error (Oracle Enterprise Edition 10.2.0.2 on Solaris.)
Deleting a Service , ORA-44305 Error [message #285848] Wed, 05 December 2007 21:52 Go to next message
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.
Re: Deleting a Service , ORA-44305 Error [message #285849 is a reply to message #285848] Wed, 05 December 2007 21:55 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Deleting a Service , ORA-44305 Error [message #285850 is a reply to message #285848] Wed, 05 December 2007 22:00 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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.
Re: Deleting a Service , ORA-44305 Error [message #285852 is a reply to message #285848] Wed, 05 December 2007 22:02 Go to previous messageGo to next message
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.
Re: Deleting a Service , ORA-44305 Error [message #285862 is a reply to message #285848] Wed, 05 December 2007 23:15 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Can't you use ORADIM ?
Re: Deleting a Service , ORA-44305 Error [message #285865 is a reply to message #285848] Wed, 05 December 2007 23:21 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ORADIM is for windows only, I live on Solaris. Cool
Re: Deleting a Service , ORA-44305 Error [message #285867 is a reply to message #285848] Wed, 05 December 2007 23:22 Go to previous messageGo to next message
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.
Re: Deleting a Service , ORA-44305 Error [message #285869 is a reply to message #285848] Wed, 05 December 2007 23:29 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
oh yes,
please ignore my message
Re: Deleting a Service , ORA-44305 Error [message #285871 is a reply to message #285848] Wed, 05 December 2007 23:39 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
after issuing the commands,did you check in service$ view?
Re: Deleting a Service , ORA-44305 Error [message #285877 is a reply to message #285848] Wed, 05 December 2007 23:58 Go to previous messageGo to next message
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.
Re: Deleting a Service , ORA-44305 Error [message #285888 is a reply to message #285848] Thu, 06 December 2007 00:14 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
I don't understand when you stopped the service "arju",why the error message says "service arju is running"?
Re: Deleting a Service , ORA-44305 Error [message #286133 is a reply to message #285888] Thu, 06 December 2007 10:08 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Try to remove this from tnsnames.ora and bounce your listener and do the same to delete the service.
Previous Topic: strange objects
Next Topic: listener failed
Goto Forum:
  


Current Time: Thu Dec 08 21:58:04 CST 2016

Total time taken to generate the page: 0.13315 seconds