重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: sqlplus启动问题 [打印本页]

作者: lins    时间: 2023-12-29 18:17
标题: sqlplus启动问题
本帖最后由 lins 于 2023-12-29 18:16 编辑


问题:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/19.16.0/db_1/dbs/initorcl.ora'
解决:cp /u01/app/oracle/product/19.16.0/db_1/dbs/init.ora /u01/app/oracle/product/19.16.0/db_1/dbs/initorclcdb.ora


问题:
SQL> startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
解决:
cd $ORACLE_HOME/dbs
vi initorcl.ora
# audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_file_dest='/u01/app/oracle/admin/orcl/adump'
# db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'


问题:
SQL> startup
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
http://bbs.cqsztech.com/forum.ph ... highlight=ORA-01012
延伸问题:
SQL> shutdown immediate
ERROR:
ORA-01090: shutdown in progress - connection is not permitted
Process ID: 0
Session ID: 0 Serial number: 0
http://bbs.cqsztech.com/forum.ph ... highlight=ORA-01090

解决:
SQL> shutdown abort;
ORACLE instance shut down.
http://bbs.cqsztech.com/forum.ph ... highlight=ORA-01031



问题:
SQL> shutdown abort;
ORA-01031: insufficient privileges
解决:
退出sqlplus重新登录



问题:
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
http://bbs.cqsztech.com/forum.ph ... 678&highlight=01081

解决:
SQL> shutdown immediate
ORA-01507: database not mounted
http://bbs.cqsztech.com/forum.ph ... highlight=ORA-01507
ORACLE instance shut down.

SQL> startup nomount
ORACLE instance started.

Total System Global Area 1073737800 bytes
Fixed Size                  8904776 bytes
Variable Size             616562688 bytes
Database Buffers          440401920 bytes
Redo Buffers                7868416 bytes
https://blog.csdn.net/zhangyulin54321/article/details/7995885



问题:
Middleware Home Location: /u01/app/oracle/product/middleware  Specified Oracle Middleware Home location does not have write permissions.
Agent Base directory: /u01/app/oracle/product/agent  You have entered an agent base directory location that does not have write permission.
解决:
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app



问题:
Unable to proceed with the installation. The location you have specified does not have sufficient disk space to install Enterprise Manager Cloud Control.
Free some disk space in this location or specify another location that has sufficient space.

Location: /u01/app/oracle/product/middleware , /u01/app/oracle/product/gc_inst , null
Disk Space Required : 37.3 GB
Disk Space Available : 18.3 GB

解决:
mkdir -p /home/oracle/u01/app/oracle/product/{middleware,agent}
chmod -R 775 /home/oracle/u01
ln -s /home/oracle/u01/app/oracle/product/middleware /u01/app/oracle/product/middleware
ln -s
/home/oracle/u01/app/oracle/product/agent /u01/app/oracle/product/agent





欢迎光临 重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2