{"id":5017,"date":"2013-07-30T09:00:18","date_gmt":"2013-07-30T06:00:18","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=5017"},"modified":"2013-07-29T23:14:00","modified_gmt":"2013-07-29T20:14:00","slug":"oracle-enterprise-linux-isletim-sisteminde-standalone-veritabanini-elle-klonlama-manually-cloning","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=5017","title":{"rendered":"Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone Veritaban\u0131n\u0131 Elle Klonlama (Manually Cloning)"},"content":{"rendered":"<p style=\"text-align: justify;\"><a href=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDbEnt.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-800\" alt=\"OracleDbEnt\" src=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDbEnt.jpg\" width=\"308\" height=\"223\" srcset=\"https:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDbEnt.jpg 308w, https:\/\/www.koraykey.com\/wp-content\/uploads\/OracleDbEnt-300x217.jpg 300w\" sizes=\"auto, (max-width: 308px) 100vw, 308px\" \/><\/a><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalemizde &#8220;Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone Veritaban\u0131n\u0131 Elle Klonlama (Manually Cloning)&#8221; konusunu inceleyece\u011fiz. Bu yap\u0131land\u0131rma sayesinde mevcut \u00e7al\u0131\u015fan bir veritaban\u0131n\u0131 hi\u00e7 kurulum yap\u0131lmam\u0131\u015f bir sunucuya elle ta\u015f\u0131yarak \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayaca\u011f\u0131z. Bu yap\u0131land\u0131rma \u00f6zellikle test ortamlar\u0131 i\u00e7in veritaban\u0131 olu\u015fturma i\u015flemlerimizi k\u0131sa s\u00fcrede yapmam\u0131z\u0131 sa\u011flayacakt\u0131r. Ancak bu yap\u0131land\u0131rma ger\u00e7ek (production) ortamlar i\u00e7in kesinlikle \u00f6nerilen bir yap\u0131land\u0131rma de\u011fildir. \u0130\u015flemlerimizi mevcut \u00e7al\u0131\u015fan bir veritaban\u0131ndan \u00fczerinde oracle kurulu olmayan bir sunucuya do\u011fru yapaca\u011f\u0131z. \u0130\u015flemler i\u00e7in &#8220;Oracle Enterprise Linux&#8221; i\u015fletim sistemi kullan\u0131lm\u0131\u015ft\u0131r ve t\u00fcm Red Hat t\u00fcrevi i\u015fletim sistemleri ile uyumludur. Veritaban\u0131 olarak da &#8220;Oracle 11g R2 (11.2.0.3) Enterprise Edition&#8221; kullan\u0131lm\u0131\u015ft\u0131r. Klonlama yapaca\u011f\u0131m\u0131z sunucunun kaynak sunucu ile versiyonunun ve yap\u0131land\u0131rmas\u0131n\u0131n ayn\u0131 olmas\u0131na dikkat etmeliyiz.<\/span><\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Dikkat Edilecekler;<\/span><\/strong><\/p>\n<ul>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu i\u015flem h\u0131zl\u0131 bir \u015fekilde test ortam\u0131 yaratabilmemiz i\u00e7in kolayl\u0131k sa\u011flayacaktr. Kesinlikle ger\u00e7ek (production) ortamlar i\u00e7in uygulanmamal\u0131d\u0131r. Bu tip durumlarda temiz yeni y\u00fckleme i\u015flemi yap\u0131lmal\u0131d\u0131r.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu i\u015flem Cluster (Rac) ve ASM (Grid) ortamlar\u0131nda uygulanamaz. Sadece Single instance ve dosya sistemi (File System) kullanan ortamlar i\u00e7indir. ASM (Grid) ortamlar\u0131nda yap\u0131land\u0131rma i\u015flemi \u00e7ok detayl\u0131 olup \u00e7al\u0131\u015fmama ihtimali y\u00fcksektir.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klon i\u015flemi yap\u0131lacak sunucu ile kaynak sunucunun i\u015fletim sistemleri ve versiyonlar\u0131n\u0131n ayn\u0131 olmas\u0131 gerekmektedir.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klon i\u015flemi yap\u0131lacak sunucuda Oracle Veritaban\u0131 i\u00e7in gerekli olan \u00f6ngereksinimlerin yap\u0131land\u0131r\u0131lm\u0131\u015f olmas\u0131 gerekmektedir.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klon i\u015flemi yap\u0131lacak sunucuda disk alan\u0131 ve bellek miktar\u0131 en az kaynak sunucu kadar olmal\u0131d\u0131r. Daha d\u00fc\u015f\u00fck veya y\u00fcksek sistem kaynaklar\u0131 ile \u00e7al\u0131\u015ft\u0131r\u0131lacaksa klonlama i\u015flemi sonras\u0131 parametrelerin buna g\u00f6re ayarlanmas\u0131 gerekmektedir.<\/span><\/li>\n<li style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klonlama i\u015flemi sonras\u0131 &#8220;network files&#8221; dedi\u011fimiz &#8220;listener.ora&#8221; ve &#8220;tnsnames.ora&#8221; dosyalar\u0131nda &#8220;hostname&#8221; veya IP adresi gibi parametrelerin klonlama yap\u0131lan sunucuya g\u00f6re d\u00fczenlenmesi gerekmektedir.<\/span><\/li>\n<\/ul>\n<p><strong><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Sunucu Yap\u0131land\u0131rmas\u0131;<\/span><\/strong><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Kaynak Sunucu \u00d6zellikleri<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130\u015fletim Sistemi\t\t: Oracle Enterprise Linux 6.4 64 Bit<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Sunucu ismi\t\t: koraykey-db1.localdomain<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">IP Adresi\t\t: 192.168.2.121<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Hedef (Klonlama Yap\u0131lacak) Sunucu \u00d6zellikleri<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\u0130\u015fletim Sistemi\t\t: Oracle Enterprise Linux 6.4 64 Bit<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Sunucu ismi\t\t: koraykey-db2.localdomain<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">IP Adresi\t\t: 192.168.2.122<\/span><\/pre>\n<p style=\"text-align: justify;\">1. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klonlama i\u015flemi yap\u0131lacak sunucumuza i\u015fletim sistemimizi kaynak veritaban\u0131m\u0131zdaki i\u015fletim sistemi ile ayn\u0131 \u015fekilde kuruyoruz. \u00d6rnek kurulum i\u00e7in <a title=\"Oracle Enterprise Linux 6.x Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=228\">&#8220;Oracle Enterprise Linux Kurulumu&#8221;<\/a> yaz\u0131m\u0131zdan faydalanabilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\">2. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Klonlama yap\u0131lacak sunucumuzda veritaban\u0131 kurulum i\u015flemi \u00f6ncesi gerekli olan \u00f6ngereksinim yap\u0131land\u0131rmas\u0131n\u0131 tamamlamal\u0131y\u0131z. \u00d6rnek yap\u0131land\u0131rma i\u00e7in <a title=\"Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu\" href=\"http:\/\/www.koraykey.com\/?p=1565\">&#8220;Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu&#8221;<\/a> yaz\u0131m\u0131zdan veya <a href=\"http:\/\/tahiti.oracle.com\/\" target=\"_blank\">&#8220;Oracle Tahiti&#8221;<\/a> sitesinden faydalanabilirsiniz.<\/span><\/p>\n<p style=\"text-align: justify;\">3. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Kaynak sunucumuzdaki \u00e7al\u0131\u015fan veritaban\u0131 servislerimizi durdurmak i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki i\u015flemleri \"oracle\" kullan\u0131c\u0131m\u0131z ile yap\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># su - oracle<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Oracle Enterprise Manager konsolumuzu durduruyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ emctl stop dbconsole<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131 ve network servislerimizi durduruyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ dbshut $ORACLE_HOME<\/span><\/pre>\n<p style=\"text-align: justify;\">4. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131 yaz\u0131l\u0131m\u0131m\u0131z\u0131n ve veri dosyalar\u0131n\u0131n (datafile) bulundu\u011fu disk veya dizini s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosya olarak haz\u0131rlamak i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki i\u015flemleri \"root\" kullan\u0131c\u0131s\u0131 ile yap\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131 yaz\u0131l\u0131m\u0131m\u0131z\u0131n ve veri dosyalar\u0131n\u0131n (datafile) bulundu\u011fu disk veya\r\ndizini s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f <\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">dosya olarak haz\u0131rl\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># tar -cvf \/tmp\/oracle.tar \/u01<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># gzip \/tmp\/oracle.tar<\/span><\/pre>\n<p style=\"text-align: justify;\">5. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Kaynak sunucumuzda olu\u015fturdu\u011fumuz s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131 hedef sunucumuza &#8220;secure ssh&#8221; ile kopyalamak i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Kaynak sunucumuzda a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz ve istedi\u011fi bilgileri\r\ngiriyoruz. Bu i\u015flem s\u00fcresi \u00f6zellikle \"datafile\" dosyalar\u0131m\u0131z\u0131n b\u00fcy\u00fckl\u00fc\u011f\u00fcne g\u00f6re\r\nde\u011fi\u015fecektir.\r\n\r\n# scp \/tmp\/oracle.tar.gz root@koraykey-db2:\/tmp\/oracle.tar.gz<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">The authenticity of host 'koraykey-db2 (192.168.2.122)' can't be established.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">RSA key fingerprint is 7b:5a:92:8e:93:42:e6:60:50:d5:9e:6e:c6:86:24:21.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Are you sure you want to continue connecting (yes\/no)? yes<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Warning: Permanently added 'koraykey-db2,192.168.2.122' (RSA)<\/span><\/pre>\n<p style=\"text-align: justify;\">6. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuza kopyalad\u0131\u011f\u0131m\u0131z s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131 a\u00e7mak i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Hedef sunucumuzda s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131 orjinal yerlerine a\u00e7mak a\u015fa\u011f\u0131daki\r\nkomutlar\u0131 s\u0131ras\u0131yla \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># gunzip \/tmp\/oracle.tar.gz<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># cd \/<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># tar -xvf \/tmp\/oracle.tar<\/span><\/pre>\n<p style=\"text-align: justify;\">7. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda a\u00e7t\u0131\u011f\u0131m\u0131z dosyalar\u0131n sahiplik izinlerini ayarlamak i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Hedef sunucumuzda a\u00e7t\u0131\u011f\u0131m\u0131z dosyalar\u0131n sahipli\u011fini ayarl\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># chown -R oracle:oinstall \/u01<\/span><\/pre>\n<p style=\"text-align: justify;\">8. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda &#8220;Post Installation&#8221; i\u015flemlerimizi ger\u00e7ekle\u015ftiriyoruz. Bunun i\u00e7in veritaban\u0131 kurulumunda kulland\u0131\u011f\u0131m\u0131z scriptleri a\u015fa\u011f\u0131daki gibi \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Post Installation i\u015flemleri i\u00e7in a\u015fa\u011f\u0131daki scriptleri \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># \/u01\/app\/oraInventory\/orainstRoot.sh<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># \/u01\/app\/oracle\/product\/11.2.0.3\/db\/root.sh<\/span><\/pre>\n<p style=\"text-align: justify;\">9. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda &#8220;oracle&#8221; kullan\u0131c\u0131m\u0131z\u0131n &#8220;.bash_profile&#8221; dosyas\u0131n\u0131 a\u015fa\u011f\u0131daki gibi sunucu sistemimize g\u00f6re d\u00fczenliyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">$ cd<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ vim .bash_profile<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\"># Oracle bash_profile Environment Settings<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TMP=\/tmp; export TMP<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">TMPDIR=$TMP; export TMPDIR<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOSTNAME=koraykey-db2.localdomain; export ORACLE_HOSTNAME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">DB_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export DB_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOME=$DB_HOME; export ORACLE_HOME<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_SID=orcl; export ORACLE_SID<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORACLE_TERM=xterm; export ORACLE_TERM<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">BASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">PATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 10px;\">CLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">if [ $USER = \"oracle\" ]; then<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  if [ $SHELL = \"\/bin\/ksh\" ]; then<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -p 16384<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -n 65536<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  else<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    ulimit -u 16384 -n 65536<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  fi<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">fi<\/span><\/pre>\n<p style=\"text-align: justify;\">10. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzdaki &#8220;network files&#8221; dedi\u011fimiz &#8220;listener.ora&#8221; ve &#8220;tnsnames.ora&#8221; dosyalar\u0131nda &#8220;hostname&#8221; veya IP adresi gibi parametrelerin klonlama yap\u0131lan sunucuya g\u00f6re d\u00fczenliyoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- \"listener.ora\" dosyam\u0131z\u0131 yeni sunucumuza g\u00f6re d\u00fczenliyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ vim \/u01\/app\/oracle\/product\/11.2.0.3\/db\/network\/admin\/listener.ora<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">LISTENER =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (DESCRIPTION_LIST =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (DESCRIPTION =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (ADDRESS = (PROTOCOL = TCP)(HOST = koraykey-db2.localdomain)(PORT = 1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ADR_BASE_LISTENER = \/u01\/app\/oracle<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- \"tnsnames.ora\" dosyam\u0131z\u0131 yeni sunucumuza g\u00f6re d\u00fczenliyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ vim \/u01\/app\/oracle\/product\/11.2.0.3\/db\/network\/admin\/tnsnames.ora<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">ORCL =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  (DESCRIPTION =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (ADDRESS = (PROTOCOL = TCP)(HOST = koraykey-db2.localdomain)(PORT = 1521))<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    (CONNECT_DATA =<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVER = DEDICATED)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">      (SERVICE_NAME = orcl)<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">    )<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">  )<\/span><\/pre>\n<p style=\"text-align: justify;\">11. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda servislerimizin otomatik ba\u015flamas\u0131 i\u00e7in gerekli ayarlar\u0131 yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- A\u015fa\u011f\u0131daki dosyam\u0131za gerekli parametreyi ekliyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">orcl:\/u01\/app\/oracle\/product\/11.2.0.3\/db:Y<\/span><\/pre>\n<p style=\"text-align: justify;\">12. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda veritaban\u0131 i\u015flemlerimiz tamamland\u0131. \u015eimdi klonlama i\u015flemi yapt\u0131\u011f\u0131m\u0131z veritaban\u0131m\u0131z\u0131 ba\u015flat\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Veritaban\u0131m\u0131z\u0131 ba\u015flatmak i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ dbstart $ORACLE_HOME<\/span><\/pre>\n<p style=\"text-align: justify;\">13. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Veritaban\u0131m\u0131z\u0131n durumunu kontrol etmek i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Klonlanm\u0131\u015f veritaban\u0131m\u0131za ba\u011flan\u0131yoruz ve \"instance\" durumumuzu sorguluyoruz.\r\n\r\n$ sqlplus \/ as sysdba <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 29 19:25:14 2013<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Connected to:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">With the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">SQL&gt; select status from v$instance;<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">STATUS<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OPEN<\/span><\/pre>\n<p style=\"text-align: justify;\">14. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda veritaban\u0131m\u0131zdan sonra &#8220;Enterprise Manager&#8221; y\u00f6netim konsolumuzuda yeniden yap\u0131land\u0131rmam\u0131z gerekmektedir. Bunun i\u00e7in a\u015fa\u011f\u0131daki i\u015flemleri hedef sunucumuzda uygulamal\u0131y\u0131z.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Sunucumuzda \"Enterprise Manager\" konsolumuzun durumunu sorgulamak i\u00e7in a\u015fa\u011f\u0131daki\r\nkomutu \u00e7al\u0131\u015ft\u0131rabiliriz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ emctl status dbconsole<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">OC4J Configuration issue.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi hata vermektedir. Yap\u0131land\u0131rma i\u015flemi \u00f6ncesi \"Listener\" ve\r\nveritaban\u0131 servisimizin <\/span><span style=\"font-family: courier new,courier; font-size: 12px;\">\u00e7al\u0131\u015f\u0131r durumda oldu\u011fundan emin olmal\u0131y\u0131z<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- Sunucumuzda \"Enterprise Manager\" \"repository\" yeniden yarat\u0131yoruz ve bu i\u015flem\r\ns\u0131ras\u0131ndan bizden istedi\u011fi bilgileri a\u015fa\u011f\u0131daki gibi giriyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ emca -config dbcontrol db -repos recreate<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">STARTED EMCA at Jul 29, 2013 7:32:16 PM<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">EM Configuration Assistant, Version 11.2.0.3.0 Production<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 2003, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Enter the following information:<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database SID: orcl<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Listener port number: 1521<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Listener ORACLE_HOME [ \/u01\/app\/oracle\/product\/11.2.0.3\/db ]: <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Password for SYS user: ********** <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Password for DBSNMP user: **********<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Password for SYSMAN user: ********** <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Email address for notifications (optional): <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Outgoing Mail (SMTP) server for notifications (optional): <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-----------------------------------------------------------------<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">You have specified the following settings<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database ORACLE_HOME ................ \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Local hostname ................ koraykey-db2.localdomain<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Listener ORACLE_HOME ................ \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Listener port number ................ 1521<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Database SID ................ orcl<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Email address for notifications ............... <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Outgoing Mail (SMTP) server for notifications ............... <\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-----------------------------------------------------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">WARNING : While repository is dropped the database will be put in quiesce mode.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-----------------------------------------------------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Do you wish to continue? [yes(Y)\/no(N)]: y<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Jul 29, 2013 7:33:04 PM oracle.sysman.emcp.EMConfig perform<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">INFO: This operation is being logged at<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/u01\/app\/oracle\/cfgtoollogs\/emca\/orcl\/emca_2013_07_29_19_32_15.log.\r\n.\r\n.\r\n.\r\nEnterprise Manager configuration completed successfully\r\nFINISHED EMCA at Jul 29, 2013 7:41:28 PM\r\n<\/span><\/pre>\n<p style=\"text-align: justify;\">15. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzdaki yap\u0131land\u0131rd\u0131\u011f\u0131m\u0131z &#8220;Enterprise Manager&#8221; konsolumuzun \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan emin olmak i\u00e7in gerekli kontrollerimizi yap\u0131yoruz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">-- Enterprise Manager konsolumuzun durumunu sorguluyoruz.<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">$ emctl status dbconsole<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">https:\/\/koraykey-db2.localdomain:5500\/em\/console\/aboutApplication<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Oracle Enterprise Manager 11g is running. <\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">------------------------------------------------------------------<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">Logs are generated in directory<\/span>\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">\/u01\/app\/oracle\/product\/11.2.0.3\/db\/koraykey-db2.localdomain_orcl\/sysman\/log<\/span>\r\n\r\n<span style=\"font-family: courier new,courier; font-size: 12px;\">-- G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi Enterprise Manager konsolumuz art\u0131k \u00e7al\u0131\u015f\u0131yor.<\/span><\/pre>\n<p style=\"text-align: justify;\">16. <span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Hedef sunucumuzda Internet taray\u0131c\u0131m\u0131z ile konsolumuza a\u015fa\u011f\u0131daki gibi ba\u011flanabilir ve kullanabiliriz.<\/span><\/p>\n<pre class=\"brush: bash; gutter: false; first-line: 1\"><span style=\"font-family: courier new,courier; font-size: 12px;\">https:\/\/koraykey-db2.localdomain:5500\/em\/<\/span><\/pre>\n<p style=\"text-align: justify;\"><a href=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/CloneDBEm_1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-5019\" alt=\"CloneDBEm_1\" src=\"http:\/\/www.koraykey.com\/wp-content\/uploads\/CloneDBEm_1-1024x459.jpg\" width=\"640\" height=\"286\" srcset=\"https:\/\/www.koraykey.com\/wp-content\/uploads\/CloneDBEm_1-1024x459.jpg 1024w, https:\/\/www.koraykey.com\/wp-content\/uploads\/CloneDBEm_1-640x287.jpg 640w, https:\/\/www.koraykey.com\/wp-content\/uploads\/CloneDBEm_1.jpg 1152w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bu makalemizde &#8220;Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone Veritaban\u0131n\u0131 Elle Klonlama (Manually Cloning)&#8221; i\u015flemini inceledik. Yukar\u0131daki i\u015flemler &#8220;Oracle Enterprise Linux&#8221; i\u015fletim sisteminde uygulanm\u0131\u015ft\u0131r ve Red Hat t\u00fcrevi (CentOS vb.) i\u015fletim sistemlerinde ge\u00e7erlidir.<\/span><\/p>\n<p style=\"text-align: justify;\"><span style=\"font-family: arial,helvetica,sans-serif; font-size: 12px;\">Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek dile\u011fiyle\u2026<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu makalemizde &#8220;Oracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone Veritaban\u0131n\u0131 Elle Klonlama (Manually Cloning)&#8221; konusunu inceleyece\u011fiz. Bu yap\u0131land\u0131rma sayesinde mevcut \u00e7al\u0131\u015fan bir veritaban\u0131n\u0131 hi\u00e7 kurulum yap\u0131lmam\u0131\u015f bir sunucuya elle ta\u015f\u0131yarak \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayaca\u011f\u0131z. Bu yap\u0131land\u0131rma \u00f6zellikle test ortamlar\u0131 i\u00e7in veritaban\u0131 olu\u015fturma i\u015flemlerimizi &hellip; <a href=\"https:\/\/www.koraykey.com\/?p=5017\">Okumaya devam et <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[21,290,20,19,752,755,753,757,756,750,754,751],"class_list":["post-5017","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-oracle-database-clone","tag-oracle-database-clone-copy","tag-oracle-database-clone-islemi","tag-oracle-database-manually-cloning","tag-oracle-veritabani-clone-copy","tag-oracle-veritabani-clone-islemi","tag-oracle-veritabani-klon-islemi","tag-oracle-veritabani-klonlama-islemi"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/5017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5017"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/5017\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}