Skip to Main Content

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!

dbca - cannot delete database

AlainNov 4 2019 — edited Nov 4 2019

Hi,

Using 12.2 SE2, RAC

I made come tests on a dummy database, I want to delete the (RAC) database. As I am not sure of sys/system password, I've reset them.

bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Nov 4 12:14:53 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connecte a :

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

SQL> alter user SYS identified by SYS;

Utilisateur modifie.

SQL> alter user SYSTEM identified by SYSTEM;

Utilisateur modifie.

SQL> exit

Deconnecte de Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

bash-4.2$ srvctl status database -d CIGI

Instance CIGI1 is running on node rac-1

Instance CIGI2 is running on node rac-2

=> as oracle with 12.2 home/bin in path, dbca, delete db, select CIGI1, set SYS as password, next, next(no deregister from cloud control), finish, yes to confirm, at 14% I get ORA-01017: username/password invalid, connection refused.

WHY? Password is right as it has been reset.

Log show:

[Thread-98] [ 2019-11-04 12:24:48.417 GMT ] [ListenerImpl.getResourceName:2475]  Get listener resource name ora.LISTENER.lsnr

[Thread-98] [ 2019-11-04 12:24:48.417 GMT ] [cops.EntityOperations.Native]  prsr_trace: e_type=1

[Thread-98] [ 2019-11-04 12:24:48.439 GMT ] [EntityOperations.isEntityRegisteredCRSD:360]  entity: ora.LISTENER.lsnr, type: 1, registered: true

[Thread-98] [ 2019-11-04 12:24:48.440 GMT ] [cops.EntityOperations.Native]  prsr_trace: e_type=1

[Thread-98] [ 2019-11-04 12:24:48.459 GMT ] [EntityOperations.isEntityRegisteredCRSD:360]  entity: ora.LISTENER.lsnr, type: 1, registered: true

[Thread-98] [ 2019-11-04 12:24:48.460 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.LISTENER.lsnr, type 1, node: null

[Thread-98] [ 2019-11-04 12:24:48.460 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [TYPE]

[Thread-98] [ 2019-11-04 12:24:48.480 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<TYPE:ora.listener.type>]

[Thread-98] [ 2019-11-04 12:24:48.480 GMT ] [NodeAppsFactoryImpl.getListener:2240]  Resource type is ora.listener.type

[Thread-98] [ 2019-11-04 12:24:48.481 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.LISTENER.lsnr, type 1, node: null

[Thread-98] [ 2019-11-04 12:24:48.481 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [ENDPOINTS]

[Thread-98] [ 2019-11-04 12:24:48.500 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<ENDPOINTS:TCP:1521>]

[Thread-98] [ 2019-11-04 12:24:48.501 GMT ] [CRSCache.getAttributesFromCRS:155]  CRS: name: ora.LISTENER.lsnr, type 1, node: null

[Thread-98] [ 2019-11-04 12:24:48.501 GMT ] [CRSCache.getAttributesFromCRS:156]  attrs: [TYPE]

[Thread-98] [ 2019-11-04 12:24:48.522 GMT ] [CRSCache.getAttributesFromCRS:163]  CRS: [<TYPE:ora.listener.type>]

[Thread-98] [ 2019-11-04 12:24:48.522 GMT ] [ListenerImpl.type:1502]  Resource type is ora.listener.type

[Thread-98] [ 2019-11-04 12:24:48.523 GMT ] [ListenerType.getEnumMember:72]  listenerType is ora.listener.type, compare with ora.listener.type

[Thread-98] [ 2019-11-04 12:24:48.525 GMT ] [ListenerType.getEnumMember:72]  listenerType is ora.mgmtlsnr.type, compare with ora.listener.type

[Thread-98] [ 2019-11-04 12:24:48.525 GMT ] [ListenerType.getEnumMember:72]  listenerType is ora.mgmtlsnr.type, compare with ora.asm_listener.type

[Thread-98] [ 2019-11-04 12:24:48.525 GMT ] [ListenerType.getEnumMember:72]  listenerType is ora.mgmtlsnr.type, compare with ora.leaf_listener.type

[Thread-98] [ 2019-11-04 12:24:48.525 GMT ] [ListenerType.getEnumMember:72]  listenerType is ora.mgmtlsnr.type, compare with ora.mgmtlsnr.type

[Thread-98] [ 2019-11-04 12:24:48.530 GMT ] [EndpointsImpl.<init>:409]  Get listener endpoints from TCP:1521

[Thread-98] [ 2019-11-04 12:24:48.530 GMT ] [EndpointsImpl.<init>:435]  Token count is 1

[Thread-98] [ 2019-11-04 12:24:48.531 GMT ] [EndpointsImpl.<init>:465]  LsnrProtocol type = TCP, values = 1521

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [EndpointsImpl$LsnrProtocol.addPortValue:107]  Calling parseInt to check 1521

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [EndpointsImpl$LsnrProtocol.addPortValue:118]  Get port number 1521

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [HADatabaseUtils.getDefaultListenerConnectString:3280]  inside getDefaultListenerConnectString : ConnectString : rac-1-vip/CIGI

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [ShutdownInstanceStep.executeImpl:308]  Updating SQLEngine connect string: rac-1-vip/CIGI

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [ShutdownInstanceStep.executeImpl:321]  ShutdownInstanceStep: Local instance SID=CIGI1

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [ShutdownInstanceStep.executeImpl:322]  host is OPS true

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [ShutdownInstanceStep.executeImpl:345]  Trying to connect to database instance =CIGI1

[Thread-98] [ 2019-11-04 12:24:48.532 GMT ] [SQLEngine.getConnectCommand:1045]  Connecting using conn string: rac-1-vip/CIGI

[Thread-98] [ 2019-11-04 12:27:25.528 GMT ] [SQLEngine.done:2314]  Done called

[Thread-98] [ 2019-11-04 12:27:25.529 GMT ] [BasicStep.configureSettings:383]  messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@40d2e02a

[Thread-98] [ 2019-11-04 12:27:25.530 GMT ] [StepContext$ModeRunner.run:2961]  Connection to the database failed, verify the user name and password and try again.

oracle.sysman.assistants.dbca.backend.ShutdownInstanceStep.executeImpl(ShutdownInstanceStep.java:356)

oracle.sysman.assistants.util.step.BasicStep.execute(BasicStep.java:278)

oracle.sysman.assistants.util.step.Step.execute(Step.java:135)

oracle.sysman.assistants.util.step.StepContext$ModeRunner.run(StepContext.java:2941)

java.lang.Thread.run(Thread.java:745)

[Thread-98] [ 2019-11-04 12:27:28.823 GMT ] [SQLEngine.done:2314]  Done called

[Thread-98] [ 2019-11-04 12:27:28.823 GMT ] [Host.createStepSQLInterface:8830]  sid =CIGI1

[Thread-98] [ 2019-11-04 12:27:28.824 GMT ] [Host.createStepSQLInterface:8831]  sidOrConnectString CIGI1

[Thread-98] [ 2019-11-04 12:27:28.824 GMT ] [OracleHome.getVersion:1018]  OracleHome.getVersion called.  Current Version: null

[Thread-98] [ 2019-11-04 12:27:28.827 GMT ] [InventoryUtil.getOUIInvSession:349]  setting OUI READ level to ACCESSLEVEL_READ_LOCKLESS

[Thread-98] [ 2019-11-04 12:27:28.827 GMT ] [OracleHome.getVersion:1037]  Homeinfo /u01/app/oracle/product/12.2.0/dbhome_1,3

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1065]  OracleHome.server.getVersion Version: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1086]  Current Version From Inventory: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1018]  OracleHome.getVersion called.  Current Version: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1086]  Current Version From Inventory: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1018]  OracleHome.getVersion called.  Current Version: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [OracleHome.getVersion:1086]  Current Version From Inventory: 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [SQLPlusEngine.getCmmdParams:226]  m_home 12.2.0.1.0

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [SQLPlusEngine.getCmmdParams:227]  version > 112 true

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [SQLEngine.getEnvParams:607]  Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [SQLEngine.getEnvParams:617]  NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-98] [ 2019-11-04 12:27:28.860 GMT ] [SQLEngine.initialize:363]  Execing SQLPLUS/SVRMGR process...

[Thread-98] [ 2019-11-04 12:27:28.861 GMT ] [SQLEngine.initialize:400]  m_bReaderStarted: false

[Thread-98] [ 2019-11-04 12:27:28.861 GMT ] [SQLEngine.initialize:404]  Starting Reader Thread...

[Thread-98] [ 2019-11-04 12:27:28.861 GMT ] [SQLEngine.initialize:453]  Waiting for m_bReaderStarted to be true

[Thread-98] [ 2019-11-04 12:27:28.874 GMT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-01017

[Thread-98] [ 2019-11-04 12:27:28.874 GMT ] [StepErrorHandler.setFatalErrors:339]  setting Fatal Error: ORA-01031

[Thread-98] [ 2019-11-04 12:27:28.874 GMT ] [BasicStep.configureSettings:383]  messageHandler being set=oracle.sysman.assistants.util.InteractiveMessageHandler@40d2e02a

[Thread-98] [ 2019-11-04 12:27:28.877 GMT ] [BasicStep.configureSettings:383]  messageHandler being set=null

[Thread-98] [ 2019-11-04 12:27:28.877 GMT ] [SQLEngine.done:2314]  Done called

[progressPage.flowWorker] [ 2019-11-04 12:27:28.878 GMT ] [Host.executeSteps:6944]  runMode returned false

INFO: Nov 04, 2019 12:27:28 PM oracle.assistants.dbca.driver.DBConfigDriver setup

Comments
Post Details
Added on Nov 4 2019
1 comment
729 views