Database (237) 썸네일형 리스트형 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.. 07 - [Oracle 19C] Oracle startup Database Startup , shutdown and connections Oracle Database 가 시작되는 단계는 아래와 같다. Shutdown >> NoMount >> Mount >> Open 이 모든 단계를 한번에 처리하는 명령어가 "startup" 이다. No mount - The instance is started but is not yet associated with a database. • Search for Spfile, pfile • Read the parameter file • Allocate the SGA • Start the BG process • Open the alert and trace file Mount - The instance is started and is a.. 06 - Oracle 19c 설치(오라클 리눅스 7.6) 오라클 리눅스 7.6 이 필요한 경우는 아래의 절차를 참고하면 됩니다. 다운로드 받은 파일을 오라클 19.3 버전을 복사한다. 위치는 /u01/app/oracle/product/19/db_1/ 폴더로 복사한다. [oracle@test db_1]$ unzip LINUX.X64_193000_db_home.zip 설치할때 오류가 발생해서 아래처럼 설정을 변경함. [oracle@test db_1]$ [oracle@test db_1]$ vi /u01/app/oracle/product/19/db_1/cv/admin/cvu_config [oracle@test db_1]$ # Fallback to this distribution id #CV_ASSUME_DISTID=OEL5 # 리눅스 7버전에서는 해당 트릭을 사용할 .. 이전 1 ··· 26 27 28 29 30 다음
