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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
677 views