记录一次Oracle 19c测试机的启动故障——ORA-01078和LRM-00109

我默认oracle用户下设置的.bash_profile

export PATH
export ORACLE_SID=test19c
#export ORACLE_UNQNAME= tnbtest
#export JAVA_HOME=/usr/local/java
export ORACLE_BASE=/oracle
#export ORA_GRID_HOME=${ORACLE_BASE}/grid
#export ORA_DB_HOME=${ORACLE_BASE}/dbhome_1
export ORACLE_HOME=/oracle/product/19.3.0
#export GRID_HOME=${ORA_GRID_HOME}
#export ORA_CRS_HOME=${GRID_HOME}/crs
#export ORACLE_TERM=xterm
#export NLS_DATE_FORMAT="YYYY:MM:DDHH24:MI:SS"
export NLS_LANG=AMERICAN_AMERICA.UTF8
#export TNS_ADMIN=${ORACLE_HOME}/network/admin
#export ORA_NLS11=${ORACLE_HOME}/nls/data
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH:$HOME/bin
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:${ORACLE_HOME}/oracm/lib:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=${ORACLE_HOME}/JRE:${ORACLE_HOME}/jlib:${ORACLE_HOME}/rdbms/jlib:${ORACLE_HOME}/network/jlib
export THREADS_FLAG=native
export TEMP=/oracle/tmp
export TMPDIR=/oracle/tmp
umask 022

安装后启动数据库报错ORA-01078和LRM-00109
默认解决方案如下

 cp /oracle/admin/orcl/pfile/init.ora.11192024142627 /oracle/product/19.3.0/dbs/inittest19c.ora

最重要的如果是root复制的，需要给权限。