文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >打开存档日志后，Oracle19c容器无法启动

问打开存档日志后，Oracle19c容器无法启动
EN

Database Administration用户
提问于 2023-05-28 12:21:57
回答 1查看 18关注 0票数 0

我在运行oracle19c容器。

这是停靠-撰写文件：

代码语言：javascript
复制
version: '3.7'
services:
  oracle:
    image: container-registry.oracle.com/database/enterprise:19.3.0.0
    container_name: oracle19c
    ports:
      - 1521:1521
    volumes:
      - oracle19c:/opt/oracle/oradata
      - /etc/localtime:/etc/localtime
    shm_size: '2gb'
networks:
  oracle19c:
    external: yes
volumes:
  oracle19c:
    external: yes

在我打开档案之前一切都很好。

代码语言：javascript
复制
sqlplus sys / as sysdba

SQL> shutdown immediate;
    Database closed.
    Database dismounted.
    ORACLE instance shut down.

SQL> startup mount;
    ORACLE instance started.

SQL> alter database archivelog;
    Database altered.

SQL> alter database open;
    Database altered.

然后数据库关闭，我不能再启动它了，这是停靠日志：

代码语言：javascript
复制
[root@ATM-6601509-10 oracle_19c]# docker logs oracle19c -f
[2023:05:28 18:35:27]: Acquiring lock .ORCLCDB.create_lck with heartbeat 30 secs
[2023:05:28 18:35:27]: Lock acquired
[2023:05:28 18:35:27]: Starting heartbeat
[2023:05:28 18:35:27]: Lock held .ORCLCDB.create_lck
ORACLE EDITION: ENTERPRISE

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:35:27 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 1 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:35:33 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 2 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:35:39 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 3 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:35:46 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 4 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:35:54 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 5 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:36:03 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 6 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:36:13 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 7 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:36:24 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 8 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:36:36 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 9 sec(s) before restarting Oracle processes

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:36:49 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> Disconnected
Waiting for 10 sec(s) before restarting Oracle processes
[2023:05:28 18:37:04]: Releasing lock .ORCLCDB.create_lck
[2023:05:28 18:37:04]: Lock released .ORCLCDB.create_lck
[2023:05:28 18:37:04]: Acquiring lock .ORCLCDB.exist_lck with heartbeat 30 secs
[2023:05:28 18:37:04]: Lock acquired
[2023:05:28 18:37:04]: Starting heartbeat
[2023:05:28 18:37:04]: Lock held .ORCLCDB.exist_lck

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 28-MAY-2023 18:37:04

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Starting /opt/oracle/product/19c/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/ed39669f3ec6/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                28-MAY-2023 18:37:04
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/oracle/product/19c/dbhome_1/network/admin/listener.ora
Listener Log File         /opt/oracle/diag/tnslsnr/ed39669f3ec6/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:04 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 1 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:09 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 2 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:15 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 3 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:22 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 4 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:31 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 5 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:40 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 6 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:37:50 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 7 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:38:01 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 8 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:38:13 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 9 sec(s) before restarting Oracle processes and opening the database

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 18:38:26 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance shut down.
SQL> ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> SQL>    alter database mount
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter pluggable database all open
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL>    alter system register
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0


SQL> Disconnected
The Oracle base remains unchanged with value /opt/oracle
Waiting for 10 sec(s) before restarting Oracle processes and opening the database
The Oracle base remains unchanged with value /opt/oracle
#####################################
########### E R R O R ###############
DATABASE SETUP WAS NOT SUCCESSFUL!
Please check output for further info!
########### E R R O R ###############
#####################################
The following output is now a tail of the alert.log:
tail: cannot open '/opt/oracle/diag/rdbms/*/*/trace/alert*.log' for reading: No such file or directory
tail: no files remaining

这似乎是oracle19c在寻找init文件initORCLCDB.ora。

实际上，在码头内，没有initORCLCDB.ora文件。

代码语言：javascript
复制
[root@ATM-6601509-10 oracle_19c]# docker exec -it oracle19c bash
bash-4.2$ cd /opt/oracle/product/19c/dbhome_1/dbs/
bash-4.2$ ls -la
total 4
drwxr-xr-x 2 oracle dba        67 May 28 17:23 .
drwxr-xr-x 1 oracle dba        60 May 28 18:37 ..
-rw-r--r-- 1 oracle dba      3079 May 14  2015 init.ora
lrwxrwxrwx 1 oracle oinstall   49 May 28 17:23 orapwORCLCDB -> /opt/oracle/oradata/dbconfig/ORCLCDB/orapwORCLCDB
lrwxrwxrwx 1 oracle oinstall   54 May 28 17:23 spfileORCLCDB.ora -> /opt/oracle/oradata/dbconfig/ORCLCDB/spfileORCLCDB.ora

我不知道它为什么要寻找那个initORCLCDB.ora文件。因为默认情况下，在坞内没有那个initORCLCDB.ora文件(我在其他服务器中创建了新的对接器并检查它，根本没有那个文件)。

我尝试用几个选项启动数据库，但仍然失败：

代码语言：javascript
复制
[root@ATM-6601509-10 oracle_19c]# docker-compose up -d
WARNING: Some networks were defined but are not used by any service: oracle19c
Starting oracle19c ... done
[root@ATM-6601509-10 oracle_19c]# docker exec -it oracle19c bash
bash-4.2$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun May 28 20:16:13 2023
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> shutdown;
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: 1135834575
Process ID: 0
Session ID: 0 Serial number: 0


SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora'
SQL> startup spfile=/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora;
SP2-0714: invalid combination of STARTUP options

当我从现有的sfile创建pfile时，它仍然失败：

代码语言：javascript
复制
SQL> create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile='/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora';
create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile='/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora'
*
ERROR at line 1:
ORA-01565: error in identifying file
'/opt/oracle/product/19c/dbhome_1/dbs/spfileORCLCDB.ora'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

这是spfileORCLCDB.ora的内容：

代码语言：javascript
复制
C"▒▒f▒▒CCC"["ORCLCDB.__data_transfer_cache_size=0
ORCLCDB.__db_cache_size=889192448
ORCLCDB.__inmemory_ext_roarea=0
ORCLCDB.__inmemory_ext_rwarea=0
ORCLCDB.__java_pool_size=0
ORCLCDB.__large_pool_size=67108864
ORCLCDB.__oracle_base='/opt/oracle'#ORACLE_BASE set from environment
ORCLCDB.__pga_aggregate_target=536870912
ORCLCDB.__sga_target=1610612736
ORCLCDB.__shared_io_pool_size=83886080
ORCLCDB.__shared_pool_size=520093696
ORCLCDB.__streams_pool_size=33554432
ORCLCDB.__unified_pga_pool_size=0
*.CC"v9audit_file_dest='/opt/oracle/admin/ORCLCDB/adump'
*.audit_sys_operations=false
*.audit_trail='none'
*.compatible='19.0.0'
*.control_files='/opt/oracle/oradata/ORCLCDB/control01.ctl'
*.db_block_size=8192
*.db_flashback_retention_target=1440
*.db_name='ORCLCDB'
*.diagnostic_dest='/opt/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLCDBXDB)'
*.enable_pluggable_database=true
*.CC":)local_listener=''
*.log_archive_format='%s_%t_%r.ARC'
*.log_archive_start=TRUE
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=512m
*.processes=640
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1536m
*.undo_tablespace='UNDOTBS1'
CC"FeCC"EeCC"DeC

请帮助我如何解决这个，它已经有数据在挂载的卷，我需要保存的数据。

谢谢你们所有人。

oracle
docker
containers
EN

回答 1

Database Administration用户

发布于 2023-05-28 12:42:34

看起来它最初被配置为从spfile开始，但是在您的更改之后，它尝试从pfile开始。

所以您可以创建pfile：create pfile='/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora' from spfile;

或者您可以尝试找到您的启动脚本并检查它是否使用startup pfile...并修复它以spfile开始(只需删除pfile子句，oracle默认使用spfile )。

更新：

添加之后，我建议您重命名当前的spfile并创建一个正确的spfile：

  1. 在bash中创建pfile -运行：
代码语言：javascript
复制
cat >/opt/oracle/product/19c/dbhome_1/dbs/initORCLCDB.ora <
  1. 从这个pfile创建spfile：
代码语言：javascript
复制
create spfile from pfile;
票数 0
EN
页面原文内容由Database Administration提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://dba.stackexchange.com/questions/327627

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档