Client에서 sys,system 계정으로 Oracle 서버 접속시 명령어

CONSULTING SERVICE/Maintenance Service 2018. 4. 23. 16:31

* tnsnames.ora에 WINORCL로 서버 이름을 등록 후 WINDOWS CLIENT에서 접속방법.

 

system 계정으로 접속

C:\Users\Boeok>sqlplus "system/oracle@WINORCL"

SQL*Plus: Release 11.2.0.3.0 Production on 금 8월 2 15:36:24 2013

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


다음에 접속됨:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
winorcl

SQL> exit

 

sys 계정으로 접속

C:\Users\Boeok>sqlplus "sys/oracle@WINORCL as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on 금 8월 2 15:36:09 2013

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


다음에 접속됨:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> exit

 

 

 

* TNSNAMES.ORA에 WINORCL로 서버 이름을 등록후 LINUX CLIENT에서 접속방법

 

sys 계정으로 접속

 [LINUXORCL]linux-single:/> sqlplus sys/oracle@WINORCL as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 3 00:39:43 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
winorcl

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

system 계정으로 접속
[LINUXORCL]linux-single:/> sqlplus system/oracle@WINORCL

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 3 00:39:58 2013

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
winorcl

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[LINUXORCL]linux-single:/>

 

 



출처: http://boeok.tistory.com/entry/Client에서-syssystem-계정으로-Oracle-서버-접속시-명령어?category=564563 [Secret]

'CONSULTING SERVICE > Maintenance Service ' 카테고리의 다른 글

sys, system password를 읽어버려 접속 못할경우  (0) 2018.04.23
11g sec_case_sensitive_logon 대소문자 구분 파라미터  (0) 2018.04.23
리스너가 db를 인식 못한다고 나올때  (0) 2018.04.23
dbms_job_pakage  (0) 2018.04.23
Listener 로그 형식을 11g 이전 버전 형식으로 변경  (0) 2018.04.23
Posted by Any DB
,

티스토리툴바