ORACLE/Admin
oracle glogin.sql 설정
내맘대로긍정
2017. 1. 11. 10:16
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : oracle glogin.sql 설정
sqlplus 접속시 환경 설정을 미리 glogin.sql에 설정해놓을수 있음
db 이름도 같이 나오게 할수 있어 유용함
db이름이 정확히는 .bash_profile의 ORACLE_SID 로 설정된 이름이 나옴
내가 사용하는 glogin 설정
|
1
2
3
4
5
6
7
8
9
10
11
|
$ vi $ORACLE_HOME/sqlplus/admin/glogin.sql
SET SQLPROMPT '&_USER.@&_CONNECT_IDENTIFIER.> '
SET TIMING ON
SET TERMOUT ON
SET SERVEROUTPUT ON
SET NULL "(null)"
SET FEED ON
SET LINES 100
SET PAGES 40
DEFINE_EDITOR=vi
|
미사용시
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 19 13:42:02 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> <<<<<<<<<<<< SQL> 로만 나옴
|
사용시
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 19 13:42:19 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SYS@oracle19> <<<<<<<<<<<< 접속계정@ORACLE_SID>로 나옴
|
.bash_profile의 ORACLE_SID를 oracle19에서 test로 변경 후 접속 시
|
1
2
3
4
5
6
7
8
9
10
|
$ ss
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Feb 19 13:46:41 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SYS@test> <<<<<<<<<<<< 접속계정@ORACLE_SID>로 나옴
|
같이보기
oracle .bash_profile 설정
https://positivemh.tistory.com/489