\uc6b0\ubd84\ud22c \ub9ac\ub205\uc2a4\uc5d0\uc11c python3, django, oracle 19c \uc0ac\uc6a9\ud558\uae30.<\/p>\n
* \uc791\uc5c5 \ud658\uacbd
\nOS: ubuntu 22.04
\nip address : 172.30.124.211 (\uc624\ub77c\ud074 \uc124\uce58\ub41c \uc11c\ubc84 \uc544\ub2d8)
\npython: python3.10.12
\noracle client: \uc124\uce58\ub428.
\ndjango: 5.0.4
\nOracle \ub370\uc774\ud130\ubca0\uc774\uc2a4 : SCAN IP 172.30.124.241, 172.30.124.242,172.30.124.243 <\/p>\n
* \uc8fc\uc758\uc0ac\ud56d
\ncx_Oracle \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\uba74 \uc624\ub77c\ud074 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5c6\uc774 \ud30c\uc774\uc36c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc791\uc131\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4.
\n\ud558\uc9c0\ub9cc Django \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub824\uba74, \uc624\ub77c\ud074 \ud074\ub77c\uc774\uc5b8\ud2b8\uac00 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4.
\n\uc624\ub77c\ud074 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc124\uce58\ub294 \uc544\ub798 \uae00\uc744 \ucc38\uace0\ud558\uba74 \ub41c\ub2e4.
\nhttps:\/\/blog.boxcorea.com\/wp\/archives\/3700<\/p>\n
1. cx_Oracle \ud328\ud0a4\uc9c0 \uc124\uce58.<\/p>\n
(venv) $ pip install cx_oracle\r\nCollecting cx_oracle \r\n...\r\n<\/pre>\n2. \ud14c\uc2a4\ud2b8 \ucf54\ub4dc \uc791\uc131<\/p>\n
import cx_Oracle\r\n\r\ndef test_oracle():\r\n dsn_tns = cx_Oracle.makedsn(host='172.30.124.242', port='1521', service_name='orcl')\r\n con = cx_Oracle.connect(user='fox', password='fox123', dsn=dsn_tns)\r\n cur = con.cursor()\r\n cur.execute('select * from test')\r\n for i in cur:\r\n print(i)\r\n cur.close()\r\n con.close()\r\n\r\n\r\nif __name__ == '__main__':\r\n test_oracle()<\/pre>\n\ucf54\ub4dc \uc2e4\ud589 \uacb0\uacfc \uc774\uc0c1 \uc5c6\uc774 \uc798 \uc2e4\ud589\ub428.<\/p>\n
(venv) $ python main.py\r\n(2, 'snowfox')\r\n(1, 'poss')\r\n<\/pre>\n<\/p>\n
3. django \uc124\uce58.<\/p>\n
(venv) $ pip install django<\/pre>\n4. django \ud504\ub85c\uc81d\ud2b8 \ub9cc\ub4e4\uae30. <\/p>\n
\ud504\ub85c\uc81d\ud2b8 \uc774\ub984 oraTest\ub85c \uc7a5\uace0 \ud504\ub85c\uc81d\ud2b8\ub97c \ub9cc\ub4e0\ub2e4.<\/p>\n
(venv) $ django-admin startproject oraTest<\/pre>\nsettings.py \uac00 \uc788\ub294 \ub514\ub809\ud1a0\ub9ac\ub85c \uc774\ub3d9\ud558\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud56d\ubaa9\uc744 \uc218\uc815\ud55c\ub2e4.<\/p>\n
(venv) $ cd oraTest\/oraTest\/<\/pre>\n(venv) oraTest\/oraTest$ vi settings.py\r\nDATABASES = {\r\n # 'default': {\r\n # 'ENGINE': 'django.db.backends.sqlite3',\r\n # 'NAME': BASE_DIR \/ 'db.sqlite3',\r\n # }\r\n 'default': {\r\n 'ENGINE': 'django.db.backends.oracle',\r\n 'NAME': 'orcl', # oracle service name \r\n 'USER': 'fox',\r\n 'PASSWORD': 'fox123',\r\n 'HOST': '172.30.124.243',\r\n 'PORT': '1521',\r\n }<\/pre>\n\uc774\ub807\uac8c \uc124\uc815\ud558\uc600\uc73c\ub098, <\/p>\n
django.db.utils.OperationalError: DPY-6005: cannot connect to database (CONNECTION_ID=eMkjmK1PMCPNdhtYy5Tdwg==).
\nDPY-6003: SID “orcl” is not registered with the listener at host “172.30.124.241” port 1521. (Similar to ORA-12505)<\/p>\n\uc624\ub958 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
grid \uc11c\ube44\uc2a4 \uc774\ub984\uc778 orcl \ub300\uc2e0, \uac01 \ub178\ub4dc\uc5d0\uc11c \uc2e4\ud589\uc911\uc778 SID(orcl1 \ub610\ub294 orcl2) \uc911 \uc784\uc758\uc758 SID\ub97c \uc124\uc815\ud558\uba74 \uc811\uc18d\uc774 \uc798 \ub41c\ub2e4.<\/p>\n
DATABASES = {\r\n # 'default': {\r\n # 'ENGINE': 'django.db.backends.sqlite3',\r\n # 'NAME': BASE_DIR \/ 'db.sqlite3',\r\n # }\r\n 'default': {\r\n 'ENGINE': 'django.db.backends.oracle',\r\n 'NAME': 'orcl2', # oracle SID (orcl1 \ub610\ub294 orcl2\uc911 \ud558\ub098 \uc124\uc815)\r\n 'USER': 'fox',\r\n 'PASSWORD': 'fox123',\r\n 'HOST': '172.30.124.242', # SCAN IP \uc911 \uc784\uc758\uc758 IP \uc8fc\uc18c \uc124\uc815\r\n 'PORT': '1521',\r\n }\r\n}<\/pre>\n\uc544\ub798 \uba85\ub839\uc73c\ub85c \ud504\ub85c\uc81d\ud2b8 \uae30\ubcf8 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e0\ub2e4.<\/p>\n
(venv) snowfox@foo:~\/PycharmProjects\/conOracle\/oraTest$ python manage.py migrate<\/pre>\n\uc7a5\uace0 \uad00\ub9ac\uc790\ub97c \ub9cc\ub4e0\ub2e4.<\/p>\n
(venv) snowfox@foo:~\/PycharmProjects\/conOracle\/oraTest$ python manage.py createsuperuser<\/pre>\n\uc624\ub77c\ud074 \uc811\uc18d\ud558\uc5ec \ud14c\uc774\ube14 \ud655\uc778\ud574 \ubcf4\uba74.<\/p>\n
snowfox@foo:~$ sqlplus fox\/fox123@172.30.124.241\/orcl\r\n\r\nSQL*Plus: Release 21.0.0.0.0 - Production on \uae08 4\uc6d4 19 14:53:16 2024\r\nVersion 21.13.0.0.0\r\n\r\nCopyright (c) 1982, 2022, Oracle. All rights reserved.\r\n\r\n\ub9c8\uc9c0\ub9c9 \uc131\uacf5\ud55c \ub85c\uadf8\uc778 \uc2dc\uac04: \uae08 4\uc6d4 19 2024 14:52:52 +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> set heading off\r\nSQL> select * from tab;\r\n\r\nTEST\r\nTABLE\r\n\r\nDJANGO_MIGRATIONS\r\nTABLE\r\n\r\nDJANGO_CONTENT_TYPE\r\nTABLE\r\n\r\nAUTH_PERMISSION\r\nTABLE\r\n\r\nAUTH_GROUP\r\n\r\nTABLE\r\n\r\nAUTH_GROUP_PERMISSIONS\r\nTABLE\r\n\r\nAUTH_USER\r\nTABLE\r\n\r\nAUTH_USER_GROUPS\r\nTABLE\r\n\r\nAUTH_USER_USER_PERMISSIONS\r\nTABLE\r\n\r\n\r\nDJANGO_ADMIN_LOG\r\nTABLE\r\n\r\nDJANGO_SESSION\r\nTABLE\r\n\r\n\r\n11 \ud589\uc774 \uc120\ud0dd\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/pre>\n\uc704\ucc98\ub7fc django \uad00\ub828 \ud14c\uc774\ube14\uc774 \ub9cc\ub4e4\uc5b4 \uc84c\ub2e4.<\/p>\n
* \ucc38\uace0:
\n\uc544\ub798\ub294 \uc124\uce58\ub41c \ud30c\uc774\uc36c \ud328\ud0a4\uc9c0.<\/p>\n(venv) $ pip freeze\r\nasgiref==3.8.1\r\ncffi==1.16.0\r\ncryptography==42.0.5\r\ncx-Oracle==8.3.0\r\nDjango==5.0.4\r\npycparser==2.22\r\nsqlparse==0.5.0\r\ntyping_extensions==4.11.0<\/pre>\n","protected":false},"excerpt":{"rendered":"\uc6b0\ubd84\ud22c \ub9ac\ub205\uc2a4\uc5d0\uc11c python3, django, oracle 19c \uc0ac\uc6a9\ud558\uae30. * \uc791\uc5c5 \ud658\uacbd OS: ubuntu 22.04 ip address : 172.30.124.211 (\uc624\ub77c\ud074 \uc124\uce58\ub41c \uc11c\ubc84 \uc544\ub2d8) python: python3.10.12 oracle client: \uc124\uce58\ub428. django: 5.0.4 Oracle \ub370\uc774\ud130\ubca0\uc774\uc2a4 : SCAN IP 172.30.124.241, 172.30.124.242,172.30.124.243 * \uc8fc\uc758\uc0ac\ud56d cx_Oracle \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud558\uba74 \uc624\ub77c\ud074 \ud074\ub77c\uc774\uc5b8\ud2b8\uc5c6\uc774 \ud30c\uc774\uc36c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc791\uc131\ud558\uace0 \uc2e4\ud589\ud560 \uc218 \uc788\ub2e4. \ud558\uc9c0\ub9cc Django \ud504\ub85c\uadf8\ub7a8\uc5d0\uc11c \uc624\ub77c\ud074 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub824\uba74, \uc624\ub77c\ud074 … <\/p>\n