Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Delete service from dba_services

880346Jun 6 2012 — edited Aug 8 2012

Hi,

I have my Production database running on 11.1.0.7 environment running on Oracle Enterprise Linux 64 bit.
Please help me clarify the doubts on database services

SQL > select name from dba_services;

NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
seeddataXDB
seeddata
MYCSMR.example.com
CONSUM
CONSUM_SEARCH
MYCSMA.example.com
QUICKSURVEY
QUICKSURVEY.example.com

10 rows selected.

SQL > sho parameter service

NAME                                 TYPE                              VALUE
------------------------------------ --------------------------------- ------------------------------
service_names                        string                            CONSUM, CONSUM_SEARCH, MYCSMA.
                                                                       example.com, QUICKSURVEY

I see this additional 2 services on dba_services view -> i.e. MYCSMR.example.com & QUICKSURVEY.example.com
Any pointers as to how I delete them from the dba_services view?

Thanks!

This post has been answered by anand prakash - oracle on Jun 6 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 4 2012

Added on Jun 6 2012

#general-database-discussions

4 comments

12,397 views