ORA-27104，ORA-01565，ORA-27077，ORA-00093，ORA-01012，ORA-32001，SP2-0714，ORA-12547，sqlplus /nolog 连接不上

ORA-27104: system-defined limits for shared memory was misconfigured --oracle的sga超过安装oracle配置的最大内存
ipcs -l
------ Messages Limits --------
max queues system wide = 32768
max size of message (bytes) = 8192
default max size of queue (bytes) = 16384

------ Shared Memory Limits --------
max number of segments = 4096
max seg size (kbytes) = 2097152
max total shared memory (kbytes) = 8388608 最大共享内存单位KB
min seg size (bytes) = 1

------ Semaphore Limits --------
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767

–sga不能超过配置的这个值
fs.file-max = 6815744
fs.aio-max-nr = 1048576
kernel.shmall = 2097152
kernel.shmmax = 2147483648 #这个值太小了总内存4G才配置这个值不然共享内存只能是8G根服务器内存差不多
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_l
cal_port_range = 9000 65500
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

ORA-01565: error in identifying file ‘?=/dbs/spfile@.ora’
ORA-27077: too many files open
spfile 不支持
create spfile from pfile=’/opt/app/oracle/product/18.3/db_1/dbs/initcdb1.ora’; --这种操作只能是pfile
去重新找到启动文件
[[root@oracle ~]# find /u01 -name pfile
/u01/app/oracle/admin/ljl/pfile
[root@oracle ~]# cd /u01/app/oracle/admin/ljl/pfile
[root@oracle pfile]# ls
init.ora.026201514119
用这个启动文件启动oracle 在根据这个文件创建spfile然后在更具最大共享内存修改amm 到asmm
不能是spfile
登录sqlplus
create pfile from spfile 根据spfile 创建pfile
ORA-00093: pga_aggregate_limit must be between 9600M and 100000G ORA-01078: failure in processing system parameters
设置pfile的时候必须把pga_aggregate_limit 配置成
pga_aggregate_target
如果pga内存超出pga_aggregate_limit 的上线就会报错
ORA-01012: not logged on
你的oracle没有启动起来
ORA-32001: write to SPFILE requested but no SPFILE is in use
spfile没有创建创建spfile来修改启动参数
create spfile from pfile=’/opt/app/oracle/product/18.3/db_1/dbs/initcdb1.ora’;
通过你启动的pfile来创建spfile才算最后完成
SP2-0714: invalid combination of STARTUP options 启动oracle失败
startup nomount spfile=’/opt/app/oracle/product/18.3/db_1/dbs/init.ora’–这个是错误的
startup nomount pfile=’/opt/app/oracle/product/18.3/db_1/dbs/initcdb1.ora’–这个才是对的
ORA-12547: TNS:lost contact
丢失连接 应为你的process 连接数少了所以部分用户可以登录，而且程序用完了最好释放连接，尽量少用永久连接。
alter system set pga_aggregate_target=2000m scope=spfile; --修改pga_aggregate_target

alter system set sga_target=19200m scope=spfile; --修改sga_target

alter system set sga_max_size=20000m scope=spfile; 修改sga_max_size
如果sqlplus /nolog 连接不上
修改sqlnet.ora
tcp.validnode_checking = yes