この記事は約3分54秒で読むことができます。

oracle 12cr2 plugable database glogin.sql

参考文献
http://discus-hamburg.cocolog-nifty.com/mac_de_oracle/2013/07/oracle-database.html

COLUMN OTHER_PLUS_EXP FORMAT A200
COLUMN PLAN_PLUS_EXP  FORMAT A200
SET NUMWIDTH 13
SET LINESIZE 1000
SET LONG 40000
SET LONGCHUNKSIZE 40000
SET PAGESIZE 50000
SET SERVEROUTPUT ON
SET TAB OFF
SET TRIMSPOOL ON
set feed on
--set autotrace traceonly
set timing on
--set hist on
DEFINE_EDITOR=nano
set sqlp "_USER'@'_CONNECT_IDENTIFIER> "
[oracle@centos7 ~]$ docker exec -it orcl_12cr2 /bin/bash
[oracle@609a69bc0b21 ~]$ vim
[oracle@609a69bc0b21 ~]$ find / -name *login*.sql -type f 2>/dev/null
/mnt/11gr2/share/login/glogin.sql
/opt/oracle/product/12.2.0.1/dbhome_1/sqlplus/admin/glogin.sql
[oracle@609a69bc0b21 ~]$ vim /opt/oracle/product/12.2.0.1/dbhome_1/sqlplus/admin/glogin.sql
[oracle@609a69bc0b21 ~]$ sqlplus sys/ORACLE_PWD as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 23 14:49:53 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SYS@ORCL> 
SYS@ORCL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@609a69bc0b21 ~]$ sqlplus sys/ORACLE_PWD@pdb1 as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Dec 23 14:50:22 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SYS@pdb1> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Leave a Reply

Your email address will not be published. Required fields are marked *