인프런 커뮤니티 질문&답변

안녕하세요. swingbench 에러좀 확인부탁드려요

● 배경 : 오라클19c 설치 후 Swingbench Oracle Entry Install에서

아래정보로 계정생성,테이블,인덱스 생성하다가

SOE_10G DB계정 접속불가로 DB계정이 계속 LOCK 됩니다.

-- Swingbench Oracle Entry Install Wizard 에서 설정정보

Username : SOE_10G

Password : SOE_10G

Schema's Tablespace : SOE_10G

● 다른테스트 : 아래와 같이 계정생성하여 서버에서 로그인도 해봤지만 유저명/패스워드가 틀리다고 나옵니다.

-- 기존 계정삭제

DROP USER SOE_10G CASCADE;

-- 계정 확인

SELECT * FROM dba_users WHERE username = 'SOE_10G';

-- 계정생성

CREATE USER SOE_10G

IDENTIFIED BY SOE_10G

DEFAULT TABLESPACE SOE_10G

TEMPORARY TABLESPACE TEMP;

GRANT connect, resource, dba TO SOE_10G;

sqlplus / as sysdba

-- 로그인

conn SOE_10G/SOE_10G

 ●  Swingbench Oracle Entry Install Wizard 실행시 에러부분 로그 :

Apr 27, 2024 5:19:56 AM com.dom.datagen.kernel.DatabaseGenerationThread run

SEVERE: Unexpected Error when attempting to insert comma delimited row :

java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
.....
Apr 27, 2024 5:19:56 AM com.dom.datagen.kernel.DatabaseGenerationThread run

SEVERE: Unexpected Error when attempting to insert comma delimited row :

java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
.....
Apr 27, 2024 5:19:56 AM com.dom.datagen.kernel.DatabaseGenerationThread run

SEVERE: Unexpected Error when attempting to insert comma delimited row :

java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

.....
Apr 27, 2024 5:19:56 AM com.dom.datagen.kernel.DatabaseGenerationThread run

SEVERE: Unexpected Error when attempting to insert comma delimited row :

java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

 .....

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.pumpEvents(Unknown Source)

at java.awt.EventDispatchThread.run(Unknown Source)

Apr 27, 2024 5:19:58 AM com.dom.datagen.kernel.DatabaseGenerationThread run

SEVERE: Unexpected Error when attempting to insert comma delimited row :

java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-28000: The account is locked.

at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:456)

at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:133)