{"id":408,"date":"2013-09-27T16:40:26","date_gmt":"2013-09-28T01:40:26","guid":{"rendered":"\/blog\/?p=408"},"modified":"2023-09-21T09:38:52","modified_gmt":"2023-09-21T00:38:52","slug":"oracle-%ea%b8%b0%ec%b4%88","status":"publish","type":"post","link":"https:\/\/hasu0707.duckdns.org\/blog\/?p=408","title":{"rendered":"oracle \uae30\ucd08"},"content":{"rendered":"\n

<\/p>

\n\n<\/p>


<\/p>

tnsnames.ora<\/a><\/p>

\u25c6 \uc624\ub77c\ud074 \uc11c\ube44\uc2a4 \uad6c\uc870<\/span><\/p>\n\n

 <\/span><\/p>\n\n

1. iSQLPlus : Default\nPort Number 5560<\/span><\/p>\n\n

2. TNSListener :\nDefault Port Number 1152<\/span><\/p>\n\n

3. DBConsole : Default\nPort Number 1158<\/span><\/p>\n\n

- orcl<\/span>\uc640 1:1 <\/span>\ub9e4\uce58\ub418\ubbc0\ub85c orcl<\/span>\uc774 \uc99d\uac00\ud560 \ub54c\ub9c8\ub2e4 DBConsole<\/span>\ub3c4 \uc99d\uac00\ud55c\ub2e4.<\/span><\/span><\/p>\n\n

- <\/span>\ub450\ubc88\uc9f8\nDBConsole<\/span>\ubd80\ud130 Port Number<\/span>\uac00 5500 <\/span>\ubd80\ud130\n\uc2dc\uc791\ud55c\ub2e4. (1158,5500,5501,5502,...)<\/span><\/span><\/p>\n\n

4. orcl : <\/span>\uc2e4\uc81c\uc801\uc778 \uc624\ub77c\ud074 \uc11c\ubc84\uc774\ub2e4. orcl <\/span>\uc678\uc5d0\ub3c4 \uc5ec\ub7ec\uac1c\uc758 \uc624\ub77c\ud074 \uc11c\ubc84\ub97c \ucd94\uac00\uc801\uc73c\ub85c \uc124\uce58 \uac00\ub2a5.<\/span><\/span><\/p>\n\n

- DBConsole<\/span>\uacfc 1:1 <\/span>\ub9e4\uce58\ub41c\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

* <\/span>\uc678\ubd80\uc5d0\uc11c \uc811\uc18d \uc2dc \uc5f0\uacb0\uad6c\uc870<\/span><\/p>\n\n

1. user<\/span>\uc758 \uc811\uc18d<\/span><\/p>\n\n

- sqlplus id\/password@ip:portnumber\/net_service_name<\/span><\/p>\n\n

2. TNSListener <\/span>\uc5f0\uacb0\n(Oracle <\/span>\uc5d0\uc11c \uc678\ubd80\uc640\uc758 \ud1b5\uc2e0\uc744 \uc704\ud574 \uc874\uc7ac\ud558\ub294 \ud328\ud0a4\uc9c0)<\/span><\/span><\/p>\n\n

- TNSListener <\/span>\ub294 \ud604\uc7ac \uc624\ub77c\ud074 \uc11c\ubc84\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uad6c\ub3d9 \uc911\uc778\uc9c0\n\ud655\uc778\ud55c\ub2e4.<\/span><\/span><\/p>\n\n

- <\/span>\uc624\ub77c\ud074 \uc11c\ubc84\uac00 \uc815\uc0c1 \ub3d9\uc791 \uc911\uc77c \uacbd\uc6b0 Server Process<\/span>\uc640 \uc678\ubd80 user<\/span>\ub97c \uc5f0\uacb0\uc2dc\ucf1c\uc900 \ud6c4 TNSListener<\/span>\uc758 \uc5f0\uacb0\uc740 \ub04a\uc5b4\uc9c4\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 Oracle <\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub780<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4(Tablespace)<\/span>\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\n\uc624\ube0c\uc81d\ud2b8 \ub0b4 \uc2e4\uc81c \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \uacf5\uac04\uc774\ub2e4. <\/span>\uc774\uac83\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubb3c\ub9ac\uc801\uc778 \ubd80\ubd84\uc774\uba70, <\/span>\uc138\uadf8\uba3c\ud2b8\ub85c \uad00\ub9ac\ub418\ub294 \ubaa8\ub4e0 DBMS<\/span>\uc5d0 \ub300\ud574 \uc800\uc7a5\uc18c(<\/span>\uc138\uadf8\uba3c\ud2b8)<\/span>\ub97c \ud560\ub2f9\ud55c\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc138\uadf8\uba3c\ud2b8\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc624\ube0c\uc81d\ud2b8 \uc911\uc758 \ud558\ub098\uc774\uba70, <\/span>\ud14c\uc774\ube14\uc774\ub098 \uc778\ub371\uc2a4\uc640 \uac19\uc774 \ubb3c\ub9ac\uc801 \uacf5\uac04\uc744 \uc810\uc720\ud55c\ub2e4. <\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294\n\ud55c\ubc88 \uc0dd\uc131\ub418\uba74, <\/span>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc138\uadf8\uba3c\ud2b8 \uc0dd\uc131\uc2dc \uc774\ub984\uc73c\ub85c \ucc38\uc870\ub41c\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \ub2e8\uc9c0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5\uc18c \uc704\uce58\ub97c \uc9c0\uc815\ud560 \ubfd0\uc774\uba70, <\/span>\ub17c\ub9ac\uc801 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub098 \uc2a4\ud0a4\ub9c8\ub97c \uc9c0\uc815\ud558\uc9c0 \uc54a\ub294\ub2e4. <\/span>\uc608\ub97c \ub4e4\uba74, <\/span>\ub3d9\uc77c\ud55c \uc2a4\ud0a4\ub9c8\ub0b4\uc758 \ub2e4\ub978 \uc624\ube0c\uc81d\ud2b8\ub294 \uc11c\ub85c \ub2e4\ub978 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 \ub193\uc77c \uc218 \uc788\ub2e4.\n<\/span>\ub9c8\ucc2c\uac00\uc9c0\ub85c, <\/span>\ud558\ub098\uc758 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \uc5ec\ub7ec \uc138\uadf8\uba3c\ud2b8\ub4e4\uc744 \uc11c\ube44\uc2a4 \ud560 \uc218 \uc788\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131 \uc608:<\/span><\/span><\/p>\n\n

CREATE TABLESPACE\nindex1 DATAFILE '\/mnt\/sda1\/index1.dbf' SIZE 100M;<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\uc601\uad6c(Permnet)\n<\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \uc0ac\uc6a9\uc790 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc624\ube0c\uc81d\ud2b8\ub97c \uc800\uc7a5\ud558\ub294 \uc8fc\uc694\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc774\ub2e4.<\/span><\/span><\/p>\n\n

- <\/span>\ucde8\uc18c(Undo)\n<\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \ud2b8\ub79c\uc7ad\uc158\uc774 \ub864\ubc31 \ub41c \uc774\ud6c4 undo commit <\/span>\ud2b8\ub79c\uc7ad\uc158\uc5d0 \uc0ac\uc6a9\ub420 \ub370\uc774\ud130\ub97c\n\uc800\uc7a5\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\ub41c\ub2e4.<\/span><\/span><\/p>\n\n

- <\/span>\uc784\uc2dc(Temporary)\n<\/span>\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \uc9e7\uc740 \uae30\uac04 \ub3d9\uc548 \uc784\uc2dc\ub85c \uc0ac\uc6a9\ub420 \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \uc0ac\uc6a9\ub41c\ub2e4. DBMS<\/span>\uac00\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc815\ub82c\ud558\uac70\ub098, <\/span>\uc0ac\uc6a9\uc790\uc758 \uc804\uc5ed \ubcc0\uc218 \uc784\uc2dc \uc800\uc7a5\uc6a9\uc73c\ub85c \uc0ac\uc6a9\ub420 \uc218 \uc788\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 Oracle <\/span>\uae30\ubcf8 \uacc4\uc815 \uc815\ubcf4<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sys : <\/span>\uad00\ub9ac\uc790 \uacc4\uc815\n(<\/span>\ubaa8\ub4e0 \uad8c\ud55c\uc744 \uac00\uc9d0)<\/span><\/span><\/p>\n\n

system : <\/span>\uc720\uc9c0\ubcf4\uc218\uc6a9 \uacc4\uc815\uc73c\ub85c sys<\/span>\uc640 \uac19\uc73c\ub098 DB <\/span>\uc0dd\uc131\uad8c\ud55c\ub9cc \uc5c6\uc74c.<\/span><\/span><\/p>\n\n

scott : <\/span>\ube44\ubc00\ubc88\ud638\ub294\ntiger<\/span>\ub85c \ud14c\uc2a4\ud2b8 \uacc4\uc815<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\uad00\ub9ac\uc790 \ud2b9\uad8c(previleges)<\/span><\/span><\/p>\n\n

sysdba, sysoper, sysasm<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 Oracle <\/span>\uc811\uc18d\ubc29\ubc95 (<\/span>\uc6d0\uaca9)<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\uc11c\ubc84\uc14b\ud305<\/span><\/p>\n\n

 <\/span><\/p>\n\n

<<\/span>\uc124\uce58\ub514\ub809\ud1a0\ub9ac>\\product\\11.2.0\\dbhome_1\\NETWORK\\ADMIN\\tnsnames.ora<\/span><\/span><\/p>\n\n

\uc544\ub798 \ubd80\ubd84 \ucd94\uac00.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

TEST =<\/span><\/p>\n\n

  <\/span>(DESCRIPTION =<\/span><\/p>\n\n

    <\/span>(ADDRESS = (PROTOCOL = TCP)(HOST =\n10.10.10.40)(PORT = 1521))<\/span><\/p>\n\n

    <\/span>(CONNECT_DATA =<\/span><\/p>\n\n

      <\/span>(SERVER = DEDICATED)<\/span><\/p>\n\n

      <\/span>(SERVICE_NAME = test)<\/span><\/p>\n\n

    <\/span>)<\/span><\/p>\n\n

  <\/span>)<\/span><\/p>\n\n

 <\/span><\/p>\n\n
\n<\/span>\n\n

- <\/span>\ud074\ub77c\uc774\uc5b8\ud2b8 \uc14b\ud305<\/span><\/p>\n\n

 <\/span><\/p>\n\n

<<\/span>\uc124\uce58\ub514\ub809\ud1a0\ub9ac>\\product\\11.2.0\\client_1\\NETWORK\\ADMIN\\tnsnames.ora<\/span><\/span><\/p>\n\n

\ub9cc\uc77c \ud30c\uc77c\uc774 \uc5c6\uc73c\uba74 \uc0dd\uc131\ud574\uc8fc\uace0, <\/span>\uc11c\ubc84\uc758 tnsnames.ora <\/span>\ud30c\uc77c\uc744 \ubcf5\uc0ac\ud574 \uc624\uac70\ub098 \uc544\ub798\ub97c \ucd94\uac00\ud574 \uc900\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

TEST =<\/span><\/p>\n\n

  <\/span>(DESCRIPTION =<\/span><\/p>\n\n

    <\/span>(ADDRESS = (PROTOCOL = TCP)(HOST =\n10.10.10.40)(PORT = 1521))<\/span><\/p>\n\n

    <\/span>(CONNECT_DATA =<\/span><\/p>\n\n

      <\/span>(SERVER = DEDICATED)<\/span><\/p>\n\n

      <\/span>(SERVICE_NAME = test)<\/span><\/p>\n\n

    <\/span>)<\/span><\/p>\n\n

  <\/span>)<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c sqlplus<\/span>\ub85c \uc811\uc18d<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sqlplus <<\/span>\uc0ac\uc6a9\uc790\uba85>\/<<\/span>\ube44\ubc00\ubc88\ud638>@<<\/span>\uc811\uc18d\uc2dd\ubcc4\uc790> [ as { sysdba | sysoper |\nsysasm } ]<\/span><\/span><\/p>\n\n

\u203b as...<\/span>\uc740 \uad00\ub9ac\uc790 \ud2b9\uad8c\uc744 \uc9c0\uc815\ud55c\ub2e4. sysdba<\/span>\uac00 \uac00\uc7a5 \ub9c9\uac15\ud558\uba70, <\/span>\uc77c\ubc18 \uc0ac\uc6a9\uc790\ub294 \ubd88\ud544\uc694.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\ud14c\uc2a4\ud2b8\uacc4\uc815 \uc811\uc18d (scott)<\/span><\/span><\/p>\n\n

sqlplus\nscott\/tiger@orcl<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- sys <\/span>\uacc4\uc815 \uc811\uc18d<\/span><\/p>\n\n

sqlplus sys\/\"<\/span>\ube44\ubc00\ubc88\ud638\"@orcl\nas sysdba<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- test <\/span>\uacc4\uc815 \uc811\uc18d<\/span><\/p>\n\n

sqlplus test\/\"<\/span>\ube44\ubc00\ubc88\ud638\"@test<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 \uc624\ub77c\ud074 \uc0ac\uc6a9\uc790 \ud655\uc778\ubc29\ubc95<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> SELECT username\nFROM DBA_USERS;<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 \uc0ac\uc6a9\uc790 \uc554\ud638\ubcc0\uacbd(<\/span>\ubcc0\uacbd\uac00\ub2a5\ud55c\uc0ac\ub78c : <\/span>\uc0ac\uc6a9\uc790(<\/span>\ubcf8\uc778), sys,\nsystem)<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> ALTER USER\nscott IDENTIFIED BY \"java401$!\";<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 scott <\/span>\uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CONN\nscott\/\"java401$!\"<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 sys <\/span>\uacc4\uc815 \ub85c\uadf8\uc778<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CONN\nsys\/\"java401$!\"as sysdba<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 scott<\/span>\uc758 \ub77d \ud574\uc81c<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> ALTER USER\nscott ACCOUNT UNLOCK; => sys<\/span>\ub098 system<\/span>\uc73c\ub85c\ub9cc \ud574\uc81c \uac00\ub2a5\ud558\ub2e4.<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 scott <\/span>\uc0ac\uc6a9\uc790\ub85c \ub85c\uadf8\uc778<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CONN\nscott\/\"java401$!\"<\/span><\/p>\n\n

sql> SELECT * FROM\ntabs;<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 \uc0ac\uc6a9\uc790 \ucd94\uac00(sys <\/span>\uacc4\uc815\uc744 \uc811\uc18d\ud55c \uc0c1\ud0dc\uc5d0\uc11c)<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CREATE USER <\/span>\uc0ac\uc6a9\uc790\uba85\nIDENTIFIED BY \"<\/span>\uc554\ud638\";<\/span><\/span><\/p>\n\n\n\n

 <\/span><\/p>\n\n

\u25a0 \uc0ac\uc6a9\uc790\ucd94\uac00 \ud655\uc778<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> SELECT username\nFROM DBA_USERS;<\/span><\/p>\n\n

sql> CONN\nsky\/\"java401$!\"<\/span><\/p>\n\n

\uad8c\ud55c \uc5c6\uc5b4 \uc811\uc18d \ubd88\uac00<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sys <\/span>\uacc4\uc815\uc73c\ub85c\nconn => <\/span>\uad8c\ud55c\uc5c6\uc774 \uc811\uc18d\ud558\uba74 \uc811\uc18d\uc774 \ud480\ub9ac\ubbc0\ub85c \ub2e4\uc2dc sys<\/span>\ub85c conn<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CONN\nsys\/\"java401$!\" as sysdba;<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 conn(<\/span>\uc811\uc18d) <\/span>\ubc0f \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc0ac\uc6a9 \ud560 \uc218 \uc788\ub294 \uad8c\ud55c \ubd80\uc5ec<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> GRANT CONNECT,\nRESOURCE TO <\/span>\uc0ac\uc6a9\uc790\uba85;<\/span><\/span><\/p>\n\n\n\n

 <\/span><\/p>\n\n

- <\/span>\ubaa8\ub4e0\uad8c\ud55c:<\/span><\/span><\/p>\n\n

GRANT CONNECT, DBA,\nRESOURCE TO <<\/span>\uc0ac\uc6a9\uc790\uba85>;<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\ud2b9\uc815\ud14c\uc774\ube14\uc5d0 \ub300\ud55c \ubaa8\ub4e0\uad8c\ud55c:<\/span><\/span><\/p>\n\n

GRANT ALL ON <<\/span>\ud14c\uc774\ube14\uba85>\nTO <<\/span>\uc0ac\uc6a9\uc790\uba85> WITH GRANT OPTION;<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\ub2e4\uc2dc \uc811\uc18d<\/span><\/p>\n\n

 <\/span><\/p>\n\n

sql> CONN\nsky\/\"java401$!\"<\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 \uad8c\ud55c \ud655\uc778\ud558\uae30<\/span><\/p>\n\n

 - <\/span>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec\ub41c \uc2dc\uc2a4\ud15c \uad8c\ud55c \ud655\uc778<\/span><\/p>\n\n

SELECT * FROM\nDBA_SYS_PRIVS<\/span><\/p>\n\n

WHERE GRANTEE = '<\/span>\uc0ac\uc6a9\uc790\uba85'\n;<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec\ub41c \ub864 \ud655\uc778(<\/span>\uc2dc\uc2a4\ud15c \uad8c\ud55c\uc774 \ub864\uc5d0 \ud3ec\ud568\ub428)<\/span><\/span><\/p>\n\n

SELECT * FROM\nDBA_ROLE_PRIVS<\/span><\/p>\n\n

WHERE GRANTEE = '<\/span>\uc0ac\uc6a9\uc790\uba85'\n;<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec\ub41c \ub864\uc5d0 \ubd80\uc5ec\ub41c \uc2dc\uc2a4\ud15c \uad8c\ud55c\n\ud655\uc778<\/span><\/p>\n\n

SELECT * FROM\nDBA_SYS_PRIVS<\/span><\/p>\n\n

WHERE GRANTEE = '<\/span>\ub864\uba85' ;<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

- <\/span>\ud0c0 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ubd80\uc5ec\ud55c \uac1d\uccb4(<\/span>\ud14c\uc774\ube14\ub4f1) <\/span>\uad8c\ud55c \ud655\uc778<\/span><\/p>\n\n

SELECT * FROM\nDBA_TAB_PRIVS<\/span><\/p>\n\n

WHERE OWNER = '<\/span>\ud14c\uc774\ube14\uc18c\uc720\uc790\uba85' ;<\/span><\/span><\/p>\n\n

\ub610\ub294,<\/span><\/span><\/p>\n\n

SELECT * FROM\nDBA_TAB_PRIVS<\/span><\/p>\n\n

WHERE GRANTEE = '<\/span>\uad8c\ud55c\ubd80\uc5ec\uc790\uba85'\n;<\/span><\/span><\/p>\n\n

\u25a0 \uc0ac\uc6a9\uc790 \ubaa9\ub85d \ubcf4\uae30
SELECT * FROM ALL_USERS;

\u25a0 \uc0ac\uc6a9\uc790 \uc0c1\ud0dc \ubcf4\uae30
SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS;

\u25a0 \uc0ac\uc6a9\uc790 \uc0c1\ud0dc \ubcc0\uacbd (\uc0ac\uc6a9\uc790\uac00 \ub77d \uac78\ub824 \uc788\uc744 \uacbd\uc6b0)
ALTER USER scott ACCOUNT UNLOCK;

\u25a0 \uc0c1\ud0dc \ubcf4\uae30

SELECT * FROM TAB -> \ud14c\uc774\ube14 \ubaa9\ub85d \ubcf4\uae30.
SELECT * FROM CAT -> TAB\uacfc \uac19\uc2b5\ub2c8\ub2e4.
SELECT * FROM USER_TABLES -> TAB\uacfc \uac19\uc740\ub370 \ud14c\uc774\ube14\uc758 \uc815\ubcf4\ub3c4 \ub098\uc635\ub2c8\ub2e4.
SELECT * FROM DBA_TABLES -> DBA\uad8c\ud55c\uc774 \uc788\ub294 \uc720\uc800\uac00 \ubaa8\ub4e0 \ud14c\uc774\ube14\uacfc \uadf8 \uc815\ubcf4\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.

\u25a0 \ud14c\uc774\ube14 \uad6c\uc870 \ubcf4\uae30

DESC TEST;
<\/span><\/p>


<\/span><\/p>

\u25a0 SQL \ud30c\uc77c \uc2e4\ud589\ud558\uae30

SQL> start d:\\0_tmp\\create-tables.sql<\/b>
\ub610\ub294
SQL> @d:\\0_tmp\\create-tables.sql<\/b><\/span><\/p>


<\/span><\/p>\n\n

\u25a0 Oracle <\/span>\uc2dc\uc791\/<\/span>\uc885\ub8cc<\/span><\/p>\n\n\n\n

sqlplus<\/span>\ub97c\nsysdba<\/span>\ub85c \uc811\uc18d\ud558\uc5ec.<\/span><\/span><\/p>\n\n

startup;<\/span><\/b><\/p>\n\n<\/b>

shutdown<\/b> [normal,\ntransactional, immediate, abort];<\/span><\/p>\n\n

(<\/span>\ubcf4\ud1b5\nimmediate<\/span>\ub97c \uc0ac\uc6a9)<\/span><\/span><\/p>\n\n

 <\/span><\/p>\n\n

\u25a0 Oracle <\/span>\ub9ac\uc2a4\ub108 \uc2dc\uc791<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- UNIX<\/span><\/p>\n\n

oracle <\/span>\uacc4\uc815\uc73c\ub85c \uc811\uc18d\ud558\uc5ec,<\/span><\/span><\/p>\n\n

lsnrctl start<\/span><\/p>\n\n

 <\/span><\/p>\n\n

- Windows<\/span><\/p>\n\n

\uc11c\ube44\uc2a4\uc5d0\uc11c<\/span><\/p>\n\n

OracleOraDb11g_XXXXXTNSListener\n<\/span>\uc2dc\uc791<\/span><\/p>\n\n

<\/p>\n\n\n

tnsnames.ora<\/a>\ub2e4\uc6b4\ub85c\ub4dc<\/a><\/div>\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[],"class_list":["post-408","post","type-post","status-publish","format-standard","hentry","category-computing_database"],"_links":{"self":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=408"}],"version-history":[{"count":0,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/408\/revisions"}],"wp:attachment":[{"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasu0707.duckdns.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}