OS 환경 : Oracle Linux 8.4 (64bit)
DB 환경 : Oracle Database 23.3.0.23.09 Free
에러 : [DBT-05509] Failed to connect to the specified database (Free).
db 삭제 후 재설치시 발생하는 에러
재설치 시도
1
2
3
4
|
# /etc/init.d/oracle-free-23c configure
[FATAL] [DBT-05509] Failed to connect to the specified database (Free).
CAUSE: OS Authentication might be disabled for this database (Free).
ACTION: Specify a valid sysdba user name and password to connect to the database.
|
에러 발생함
dbca나 dbca silent mode에서도 동일하게 에러가 발생함
.bash_profile의 LD_LIBRARY_PATH 이나 PATH가 잘못된 경우 이런 문제가 발생할 수 있다고 해서
다시 추가해봤지만 동일했음
패스워드 파일 관련 해결방법도 나와서 수동으로 패스워드 파일을 만들어줘도 동일하게 에러가 발생했음
해결 방법 : 현재 실행중인 오라클 프로세스 kill 후 재시도
db제거 프로세스를 진행했을때 Database deletion completed.가 나오며 진행이 완료됬지만
중간에 에러가 일부 발생했었고 datafile이 제대로 지워지지 않았음
그래서 수동으로 datafile들을 지워줬는데, 실제로 오라클 프로세스까지도 내려가지 않았던것으로 보임
삭제 시 로그
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
# /etc/init.d/oracle-free-23c delete
Deleting Oracle Listener.
Deleting Oracle Database FREE.
[WARNING] [DBT-05509] Failed to connect to the specified database (FREE).
CAUSE: OS Authentication might be disabled for this database (FREE).
ACTION: Specify a valid sysdba user name and password to connect to the database.
[WARNING] [DBT-11503] The instance (FREE) is not running on the local node. This may result in partial delete of Oracle database.
CAUSE: A locally running instance is required for complete deletion of Oracle database instance and database files.
ACTION: Specify a locally running database, or execute DBCA on a node where the database instance is running.
[WARNING] [DBT-19202] The Database Configuration Assistant will delete the Oracle instances and datafiles for your database. All information in the database will be destroyed.
Prepare for db operation
32% complete
Connecting to database
35% complete
36% complete
[WARNING] ORA-12547: TNS:lost contact
39% complete
42% complete
45% complete
49% complete
52% complete
ORA-12547: TNS:lost contact
65% complete
Updating network configuration files
68% complete
Deleting instance and datafiles
84% complete
100% complete
Database deletion completed.
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE0.log" for further details.
|
현재 실행중인 오라클 프로세스 확인(pmon)
1
2
3
|
$ ps -ef|grep pmon
oracle 2169 1 0 Apr27 ? 00:00:06 db_pmon_FREE
oracle 85427 85274 0 18:14 pts/0 00:00:00 grep --color=auto pmon
|
pmon kill 진행
1
|
$ kill -9 2169
|
현재 실행중인 오라클 프로세스 확인(나머지)
1
2
3
4
5
6
7
|
$ ps -ef|grep ora
oracle 61358 1 0 07:01 ? 00:00:01 /opt/oracle/product/23c/dbhomeFree/bin/tnslsnr LISTENER -inherit
root 84693 84692 0 17:55 pts/0 00:00:00 bash -c su - oracle; $SHELL -i
root 85273 84886 0 18:10 pts/0 00:00:00 su - oracle
oracle 85274 85273 0 18:10 pts/0 00:00:00 -bash
oracle 85482 85274 0 18:18 pts/0 00:00:00 ps -ef
oracle 85483 85274 0 18:18 pts/0 00:00:00 grep --color=auto ora
|
리스너가 실행중임
리스너 프로세스 kill 진행
1
|
$ kill -9 2169
|
db 설치 재시도
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
# /etc/init.d/oracle-free-23c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password: *********
Enter SYSTEM user password:
*****
Enter PDBADMIN User Password:
*****
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE1.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: oel8/FREEPDB1
Multitenant container database: oel8
|
정상적으로 진행됨
원인 : 오라클 프로세스가 제대로 종료되지 않아 발생한 문제
오라클 프로세스가 제대로 종료되지 않아 발생한 문제
kill 후 정상적으로 설치가 진행됨
참조 :
'ORACLE > Trouble Shooting' 카테고리의 다른 글
CORRUPTION DETECTED: thread 1 sequence 8 log 2 at block 42224. Arch found corrupt blocks (0) | 2024.07.22 |
---|---|
ORA-63805: Maximum number of tuples in Table Value Constructor exceeded (0) | 2024.06.18 |
ORA-27086: unable to lock file - already in use (0) | 2024.04.24 |
ORA-09968: unable to lock file (0) | 2024.04.20 |
ORA-00441: Oracle Free Edition SID violation. Expected:free vs Actual:NON (0) | 2024.04.16 |