ReadHat - HowardWhile/2022_note GitHub Wiki

安裝

https://dotblogs.com.tw/chung1206/2011/06/22/29461

網路都要手動連?

/etc/sysconfig/network-scripts/ifcfg-eth0 把ONBOOT="no"改為yes

yum沒註冊不給用?

https://blog.csdn.net/oraoharu/article/details/106808108

nano /etc/yum/pluginconf.d/subscription-manager.conf

在配置文件中把enable=0即可

[main]
enabled=0 

安裝oracle database

https://ithelp.ithome.com.tw/articles/10128091

ERR_SSL_VERSION_OR_CIPHER_MISMATCH Error

https://simpleoracle.com/2015/10/11/oracle-database-11g-r2-issues-with-accessing-enterprise-manager-ssl_error_weak_server_cert_key/

安裝好後的Database Control - orcl開起來顯示怎麼辦

還需要把電腦的名稱命名成localhost

set ORACLE_UNQNAME=orcl
emctl unsecure dbconsole

之後把網址從

https://localhost:1158/em 改成 http://localhost:1158/em

建立使用者

https://oracled2k.pixnet.net/blog/post/24680289

先使用sqlplus登入

CREATE USER oracle  IDENTIFIED BY oracle;
GRANT CREATE SESSION TO oracle;

為什麼只有localhost連得上

https://my.oschina.net/u/151615/blog/516257

listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )  

把localhost改成0.0.0.0就行

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    )
  )