분류 전체보기 (668) 썸네일형 리스트형 17 - [Oracle 19C] unlock the HR schema To unlock the HR schema in the pluggable database SQL> startup; ORACLE instance started. Total System Global Area 1526723608 bytes Fixed Size 9135128 bytes Variable Size 889192448 bytes Database Buffers 620756992 bytes Redo Buffers 7639040 bytes Database mounted. Database opened. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2.. 16 - [Oracle 19C] connecting using tnsnames.ora 파일위치 : /u01/app/oracle/product/19/db_1/network/admin/tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/19/db_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521)) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDIC.. 15 - [Oracle 19C] Easy connect method 오라클이 설치된 서버에서 접속하는 방법 # 다양한 방법/옵션으로 접속 SQL> conn sys/Manager123# as sysdba Connected. SQL> conn sys/Manager123#@test.com/orcl.com as sysdba Connected. SQL> conn sys/Manager123#@test.com/orclpdb.com as sysdba Connected. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 [oracle@test ~]$ 14 - [Oracle 19C] Pluggable database - open, save [oracle@test ~]$ sqlplus / as sysdbaSQL*Plus: Release 19.0.0.0.0 - Production on Wed Nov 15 12:52:25 2023Version 19.3.0.0.0Copyright (c) 1982, 2019, Oracle. All rights reserved.Connected to an idle instance.SQL> startup;ORACLE instance started.Total System Global Area 1526723608 bytesFixed Size 9135128 bytesVariable Size 889192448 bytesDatabase Buffers 620756992 bytesRedo Buffers .. 13 - [Oracle 19C] Listener # listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/19/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = test.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) # tnsname.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/.. 12 - [Oracle 19C] Connecting sys user [oracle@test ~]$ [oracle@test ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Nov 14 16:01:39 2023 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> 특수 문자가 포함된 비밀번호를 사용할때 편리하다. [oracle@test ~]$ sqlplus /nolog SQL*Plus: Release 19.0.0.0.0 - .. 11 - [Oracle 19C] SQL Developer 파일 다운로드 : https://www.oracle.com/database/sqldeveloper/technologies/download/ Oracle SQL Developer Downloads This archive. will work on a 32 or 64 bit Windows OS. The bit level of the JDK you install will determine if it runs as a 32 or 64 bit application. This download does not include the required Oracle Java JDK. You will need to install it if it's not already www.oracle.com 설치버전은 M1 이라서 ARM6.. 10 - [Oracle 19C] ssh & ftp client - MobaXterm ssh & ftp client 를 사용하기 위해서 아래 사이트에서 무료 버전을 다운 받는다. https://mobaxterm.mobatek.net/ MobaXterm free Xserver and tabbed SSH client for Windows The ultimate toolbox for remote computing - includes X server, enhanced SSH client and much more! mobaxterm.mobatek.net 이전 1 ··· 27 28 29 30 31 32 33 ··· 84 다음
