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