search

oraclesean / cloud-native-oracle

A repository of container image builds for Oracle databases, with support for Intel, Apple Silicon, and ARM processors.
31 stars 6 forks source link

invalid username/password; logon denied #5

Closed rutcreate closed 7 months ago

rutcreate commented 7 months ago

I'm on Mac M1 and follows your step and everything goes well.

2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:52   Oracle password for SYS, SYSTEM and PDBADMIN: 37fAK5y_t#hL35 
2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:52 
2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:52   runDBCA: Running DBCA for database TESTDB at 2024-02-05 09:44:52
2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:52 
2024-02-05 16:44:52 LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 05-FEB-2024 09:44:52
2024-02-05 16:44:52 
2024-02-05 16:44:52 Copyright (c) 1991, 2023, Oracle.  All rights reserved.
2024-02-05 16:44:52 
2024-02-05 16:44:52 Starting /u01/app/oracle/product/19.19/dbhome_1/bin/tnslsnr: please wait...
2024-02-05 16:44:52 
2024-02-05 16:44:52 TNSLSNR for Linux: Version 19.0.0.0.0 - Production
2024-02-05 16:44:52 System parameter file is /u01/app/oracle/product/19.19/dbhome_1/network/admin/listener.ora
2024-02-05 16:44:52 Log messages written to /u01/app/oracle/diag/tnslsnr/103f2dea342f/listener/alert/log.xml
2024-02-05 16:44:52 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
2024-02-05 16:44:52 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
2024-02-05 16:44:52 
2024-02-05 16:44:52 Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
2024-02-05 16:44:52 STATUS of the LISTENER
2024-02-05 16:44:52 ------------------------
2024-02-05 16:44:52 Alias                     LISTENER
2024-02-05 16:44:52 Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
2024-02-05 16:44:52 Start Date                05-FEB-2024 09:44:52
2024-02-05 16:44:52 Uptime                    0 days 0 hr. 0 min. 0 sec
2024-02-05 16:44:52 Trace Level               off
2024-02-05 16:44:52 Security                  ON: Local OS Authentication
2024-02-05 16:44:52 SNMP                      OFF
2024-02-05 16:44:52 Listener Parameter File   /u01/app/oracle/product/19.19/dbhome_1/network/admin/listener.ora
2024-02-05 16:44:52 Listener Log File         /u01/app/oracle/diag/tnslsnr/103f2dea342f/listener/alert/log.xml
2024-02-05 16:44:52 Listening Endpoints Summary...
2024-02-05 16:44:52   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
2024-02-05 16:44:52   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
2024-02-05 16:44:52 Services Summary...
2024-02-05 16:44:52 Service "TESTDB" has 1 instance(s).
2024-02-05 16:44:52   Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service...
2024-02-05 16:44:52 The command completed successfully
2024-02-05 16:44:52 
2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:52   runDBCA: Creating container database TESTDB and 1 pluggable database(s) with name TESTDBPDB1 at 2024-02-05 09:44:52
2024-02-05 16:44:52 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:44:59 Prepare for db operation
2024-02-05 16:44:59 8% complete
2024-02-05 16:44:59 Copying database files
2024-02-05 16:46:16 31% complete
2024-02-05 16:46:16 Creating and starting Oracle instance
2024-02-05 16:46:41 32% complete
2024-02-05 16:46:57 36% complete
2024-02-05 16:49:53 40% complete
2024-02-05 16:49:53 43% complete
2024-02-05 16:50:17 46% complete
2024-02-05 16:50:17 Completing Database Creation
2024-02-05 16:50:21 51% complete
2024-02-05 16:53:29 54% complete
2024-02-05 16:53:29 Creating Pluggable Databases
2024-02-05 16:53:41 58% complete
2024-02-05 16:53:41 77% complete
2024-02-05 16:53:41 Executing Post Configuration Actions
2024-02-05 16:53:41 100% complete
2024-02-05 16:53:41 Database creation complete. For details check the logfiles at:
2024-02-05 16:53:41  /u01/app/oracle/cfgtoollogs/dbca/TESTDB.
2024-02-05 16:53:41 Database Information:
2024-02-05 16:53:41 Global Database Name:TESTDB
2024-02-05 16:53:41 System Identifier(SID):TESTDB
2024-02-05 16:53:41 Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/TESTDB/TESTDB.log" for further details.
2024-02-05 16:53:42 
2024-02-05 16:53:42 Pluggable database altered.
2024-02-05 16:53:42 
2024-02-05 16:53:42 
2024-02-05 16:53:42 Pluggable database altered.
2024-02-05 16:53:42 
2024-02-05 16:53:42 
2024-02-05 16:53:42 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:53:42   runDBCA: DBCA complete at 2024-02-05 09:53:42
2024-02-05 16:53:42 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:53:42 
2024-02-05 16:53:42 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:53:42   Database TESTDB with unique name TESTDB is open and available. 
2024-02-05 16:53:42 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:53:42 
2024-02-05 16:53:42 # ----------------------------------------------------------------------------------------------- #
2024-02-05 16:53:42   Tailing alert_TESTDB.log: 
2024-02-05 16:53:42 2024-02-05T09:53:41.383556+00:00
2024-02-05 16:53:42 TESTDBPDB1(3):CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
2024-02-05 16:53:42 TESTDBPDB1(3):Completed: CREATE SMALLFILE TABLESPACE "USERS" LOGGING  DATAFILE  SIZE 5M AUTOEXTEND ON NEXT  1280K MAXSIZE UNLIMITED  EXTENT MANAGEMENT LOCAL  SEGMENT SPACE MANAGEMENT  AUTO
2024-02-05 16:53:42 TESTDBPDB1(3):ALTER DATABASE DEFAULT TABLESPACE "USERS"
2024-02-05 16:53:42 TESTDBPDB1(3):Completed: ALTER DATABASE DEFAULT TABLESPACE "USERS"
2024-02-05 16:53:42 2024-02-05T09:53:42.471120+00:00
2024-02-05 16:53:42 alter pluggable database all open
2024-02-05 16:53:42 Completed: alter pluggable database all open
2024-02-05 16:53:42 alter pluggable database all save state
2024-02-05 16:53:42 Completed: alter pluggable database all save state

But after run container and shell to the container to access the database via sqlplus with both PDBADMIN:<password appeared in log> and TESTDBPDB1:<password appeared in log> but none of them works.

sqlplus 'TESTDBPDB1/"37fAK5y_t#hL35"@localhost:1521/TESTDB'

>>> ERROR:
ORA-01017: invalid username/password; logon denied
sqlplus 'PDBADMIN/"37fAK5y_t#hL35"@localhost:1521/TESTDB'

>>> ERROR:
ORA-01017: invalid username/password; logon denied

Any ideas?

rutcreate commented 7 months ago

My bad. The database should be TESTDBPDB1 so the command should be:

sqlplus 'PDBADMIN/"37fAK5y_t#hL35"@localhost:1521/TESTDBPDB1'

I will mark this as closed.

oraclesean commented 7 months ago

Perfect; thanks @rutcreate for trying out the repo!