# Oracle安裝 ## 安裝環境 ### 1.到官網安裝 19c https://www.oracle.com/database/technologies/oracle19c-windows-downloads.html ![](https://i.imgur.com/yvZyjqc.png) ### 2.解壓縮執行setup.exe (記得開啟管理者權限) ![](https://i.imgur.com/3buJZTU.png) ### 3.安裝oracle 本地已經安裝過用網路圖片代替) ![](https://i.imgur.com/4CD90QN.png) ![](https://i.imgur.com/5bni9yo.png) ![](https://i.imgur.com/QXMUxps.png) ![](https://i.imgur.com/Rv35lH6.png) ![](https://i.imgur.com/jptRjLh.png) ![](https://i.imgur.com/Bb2U0Rc.png) ![](https://i.imgur.com/OUCqxC2.png) ![](https://i.imgur.com/5SE4cO9.png) ### 4.安裝DB 4.1啟動dbca開啟cmd(管理者權限)輸入 dbca ![](https://i.imgur.com/VxPZkPj.png) 4.2 安裝DB (本機安裝過以下使用網路圖片) ![](https://i.imgur.com/Hy7jz6g.png) ![](https://i.imgur.com/JwX3NfE.png) ![](https://i.imgur.com/6y7mCQ6.png) ![](https://i.imgur.com/gx1OCp7.png) ![](https://i.imgur.com/dA9s07I.png) ![](https://i.imgur.com/bALCYxb.png) ![](https://i.imgur.com/Eq2PUUl.png) ![](https://i.imgur.com/TIVHfQm.png) ![](https://i.imgur.com/NK5hqMb.png) ![](https://i.imgur.com/BjfhbM8.png) ![](https://i.imgur.com/o9X8bzu.png) ![](https://i.imgur.com/761KOXs.png) ![](https://i.imgur.com/LjePcKp.png) ![](https://i.imgur.com/oWGcR5j.png) ![](https://i.imgur.com/T46FAzj.png) ![](https://i.imgur.com/pgOeWDQ.png) ![](https://i.imgur.com/m4uXQy6.png) ### 5.測試安裝成功 開始 CMD 輸入 sqlplus as sysdba有出現以下就代表安裝成功 ![](https://i.imgur.com/L70henC.png) ### 6.開啟oracle服務 查看服務有沒有啟動，如果沒有手動啟動 ![](https://i.imgur.com/qNhK0aE.png) ### 7.建立帳號 7.1 打開CMD輸入 `sqlplus sys as sysdba` ![](https://i.imgur.com/n3E2wDT.png) 7.2建立user `create user username identified by pwd;` username 跟 pwd 自行帶入 ![](https://i.imgur.com/H8yvRm4.png) 7.3解除封鎖 `alter user username account unlock;` ![](https://i.imgur.com/EfPVzpE.png) 7.4授予 user權限 `grant create session to username` `grant dba to tcmp` ![](https://i.imgur.com/03e4yCh.png) ### 8.連線 ![](https://i.imgur.com/UwEHwNL.png) ### 9.圖片來源 https://www.modb.pro/db/38320