{"id":68,"date":"2021-01-15T21:53:06","date_gmt":"2021-01-15T21:53:06","guid":{"rendered":"https:\/\/www.cdorde.com\/?p=68"},"modified":"2024-01-18T17:42:57","modified_gmt":"2024-01-18T16:42:57","slug":"instalacija-oracle-xe-18c-na-centos-8","status":"publish","type":"post","link":"https:\/\/www.cdorde.com\/index.php\/2021\/01\/15\/instalacija-oracle-xe-18c-na-centos-8\/","title":{"rendered":"Instalacija Oracle XE 18c na Centos 8"},"content":{"rendered":"\n

Podigao Centos 8 na Hetzneru. U \/etc\/hosts obri\u0161i IPV6 adrese jer to nisam ni pode\u0161avao, a u liniji sa imenom servera upi\u0161i javnu IP adresu servera a ne 127.0.0.1<\/p>\n\n\n\n

a.b.c.d mms-link-shortener mms-link-shortener\n127.0.0.1 localhost.localdomain localhost\n127.0.0.1 localhost4.localdomain4 localhost4<\/code><\/pre>\n\n\n\n
Prvo mora\u0161 instalirati ove pakete. Pored njih sam instalirao i mc, nano, wget, git, docker itd.<\/p>\n\n\n\n
yum install -y gcc-c++ make\nyum install -y ksh\nyum install -y sysstat\nyum install -y xorg-x11-utils\nyum install -y libnsl\nyum install java-11-openjdk-devel\nrpm -ivh libaio-devel-0.3.110-12.el8.x86_64.rpm\nrpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm\nrpm -ivh compat-libcap1-1.10-7.el7.x86_64.rpm\n<\/code><\/pre>\n\n\n\n
Ove rpm fajlove potra\u017ei\u0161 na internetu pa ih downlodzje\u0161 ili direktno instalira\u0161 sa<\/p>\n\n\n\n
wget http:\/\/mirror.centos.org\/centos\/8\/BaseOS\/x86_64\/os\/Packages\/libaio-devel-0.3.112-1.el8.x86_64.rpm\nrpm -ivx libaio-devel-0.3.112-1.el8.x86_64.rpmrpm -ivh http:\/\/mirror.centos.org\/centos\/7\/os\/x86_64\/Packages\/compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm\nrpm -ivh http:\/\/mirror.centos.org\/centos\/7\/os\/x86_64\/Packages\/compat-libcap1-1.10-7.el7.x86_64.rpm<\/code><\/pre>\n\n\n\n
Preinstall fajl sam skinuo sa Oraclove stranice (ima\u0161 u futeru) a instalaciju sa ovim wget-om. Ne znam kako jemogu\u0107e da radi ali radi.<\/p>\n\n\n\n
wget https:\/\/download.oracle.com\/otn-pub\/otn_software\/db-express\/oracle-database-xe-18c-1.0-1.x86_64.rpm\n\nrpm -ivh oracle-database-preinstall-18c-1.0-1.el7.x86_64\nrpm -ivh oracle-database-xe-18c-1.0-1.x86_64.rpm<\/code><\/pre>\n\n\n\n
Na kraju mo\u017ee\u0161 pogledati sadr\u017eaj fajla na putanji \/etc\/sysconfig\/oracle-xe-18c.conf i onda kao root startuje\u0161 skriptu \/etc\/init.d\/oracle-xe-18c configure. Rezultat je:<\/p>\n\n\n\n
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:\nConfirm the password:\nConfiguring Oracle Listener.\nListener configuration succeeded.\nConfiguring Oracle Database XE.\nEnter SYS user password:\n**********************\nEnter SYSTEM user password:\n*******************\nEnter PDBADMIN User Password:\n******************\nPrepare for db operation\n7% complete\nCopying database files\n29% complete\nCreating and starting Oracle instance\n30% complete\n31% complete\n34% complete\n38% complete\n41% complete\n43% complete\nCompleting Database Creation\n47% complete\n50% complete\nCreating Pluggable Databases\n54% complete\n71% complete\nExecuting Post Configuration Actions\n93% complete\nRunning Custom Scripts\n100% complete\nDatabase creation complete. For details check the logfiles at:\n \/opt\/oracle\/cfgtoollogs\/dbca\/XE.\nDatabase Information:\nGlobal Database Name:XE\nSystem Identifier(SID):XE\nLook at the log file \"\/opt\/oracle\/cfgtoollogs\/dbca\/XE\/XE.log\" for further details.\n\nConnect to Oracle Database using one of the connect strings:\n     Pluggable database: mms-link-shortener:1539\/XEPDB1\n     Multitenant container database: mms-link-shortener:1539\nUse https:\/\/localhost:5500\/em to access Oracle Enterprise Manager for Oracle Database XE<\/code><\/pre>\n\n\n\n
Ako ho\u010de\u0161 da se Oralce XE 18c automatski startuje onda otkuca\u0161 kao root<\/p>\n\n\n\n
[root@mms-link-shortener ~]# systemctl daemon-reload\n[root@mms-link-shortener ~]# systemctl enable oracle-xe-18c<\/code><\/pre>\n\n\n\n
Ako ho\u010de\u0161 da se environment varijable za Oracle automatski postavepo logogovanju otvori fajl sa<\/p>\n\n\n\n
nano \/etc\/profile.d\/set_oraenv.sh<\/code><\/pre>\n\n\n\n
I u njega dokucaj<\/p>\n\n\n\n
nano \/etc\/profile.d\/set_oraenv.sh\n\nexport ORACLE_SID=XE\nexport ORACLE_HOME=\/opt\/oracle\/product\/18c\/dbhomeXE\nexport ORACLE_BASE=\/opt\/oracle\nexport PATH=$PATH:\/opt\/oracle\/product\/18c\/dbhomeXE\/bin<\/code><\/pre>\n\n\n\n
Po otklju\u010davaj portove i pazi da po defaultu listener port nije 1521 ve\u0107 1539. SID je XE.  Ako firewalld nije instaliran instaliraj ga sa<\/p>\n\n\n\n
dnf install firewalld<\/code><\/pre>\n\n\n\n
[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --add-service=https\nsuccess\n[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --add-service=http\nsuccess\n[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --reload\nsuccess\n[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --zone=public --add-port=1521\/tcp\nsuccess\n[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --permanent --zone=public --add-port=1539\/tcp\nsuccess\n[root@mms-link-shortener docker-oracle-xe]# firewall-cmd --reload<\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Podigao Centos 8 na Hetzneru. U \/etc\/hosts obri\u0161i IPV6 adrese jer to nisam ni pode\u0161avao, a u liniji sa imenom servera upi\u0161i javnu IP adresu servera a ne 127.0.0.1 Prvo mora\u0161 instalirati ove pakete. Pored njih sam instalirao i mc, nano, wget, git, docker itd. Ove rpm fajlove potra\u017ei\u0161 na internetu pa ih downlodzje\u0161 ili … <\/p>\n
Continue reading “Instalacija Oracle XE 18c na Centos 8”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[7,5,6],"tags":[10,9,8],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-instalacije","category-it","category-oracle","tag-18c","tag-instlaacije","tag-oracle"],"_links":{"self":[{"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":18,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"predecessor-version":[{"id":1251,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/posts\/68\/revisions\/1251"}],"wp:attachment":[{"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cdorde.com\/index.php\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}