[리눅스] grep, sqlplus ed 명령

[oracle@enp0s3 trace]$ grep -i "Using parameter" alert_orcl.log
Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/orcl/initorclTempOMF.ora on machine enp0s3
Using parameter settings in client-side pfile /u01/app/oracle/admin/orcl/pfile/init.ora on machine enp0s3
Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/orcl/initorclTemp.ora on machine enp0s3
Using parameter settings in client-side pfile /u01/app/oracle/cfgtoollogs/dbca/orcl/initorclTemp.ora on machine enp0s3
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileorcl.ora
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileorcl.ora
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileorcl.ora
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileorcl.ora
Using parameter settings in server-side spfile /u01/app/oracle/product/19.0.0/dbhome_1/dbs/spfileorcl.ora

 

sqlplus에서 ed를 사용하면 입력했던 구문에서 수정하고 싶은 부분이 있을때 ed 명령으로 vi 편집기를 사용해 편집을 완료할 수 있다. 예를 들면

SQL> select * from duall;
select * from duall
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> ed
Wrote file afiedt.buf

  1* select * from dual
SQL> /

D
-
X