{"id":3692,"date":"2024-04-25T13:30:01","date_gmt":"2024-04-25T04:30:01","guid":{"rendered":"https:\/\/blog.boxcorea.com\/wp\/?p=3692"},"modified":"2024-05-17T19:30:59","modified_gmt":"2024-05-17T10:30:59","slug":"grid-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-%ec%98%a4%eb%9d%bc%ed%81%b4-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%b2%a0%ec%9d%b4%ec%8a%a4-%ec%82%ac%ec%9a%a9","status":"publish","type":"post","link":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692","title":{"rendered":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9"},"content":{"rendered":"<p>\uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\uc804\uae00\uc5d0\uc11c \uc124\uce58\ud55c \uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 oracle19c \uc774\ub2e4.<\/p>\n<p>\uc124\uce58\uc640 \uc124\uce58\ub41c \ud658\uacbd\uc740 \uc544\ub798 \uae00 \ucc38\uace0.<\/p>\n<div class=\"embed-container\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"CEixKsDlwt\"><p><a href=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3623\">oracle grid 19c, oracle database  \uc124\uce58<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;oracle grid 19c, oracle database  \uc124\uce58&#8221; &#8212; Blog-boxcorea\" src=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3623\/embed#?secret=32HqbDb5rf#?secret=CEixKsDlwt\" data-secret=\"CEixKsDlwt\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/div>\n<p>* \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c\ub2e4.(\uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 \ub178\ub4dc 1 \ub610\ub294 2\uc758 \ub9ac\ub205\uc2a4 oracle\uacc4\uc815)<\/p>\n<pre>$ sqlplus sys\/******@fox-scan\/orcl as sysdba\r\n\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 14:31:12 2024\r\nVersion 19.3.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.3.0.0.0\r\n\r\nSQL&gt;<\/pre>\n<p><!--more--><\/p>\n<p>* \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ub9cc\ub4e4\uae30<br \/>\n\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4e4\uae30\uc704\ud574 asmdisk group\uc758 \uc774\ub984\uc744 \ud655\uc778\ud55c\ub2e4.<\/p>\n<pre>SQL&gt; select name, state, type from v$asm_diskgroup;\r\n\r\nNAME                           STATE       TYPE\r\n------------------------------ ----------- ------\r\n<span style=\"color: #ff6600;\">DATA<\/span>                           MOUNTED     EXTERN<\/pre>\n<p>FOX_TX\ub77c\ub294 \uc774\ub984\uc758 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ub9cc\ub4e0\ub2e4.<\/p>\n<pre>SQL&gt; create tablespace FOX_TS\r\n  2  datafile '<span style=\"color: #ff6600;\">+DATA<\/span>'\r\n  3  size 500M;\r\n\r\n???????? ???????.<\/pre>\n<p>\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4 \ud655\uc778. \uc704\uc5d0\uc11c \ub9cc\ub4e0 FOX_TS \uac00 \uc544\ub798\ucabd\uc5d0 \ubcf4\uc778\ub2e4.<\/p>\n<pre>SQL&gt; SELECT tablespace_name FROM dba_tablespaces;\r\n\r\nTABLESPACE_NAME\r\n------------------------------\r\nSYSTEM\r\nSYSAUX\r\nUNDOTBS1\r\nTEMP\r\nUSERS\r\nUNDOTBS2\r\n<span style=\"color: #ff6600;\">FOX_TS<\/span>\r\n\r\n7 ?? ???????.\r\n\r\nSQL&gt;<\/pre>\n<p>* \uc0ac\uc6a9\uc790 \ucd94\uac00<\/p>\n<p>\uc0ac\uc6a9\uc790\ub97c \ub9cc\ub4e4\uace0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ud560\ub2f9\ud55c\ub2e4.<br \/>\nid: fox<br \/>\npassword: fox123<\/p>\n<pre>SQL&gt; create user fox identified by fox123 default tablespace FOX_TS;\r\n\r\nSQL&gt; grant connect, resource to fox;<\/pre>\n<p>\uc0ac\uc6a9\uc790 \ud655\uc778 \ud574\ubcf4\uba74 \uc5ed\uc2dc \uc544\ub798\ucabd\uc5d0 \uc704\uc5d0\uc11c \ub9cc\ub4e0 \uc0ac\uc6a9\uc790\uac00 \uc788\ub2e4.<\/p>\n<pre>SQL&gt; select username from dba_users;\r\n\r\nUSERNAME\r\n--------------------------------------------------------------------------------\r\nSYS\r\nSYSTEM\r\nXS$NULL\r\nOJVMSYS\r\nLBACSYS\r\nOUTLN\r\nSYS$UMF\r\nDBSNMP\r\nAPPQOSSYS\r\nDBSFWUSER\r\nGGSYS\r\n\r\nUSERNAME\r\n--------------------------------------------------------------------------------\r\nANONYMOUS\r\nCTXSYS\r\nDVSYS\r\nDVF\r\nGSMADMIN_INTERNAL\r\nMDSYS\r\nOLAPSYS\r\nXDB\r\nWMSYS\r\nGSMCATUSER\r\nMDDATA\r\n\r\nUSERNAME\r\n--------------------------------------------------------------------------------\r\nSYSBACKUP\r\nREMOTE_SCHEDULER_AGENT\r\nGSMUSER\r\nSYSRAC\r\nGSMROOTUSER\r\nSI_INFORMTN_SCHEMA\r\nAUDSYS\r\nDIP\r\nORDPLUGINS\r\nSYSKM\r\nORDDATA\r\n\r\nUSERNAME\r\n--------------------------------------------------------------------------------\r\nORACLE_OCM\r\nSYSDG\r\nORDSYS\r\n<span style=\"color: #ff6600;\">FOX<\/span>\r\n\r\n37 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/pre>\n<p>* \ud55c\uae00 \uc124\uc815\ubb38\uc81c\ud574\uacb0<br \/>\n\ud604\uc7ac \ubb38\uc790\uc14b \ud655\uc778<\/p>\n<pre>SQL&gt; SELECT value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';\r\n\r\nVALUE\r\n--------------------------------------------------------------------------------\r\nAL32UTF8<\/pre>\n<p>\ud074\ub77c\uc774\uc5b8\ud2b8\uce21\uc5d0\uc11c NLS_LANG \ud658\uacbd\ubcc0\uc218\ub97c \uc124\uc815\ud55c\ub2e4.<\/p>\n<pre>$ export NLS_LANG=KOREAN_KOREA.AL32UTF8\r\n\r\n$ sqlplus \/nolog\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on \ubaa9 4\uc6d4 18 16:24:27 2024\r\nVersion 19.3.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n\r\nSQL&gt; conn \/as sysdba\r\n\uc5f0\uacb0\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/pre>\n<p>\ud55c\uae00\ubb38\uc81c\ub85c ???\ub85c \ud45c\uc2dc\ub418\ub358 \ubd80\ubd84\uc774 \uc798 \ubcf4\uc778\ub2e4.<\/p>\n<p>* \ub9cc\ub4e0 \uc0ac\uc6a9\uc790\ub85c \uc811\uc18d \ud14c\uc2a4\ud2b8.<\/p>\n<pre>$ sqlplus fox\/fox123@fox-scan\/orcl\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on \ubaa9 4\uc6d4 18 16:32:32 2024\r\nVersion 19.3.0.0.0\r\n\r\nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\r\n\r\n\ub9c8\uc9c0\ub9c9 \uc131\uacf5\ud55c \ub85c\uadf8\uc778 \uc2dc\uac04: \ubaa9 4\uc6d4  18 2024 16:28:56 +09:00\r\n\r\n\ub2e4\uc74c\uc5d0 \uc811\uc18d\ub428:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.3.0.0.0\r\n\r\nSQL&gt;<\/pre>\n<p>* \ud14c\uc774\ube14 \ub9cc\ub4e4\uc5b4\ubcf4\uae30.<\/p>\n<p>TEST \ub77c\ub294 \uc774\ub984\uc73c\ub85c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \ubcf8\ub2e4.<\/p>\n<pre>SQL&gt; CREATE TABLE <span style=\"color: #ff6600;\">test<\/span> (\r\n  id NUMBER(4),\r\n  name VARCHAR2(10)\r\n);<\/pre>\n<p>\ud14c\uc774\ube14 \ud655\uc778.<\/p>\n<pre>SQL&gt; select * from tab;\r\n\r\nTNAME\r\n--------------------------------------------------------------------------------\r\nTABTYPE        CLUSTERID\r\n------------- ----------\r\n<span style=\"color: #ff6600;\">TEST<\/span>\r\nTABLE<\/pre>\n<p>\uc798 \ub41c\ub2e4.<\/p>\n<p>TEST \ud14c\uc774\ube14\uc5d0 insert\uac00 \uc548\ub418\uc11c, \uc544\ub798 \uad8c\ud55c\uc744 \ucd94\uac00\ud568(\uad00\ub9ac\uc790 \uacc4\uc815\uc73c\ub85c).<\/p>\n<pre>SQL&gt; ALTER USER fox QUOTA unlimited ON fox_ts;\r\n\r\n\uc0ac\uc6a9\uc790\uac00 \ubcc0\uacbd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/pre>\n<p>* \uc708\ub3c4\uc6b0 PC \uc5d0\uc11c Oracle SQL Developer \uc0ac\uc6a9.<br \/>\nsql developer \uc124\uce58\ub294 \uc0dd\ub7b5.<\/p>\n<p>sql-developer\ub97c \uc2e4\ud589\ud558\uace0, \uc811\uc18d \uba54\ub274\uc5d0\uc11c &#8216;+&#8217; \ubc84\ud2bc\uc744 \ub204\ub978\ub2e4.<br \/>\n&#8216;\uc0c8\ub85c\ub9cc\ub4e4\uae30\/\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d \uc120\ud0dd&#8217; \ucc3d\uc774 \ub098\uc624\uba74,<br \/>\nName \uc5d0\ub294 \uc811\uc18d\uc5d0 \uc0ac\uc6a9\ud560 \uc774\ub984\uc744 \uc785\ub825(\uc784\uc758\ub85c)<br \/>\n\uc0ac\uc6a9\uc790 \uc815\ubcf4\uc758 \uc0ac\uc6a9\uc790\uc774\ub984\uc740 \uc704\uc5d0\uc11c \ub9cc\ub4e0 \uc0ac\uc6a9\uc790 \uc774\ub984(fox) \uacfc \ube44\ubc00\ubc88\ud638(fox123)\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n<p>\ud074\ub7ec\uc2a4\ud130\uc758 fox-scan\uc774 public DNS\uc5d0 \ub4f1\ub85d\ub418\uc5b4 \uc788\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0, fox-scan\uc758 IP \uc8fc\uc18c(3 \uac1c\uc911 \uc544\ubb34\uac70\ub098 1\uac1c)\ub97c \uc785\ub825\ud55c\ub2e4.<br \/>\n\uadf8\ub9ac\uace0, SID \ub300\uc2e0 \uc11c\ube44\uc2a4 \uc774\ub984\uc744 \uc120\ud0dd\ud558\uace0 \uc11c\ube44\uc2a4\uc774\ub984\uc744 \uc785\ub825\ud55c\ub2e4.<\/p>\n<p><a href=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3694\" data-permalink=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\/sql_developer_01\" data-orig-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\" data-orig-size=\"766,493\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"sql_developer_01\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01-300x193.png\" data-large-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\" class=\"alignnone size-full wp-image-3694\" src=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\" alt=\"\" width=\"766\" height=\"493\" srcset=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png 766w, https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01-300x193.png 300w, https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01-750x483.png 750w\" sizes=\"auto, (max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>\uc811\uc18d\uc774 \ub418\uba74, \uc67c\ucabd\uc5d0\uc11c \ud14c\uc774\ube14\uc744 \uc120\ud0dd\ud558\uba74 \uc704\uc5d0\uc11c \ub9cc\ud2bc TEST \ud14c\uc774\ube14\uc774 \ubcf4\uc778\ub2e4.<\/p>\n<p><a href=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"3695\" data-permalink=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\/sql_developer_02\" data-orig-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02.png\" data-orig-size=\"1021,728\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"sql_developer_02\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02-300x214.png\" data-large-file=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02.png\" class=\"alignnone size-full wp-image-3695\" src=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02.png\" alt=\"\" width=\"1021\" height=\"728\" srcset=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02.png 1021w, https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02-300x214.png 300w, https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02-768x548.png 768w, https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_02-750x535.png 750w\" sizes=\"auto, (max-width: 1021px) 100vw, 1021px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\uc804\uae00\uc5d0\uc11c \uc124\uce58\ud55c \uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 oracle19c \uc774\ub2e4. \uc124\uce58\uc640 \uc124\uce58\ub41c \ud658\uacbd\uc740 \uc544\ub798 \uae00 \ucc38\uace0. oracle grid 19c, oracle database \uc124\uce58 * \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c\ub2e4.(\uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 \ub178\ub4dc 1 \ub610\ub294 2\uc758 \ub9ac\ub205\uc2a4 oracle\uacc4\uc815) $ sqlplus sys\/******@fox-scan\/orcl as sysdba SQL*Plus: Release 19.0.0.0.0 &#8211; Production on Thu Apr 18 14:31:12 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[27],"tags":[1220,25,1228,1229,1226,1222,43],"class_list":["post-3692","post","type-post","status-publish","format-standard","hentry","category-database","tag-grid","tag-oracle","tag-rac","tag-sql-developer","tag-sqlplus","tag-1222","tag-43","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea\" \/>\n<meta property=\"og:description\" content=\"\uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\uc804\uae00\uc5d0\uc11c \uc124\uce58\ud55c \uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 oracle19c \uc774\ub2e4. \uc124\uce58\uc640 \uc124\uce58\ub41c \ud658\uacbd\uc740 \uc544\ub798 \uae00 \ucc38\uace0. oracle grid 19c, oracle database \uc124\uce58 * \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c\ub2e4.(\uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 \ub178\ub4dc 1 \ub610\ub294 2\uc758 \ub9ac\ub205\uc2a4 oracle\uacc4\uc815) $ sqlplus sys\/******@fox-scan\/orcl as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 14:31:12 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights &hellip; Continue reading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\" \/>\n<meta property=\"og:site_name\" content=\"Blog-boxcorea\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-25T04:30:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-17T10:30:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\" \/>\n\t<meta property=\"og:image:width\" content=\"766\" \/>\n\t<meta property=\"og:image:height\" content=\"493\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"snowffox\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"snowffox\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\"},\"author\":{\"name\":\"snowffox\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a\"},\"headline\":\"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\",\"datePublished\":\"2024-04-25T04:30:01+00:00\",\"dateModified\":\"2024-05-17T10:30:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\"},\"wordCount\":42,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\",\"keywords\":[\"grid\",\"oracle\",\"rac\",\"sql-developer\",\"sqlplus\",\"\uadf8\ub9ac\ub4dc\",\"\uc624\ub77c\ud074\"],\"articleSection\":[\"DATABASE\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\",\"url\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\",\"name\":\"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea\",\"isPartOf\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\",\"datePublished\":\"2024-04-25T04:30:01+00:00\",\"dateModified\":\"2024-05-17T10:30:59+00:00\",\"author\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage\",\"url\":\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\",\"contentUrl\":\"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/blog.boxcorea.com\/wp\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/#website\",\"url\":\"https:\/\/blog.boxcorea.com\/wp\/\",\"name\":\"Blog-boxcorea\",\"description\":\"Simple is Beautiful!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.boxcorea.com\/wp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a\",\"name\":\"snowffox\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g\",\"caption\":\"snowffox\"},\"url\":\"https:\/\/blog.boxcorea.com\/wp\/archives\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692","og_locale":"ko_KR","og_type":"article","og_title":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea","og_description":"\uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc774\uc804\uae00\uc5d0\uc11c \uc124\uce58\ud55c \uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 oracle19c \uc774\ub2e4. \uc124\uce58\uc640 \uc124\uce58\ub41c \ud658\uacbd\uc740 \uc544\ub798 \uae00 \ucc38\uace0. oracle grid 19c, oracle database \uc124\uce58 * \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud55c\ub2e4.(\uadf8\ub9ac\ub4dc \ud658\uacbd\uc758 \ub178\ub4dc 1 \ub610\ub294 2\uc758 \ub9ac\ub205\uc2a4 oracle\uacc4\uc815) $ sqlplus sys\/******@fox-scan\/orcl as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Thu Apr 18 14:31:12 2024 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights &hellip; Continue reading","og_url":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692","og_site_name":"Blog-boxcorea","article_published_time":"2024-04-25T04:30:01+00:00","article_modified_time":"2024-05-17T10:30:59+00:00","og_image":[{"width":766,"height":493,"url":"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png","type":"image\/png"}],"author":"snowffox","twitter_card":"summary_large_image","twitter_misc":{"Written by":"snowffox","Est. reading time":"2\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#article","isPartOf":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692"},"author":{"name":"snowffox","@id":"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a"},"headline":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9","datePublished":"2024-04-25T04:30:01+00:00","dateModified":"2024-05-17T10:30:59+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692"},"wordCount":42,"commentCount":0,"image":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage"},"thumbnailUrl":"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png","keywords":["grid","oracle","rac","sql-developer","sqlplus","\uadf8\ub9ac\ub4dc","\uc624\ub77c\ud074"],"articleSection":["DATABASE"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.boxcorea.com\/wp\/archives\/3692#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692","url":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692","name":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9 - Blog-boxcorea","isPartOf":{"@id":"https:\/\/blog.boxcorea.com\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage"},"image":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage"},"thumbnailUrl":"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png","datePublished":"2024-04-25T04:30:01+00:00","dateModified":"2024-05-17T10:30:59+00:00","author":{"@id":"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a"},"breadcrumb":{"@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.boxcorea.com\/wp\/archives\/3692"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#primaryimage","url":"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png","contentUrl":"https:\/\/blog.boxcorea.com\/wp\/wp-content\/uploads\/2024\/04\/sql_developer_01.png"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.boxcorea.com\/wp\/archives\/3692#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/blog.boxcorea.com\/wp"},{"@type":"ListItem","position":2,"name":"Grid \ud658\uacbd\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9"}]},{"@type":"WebSite","@id":"https:\/\/blog.boxcorea.com\/wp\/#website","url":"https:\/\/blog.boxcorea.com\/wp\/","name":"Blog-boxcorea","description":"Simple is Beautiful!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.boxcorea.com\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Person","@id":"https:\/\/blog.boxcorea.com\/wp\/#\/schema\/person\/6d8e12df2429d663a0a4e8362fbb650a","name":"snowffox","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c0787be58ea7e470b1a6f5ea8ce367c7913809648a00e0c15faace5220902ffb?s=96&d=retro&r=g","caption":"snowffox"},"url":"https:\/\/blog.boxcorea.com\/wp\/archives\/author\/admin"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p4wGXL-Xy","jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/posts\/3692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/comments?post=3692"}],"version-history":[{"count":6,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/posts\/3692\/revisions"}],"predecessor-version":[{"id":3717,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/posts\/3692\/revisions\/3717"}],"wp:attachment":[{"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/media?parent=3692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/categories?post=3692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.boxcorea.com\/wp\/wp-json\/wp\/v2\/tags?post=3692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}