분류 전체보기 (658) 썸네일형 리스트형 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 09 - [Oracle 19C] Oracle Connecting Connecting to oracle database • Back in the day, the only way to connect to a database was usually to be on a host . • Now oracle support TCP/IP and Secure TCP/IP connections from clients. • To make connection with oracle we need Oracle net services • Oracle net services installed with the database. • Oracle Net Listener is a separate process that runs on the database server computer. It receive.. 08 - [Oracle 19C] Oracle shutdown • To shut down a database and instance, you must first connect as SYSOPER or SYSDBA • We need to shutdown sometimes for specific reasons: change a static parameter Patch the database server perform maintenance or other administrative tasks Abort Immediate Transactional Normal Allows new connections NO NO NO NO Waits until current sessions end NO NO NO Yes Wait until current transactions end NO N.. 이전 1 ··· 26 27 28 29 30 31 32 ··· 83 다음
