cannot delete a database through dbca
692290Jul 14 2010 — edited Jul 14 2010Hi,
I am junior dba, still learning the art...i am trying to delete a couple databases from the test server but it wont lemme...everytime i make an attempt to delte the DB through dbca, i get this error. ORA-01031: insufficient privileges...ive list down the details which mite be helpful fr u gurus to figure out wa prob is...Thanks fr readin
#OS: XP Profesiona version 2002 service pack 3
#Oracle DB: 10.2
#lsnrctl status:
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER_ORCL
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Pro
ction
Start Date 14-JUL-2010 09:34:25
Uptime 0 days 0 hr. 35 min. 23 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin\listener
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log\listener_o
l.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.17.14.97)(PORT=1521)))
Services Summary...
Service "ALASXDB" has 1 instance(s).
Instance "alas", status READY, has 1 handler(s) for this service...
Service "ALAS_XPT" has 1 instance(s).
Instance "alas", status READY, has 1 handler(s) for this service...
Service "NWCXDB" has 1 instance(s).
Instance "nwc", status READY, has 1 handler(s) for this service...
Service "NWC_XPT" has 1 instance(s).
Instance "nwc", status READY, has 1 handler(s) for this service...
Service "alas" has 1 instance(s).
Instance "alas", status READY, has 1 handler(s) for this service...
Service "nwc" has 1 instance(s).
Instance "nwc", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
# Able to ping:Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.1
4.97)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ALAS)))
C:\Documents and Settings\admin>tnsping nwc
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-JUL-2
010 10:11:29
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=nwc))(ADDRESS=(PR
OTOCOL=TCP)(HOST=172.17.14.97)(PORT=1521)))
OK (10 msec)
C:\Documents and Settings\admin>