{"id":674,"date":"2013-03-13T16:38:59","date_gmt":"2013-03-13T14:38:59","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=674"},"modified":"2013-07-26T02:21:12","modified_gmt":"2013-07-25T23:21:12","slug":"linux-isletim-sistemlerinde-rlwrap-ile-sqlplus-ve-rmande-komut-gecmisi-kullanma","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=674","title":{"rendered":"Linux \u0130\u015fletim Sistemlerinde rlwrap ile Oracle Sqlplus ve Rman\u2019de Komut Ge\u00e7mi\u015fi Kullanma"},"content":{"rendered":"

\"LinuxAll\"<\/a><\/span><\/p>\n

Bu makalemizde Linux i\u015fletim sistemlerinde “Sqlplus” ve “Rman” ara\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda Linux “bash” \u00f6zelli\u011findeki gibi yukar\u0131 a\u015fa\u011f\u0131 tu\u015flar\u0131 ile ge\u00e7mi\u015f komutlar\u0131 g\u00f6rmeyi geri tu\u015fu ile silme \u00f6zelli\u011fini kullanmay\u0131 ayarlayaca\u011f\u0131z.<\/span><\/p>\n

1. \u00d6ncelikle “rlwrap”<\/a> yaz\u0131l\u0131m\u0131n\u0131n sitesinden yaz\u0131l\u0131m\u0131 indiriyoruz.<\/span><\/p>\n

2. \u0130ndirmi\u015f oldu\u011fumuz “rlwrap” yaz\u0131l\u0131m\u0131n\u0131 sunucumuzda “oracle” kullan\u0131c\u0131s\u0131n\u0131n yetkisinin oldu\u011fu bir dizine ftp vb. y\u00f6ntemle kopyal\u0131yoruz. Ben sunucumda oracle kurulumlar\u0131 i\u00e7in daha \u00f6nce yaratt\u0131\u011f\u0131m “\/u01\/orainstall\/rlwrap” dizinine kopyalad\u0131m.<\/span><\/p>\n

3. Kopyalam\u0131\u015f oldu\u011fumuz “rlwrap-0.37.tar.gz” s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyas\u0131n\u0131 a\u00e7\u0131yoruz.<\/span><\/p>\n

-- Dosyam\u0131z\u0131 kopyalad\u0131\u011f\u0131m\u0131z dizine ge\u00e7iyoruz.\r\n\r\n$ cd \/u01\/orainstall\/rlwrap\r\n\r\n-- Gunzip program\u0131 ile s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyay\u0131 tar dosyas\u0131na\r\nd\u00f6n\u00fc\u015ft\u00fcr\u00fcyoruz.\r\n\r\n$ gunzip rlwrap-0.37.tar.gz\r\n\r\ntar program\u0131 ile s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyay\u0131 a\u00e7\u0131yoruz.\r\n\r\n$ tar -xvf rlwrap-0.37.tar\r\nrlwrap-0.37\/\r\nrlwrap-0.37\/completions\/\r\nrlwrap-0.37\/completions\/testclient\r\nrlwrap-0.37\/completions\/coqtop\r\nrlwrap-0.37\/doc\/\r\nrlwrap-0.37\/doc\/rlwrap.man.in\r\nrlwrap-0.37\/doc\/Makefile.am\r\nrlwrap-0.37\/doc\/Makefile.in\r\nrlwrap-0.37\/filters\/\r\nrlwrap-0.37\/filters\/README\r\nrlwrap-0.37\/filters\/RlwrapFilter.pm\r\nrlwrap-0.37\/filters\/RlwrapFilter.3pm\r\nrlwrap-0.37\/filters\/count_in_prompt\r\nrlwrap-0.37\/filters\/pipeto\r\nrlwrap-0.37\/filters\/logger\r\nrlwrap-0.37\/filters\/null\r\nrlwrap-0.37\/filters\/unbackspace\r\nrlwrap-0.37\/filters\/pipeline\r\nrlwrap-0.37\/filters\/ftp_filter\r\nrlwrap-0.37\/filters\/history_format\r\nrlwrap-0.37\/filters\/simple_macro\r\nrlwrap-0.37\/filters\/template\r\nrlwrap-0.37\/filters\/scrub_prompt\r\nrlwrap-0.37\/filters\/paint_prompt\r\nrlwrap-0.37\/filters\/censor_passwords\r\nrlwrap-0.37\/filters\/listing\r\nrlwrap-0.37\/filters\/Makefile.am\r\nrlwrap-0.37\/filters\/Makefile.in\r\nrlwrap-0.37\/src\/\r\nrlwrap-0.37\/src\/rlwrap.h\r\nrlwrap-0.37\/src\/redblack.h\r\nrlwrap-0.37\/src\/malloc_debug.h\r\nrlwrap-0.37\/src\/completion.rb\r\nrlwrap-0.37\/src\/Makefile.am\r\nrlwrap-0.37\/src\/Makefile.in\r\nrlwrap-0.37\/src\/main.c\r\nrlwrap-0.37\/src\/signals.c\r\nrlwrap-0.37\/src\/readline.c\r\nrlwrap-0.37\/src\/pty.c\r\nrlwrap-0.37\/src\/completion.c\r\nrlwrap-0.37\/src\/term.c\r\nrlwrap-0.37\/src\/ptytty.c\r\nrlwrap-0.37\/src\/utils.c\r\nrlwrap-0.37\/src\/string_utils.c\r\nrlwrap-0.37\/src\/malloc_debug.c\r\nrlwrap-0.37\/src\/filter.c\r\nrlwrap-0.37\/test\/\r\nrlwrap-0.37\/test\/testclient\r\nrlwrap-0.37\/test\/testit\r\nrlwrap-0.37\/tools\/\r\nrlwrap-0.37\/tools\/config.guess\r\nrlwrap-0.37\/tools\/config.sub\r\nrlwrap-0.37\/tools\/depcomp\r\nrlwrap-0.37\/tools\/install-sh\r\nrlwrap-0.37\/tools\/missing\r\nrlwrap-0.37\/README\r\nrlwrap-0.37\/configure.ac\r\nrlwrap-0.37\/aclocal.m4\r\nrlwrap-0.37\/Makefile.am\r\nrlwrap-0.37\/Makefile.in\r\nrlwrap-0.37\/config.h.in\r\nrlwrap-0.37\/configure\r\nrlwrap-0.37\/AUTHORS\r\nrlwrap-0.37\/COPYING\r\nrlwrap-0.37\/ChangeLog\r\nrlwrap-0.37\/INSTALL\r\nrlwrap-0.37\/NEWS\r\nrlwrap-0.37\/TODO\r\nrlwrap-0.37\/BUGS\r\nrlwrap-0.37\/PLEA<\/span><\/pre>\n
4. A\u00e7ma i\u015flemi bitti\u011finde a\u00e7\u0131lm\u0131\u015f dosyan\u0131n bulundu\u011fu dizine ge\u00e7ip program\u0131 derliyoruz.<\/span><\/p>\n
-- Bundan sonraki i\u015flemleri \"root\" kullan\u0131c\u0131s\u0131 ile yapaca\u011f\u0131z.\r\n\"root\" kullan\u0131c\u0131s\u0131na ge\u00e7i\u015f yap\u0131yoruz.\r\n\r\n$ su root\r\nPassword: \r\n\r\n-- Ayn\u0131 klas\u00f6r alt\u0131ndaki dosyan\u0131n a\u00e7\u0131ld\u0131\u011f\u0131 dizine ge\u00e7iyoruz.\r\n\r\n# cd \/u01\/orainstall\/rlwrap\/rlwrap-0.37\r\n\r\n-- Ard\u0131ndan program\u0131m\u0131z\u0131 derliyoruz.\r\n\r\n# .\/configure\r\nchecking build system type... x86_64-unknown-linux-gnu\r\nchecking host system type... x86_64-unknown-linux-gnu\r\nchecking for a BSD-compatible install... \/usr\/bin\/install -c\r\nchecking whether build environment is sane... yes\r\nchecking for a thread-safe mkdir -p... \/bin\/mkdir -p\r\nchecking for gawk... gawk\r\nchecking whether make sets $(MAKE)... yes\r\nchecking whether make sets $(MAKE)... (cached) yes\r\nchecking whether build environment is sane... yes\r\nchecking for style of include used by make... GNU\r\nchecking for gcc... gcc\r\nchecking for C compiler default output file name... a.out\r\nchecking whether the C compiler works... yes\r\nchecking whether we are cross compiling... no\r\nchecking for suffix of executables... \r\nchecking for suffix of object files... o\r\nchecking whether we are using the GNU C compiler... yes\r\nchecking whether gcc accepts -g... yes\r\nchecking for gcc option to accept ISO C89... none needed\r\nchecking dependency style of gcc... gcc3\r\nchecking how to run the C preprocessor... gcc -E\r\nchecking for grep that handles long lines and -e... \/bin\/grep\r\nchecking for egrep... \/bin\/grep -E\r\nchecking for ANSI C header files... yes\r\nchecking for sys\/types.h... yes\r\nchecking for sys\/stat.h... yes\r\nchecking for stdlib.h... yes\r\nchecking for string.h... yes\r\nchecking for memory.h... yes\r\nchecking for strings.h... yes\r\nchecking for inttypes.h... yes\r\nchecking for stdint.h... yes\r\nchecking for unistd.h... yes\r\nchecking minix\/config.h usability... no\r\nchecking minix\/config.h presence... no\r\nchecking for minix\/config.h... no\r\nchecking whether it is safe to define __EXTENSIONS__... yes\r\nchecking for gcc... (cached) gcc\r\nchecking whether we are using the GNU C compiler... (cached) yes\r\nchecking whether gcc accepts -g... (cached) yes\r\nchecking for gcc option to accept ISO C89... (cached) none needed\r\nchecking dependency style of gcc... (cached) gcc3\r\nchecking how to run the C preprocessor... gcc -E\r\nchecking for perl... \/usr\/bin\/perl\r\nchecking for strip... strip\r\nchecking for ANSI C header files... (cached) yes\r\nchecking for sys\/wait.h that is POSIX.1 compatible... yes\r\nchecking errno.h usability... yes\r\nchecking errno.h presence... yes\r\nchecking for errno.h... yes\r\nchecking fcntl.h usability... yes\r\nchecking fcntl.h presence... yes\r\nchecking for fcntl.h... yes\r\nchecking libutil.h usability... no\r\nchecking libutil.h presence... no\r\nchecking for libutil.h... no\r\nchecking for stdlib.h... (cached) yes\r\nchecking for string.h... (cached) yes\r\nchecking sched.h usability... yes\r\nchecking sched.h presence... yes\r\nchecking for sched.h... yes\r\nchecking sys\/ioctl.h usability... yes\r\nchecking sys\/ioctl.h presence... yes\r\nchecking for sys\/ioctl.h... yes\r\nchecking for sys\/wait.h... (cached) yes\r\nchecking sys\/resource.h usability... yes\r\nchecking sys\/resource.h presence... yes\r\nchecking for sys\/resource.h... yes\r\nchecking stddef.h usability... yes\r\nchecking stddef.h presence... yes\r\nchecking for stddef.h... yes\r\nchecking termios.h usability... yes\r\nchecking termios.h presence... yes\r\nchecking for termios.h... yes\r\nchecking for unistd.h... (cached) yes\r\nchecking for stdint.h... (cached) yes\r\nchecking time.h usability... yes\r\nchecking time.h presence... yes\r\nchecking for time.h... yes\r\nchecking getopt.h usability... yes\r\nchecking getopt.h presence... yes\r\nchecking for getopt.h... yes\r\nchecking regex.h usability... yes\r\nchecking regex.h presence... yes\r\nchecking for regex.h... yes\r\nchecking curses.h usability... yes\r\nchecking curses.h presence... yes\r\nchecking for curses.h... yes\r\nchecking termcap.h usability... yes\r\nchecking termcap.h presence... yes\r\nchecking for termcap.h... yes\r\nchecking for term.h... yes\r\nchecking for ncurses\/term.h... yes\r\nchecking argument type of tputs putc function... int\r\nchecking whether your getopt() ... yes\r\nchecking for an ANSI C-conforming const... yes\r\nchecking for pid_t... yes\r\nchecking whether time.h and sys\/time.h ... yes\r\nchecking whether gcc needs -traditional... no\r\nchecking return type of signal handlers... void\r\nchecking for getopt_long... yes\r\nchecking for getopt_long... (cached) yes\r\nchecking for isastream... yes\r\nchecking for mkstemp... yes\r\nchecking for pselect... yes\r\nchecking for putenv... yes\r\nchecking for readlink... yes\r\nchecking for sched_yield... yes\r\nchecking for setenv... yes\r\nchecking for setitimer... yes\r\nchecking for setsid... yes\r\nchecking for setrlimit... yes\r\nchecking for sigaction... yes\r\nchecking for snprintf... yes\r\nchecking for strlcpy... no\r\nchecking for strlcat... no\r\nchecking for strnlen... yes\r\nchecking for system... yes\r\nchecking for openpty in -lutil... yes\r\nchecking for openpty... yes\r\nchecking for getpty... no\r\nchecking for grantpt... yes\r\nchecking for unlockpt... yes\r\nchecking for getpt... yes\r\nchecking for pty\/tty type... checking ... yes\r\nchecking pty.h presence... yes\r\nchecking for pty.h... yes\r\nOPENPTY\r\nconfigure: checking for pty ranges...\r\nchecking for tgetent... no\r\nchecking for tgetent in -lcurses... yes\r\nchecking for readline in -lreadline... yes\r\nchecking whether your readline headers ... yes\r\nchecking whether your readline library ... yes\r\nchecking whether your readline ... yes\r\nchecking whether your readline ... yes\r\nWill rlwrap find command's working directory...\r\nchecking for \/proc\/8342\/cwd\/configure.ac... yes\r\n\r\nconfigure: creating .\/config.status\r\nconfig.status: creating Makefile\r\nconfig.status: creating filters\/Makefile\r\nconfig.status: creating doc\/Makefile\r\nconfig.status: creating src\/Makefile\r\nconfig.status: creating doc\/rlwrap.man\r\nconfig.status: creating config.h\r\nconfig.status: executing depfiles commands\r\n\r\nNow do:\r\n    make (or gmake)  to build rlwrap\r\n    make check       for instructions how to test it\r\n    make install     to install it<\/span><\/pre>\n
5. Derleme i\u015flemimiz bittikten sonra art\u0131k program\u0131m\u0131z\u0131 kurabiliriz. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
-- Make komutlar\u0131 ile program\u0131m\u0131z\u0131 kuruyoruz.\r\n\r\n# make\r\n# make check\r\n# make install\r\n\r\n-- Kurulum i\u015flemimiz tamamlanm\u0131\u015ft\u0131r.\r\n\r\n-- Komutlar\u0131m\u0131z\u0131n anlam\u0131 a\u015fa\u011f\u0131daki gibidir.\r\n\r\nmake (or gmake)  to build rlwrap\r\nmake check       for instructions how to test it\r\nmake install     to install it<\/span><\/pre>\n
6. \u015eimdi “oracle” kullan\u0131c\u0131s\u0131na ge\u00e7erek gerekli ayarlar\u0131m\u0131z\u0131 yap\u0131yoruz. Bu ayarlar ile “sqlplus” veya “rman” ara\u00e7lar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda “rlwrap” bunlar\u0131n yerine ge\u00e7erek bize komut sat\u0131r\u0131 ge\u00e7mi\u015fi tutma \u00f6zelli\u011fi sunacakt\u0131r. Bu komutlar\u0131 “rlsqlplus” ve “rlrman” gibi \u00e7a\u011f\u0131raca\u011f\u0131z.<\/span><\/p>\n
# su - oracle \r\n\r\n-- bash_profile dosyam\u0131za a\u015fa\u011f\u0131daki sat\u0131rlar\u0131 ekliyoruz.\r\n\r\n$ vim .bash_profile\r\n\r\nalias rlsqlplus='rlwrap sqlplus'\r\nalias rlrman='rlwrap rman'<\/span><\/pre>\n
7. De\u011fi\u015fikliklerin hemen ge\u00e7erli olmas\u0131 i\u00e7in “.bash_profile” dosyam\u0131z\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz. Art\u0131k “rlwrap” arac\u0131m\u0131z kullan\u0131ma haz\u0131r. A\u015fa\u011f\u0131daki gibi test etti\u011fimizde yukar\u0131 a\u015fa\u011f\u0131 tu\u015flar\u0131yla komut ge\u00e7mi\u015finin t\u0131pk\u0131 Linux bash’deki gibi geldi\u011fini geri tu\u015fu ile garip karakterler \u00e7\u0131kmadan silme i\u015flemi yapabildi\u011fimizi g\u00f6rece\u011fiz.<\/span><\/p>\n
$ . .bash_profile\r\n$ rlrman target \/\r\n\r\nRecovery Manager:\r\nRelease 11.2.0.3.0 - Production on Wed Mar 13 16:31:51 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle and\/or its affiliates.\r\nAll rights reserved.\r\n\r\nconnected to target database: ORCL (DBID=1337532004)\r\n\r\nRMAN> backup database;\r\n\r\nStarting backup at 13-MAR-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_DISK_1\r\nchannel ORA_DISK_1: SID=28 device type=DISK\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\ninput datafile file number=00001\r\nname=+DATA\/orcl\/datafile\/system.261.809751305\r\ninput datafile file number=00002\r\nname=+DATA\/orcl\/datafile\/sysaux.262.809751323\r\ninput datafile file number=00003\r\nname=+DATA\/orcl\/datafile\/undotbs1.263.809751341\r\ninput datafile file number=00004\r\nname=+DATA\/orcl\/datafile\/users.265.809751371\r\nchannel ORA_DISK_1: starting piece 1 at 13-MAR-13\r\nchannel ORA_DISK_1: finished piece 1 at 13-MAR-13\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:45\r\nchannel ORA_DISK_1: starting full datafile backup set\r\nchannel ORA_DISK_1: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nincluding current SPFILE in backup set\r\nchannel ORA_DISK_1: starting piece 1 at 13-MAR-13\r\nchannel ORA_DISK_1: finished piece 1 at 13-MAR-13\r\nchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01\r\nFinished backup at 13-MAR-13\r\n\r\nRMAN> backup database;\r\n\r\nRMAN> exit\r\n\r\nRecovery Manager complete.\r\n[oracle@koraykey-db ~]$ rlsqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Wed Mar 13 16:34:45 2013\r\n\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition\r\nRelease 11.2.0.3.0 - 64bit Production\r\nWith the Partitioning, Automatic Storage Management,\r\nOLAP, Data Mining and Real Application Testing options\r\n\r\nSQL> select status from v$instance;\r\n\r\nSTATUS\r\n------------\r\nOPEN\r\n\r\nSQL> select status from v$instance;<\/span><\/pre>\n
Bu makalemizdeki ad\u0131mlar Oracle Enterprise Linux 6.4 \u00fczerinde test edilmi\u015ftir. Daha \u00f6nceki tecr\u00fcbelerimden di\u011fer Linux i\u015fletim sitemleri ile HP-UX 11.31 v3 March 2012 i\u015fletim sistemlerinde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rd\u00fcm.<\/span><\/p>\n
Ba\u015fka bir makalede g\u00f6r\u00fc\u015fmek \u00fczere…\u00a0\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Bu makalemizde Linux i\u015fletim sistemlerinde “Sqlplus” ve “Rman” ara\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda Linux “bash” \u00f6zelli\u011findeki gibi yukar\u0131 a\u015fa\u011f\u0131 tu\u015flar\u0131 ile ge\u00e7mi\u015f komutlar\u0131 g\u00f6rmeyi geri tu\u015fu ile silme \u00f6zelli\u011fini kullanmay\u0131 ayarlayaca\u011f\u0131z. 1. \u00d6ncelikle “rlwrap” yaz\u0131l\u0131m\u0131n\u0131n sitesinden yaz\u0131l\u0131m\u0131 indiriyoruz. 2. \u0130ndirmi\u015f oldu\u011fumuz “rlwrap” yaz\u0131l\u0131m\u0131n\u0131 … Okumaya devam et →<\/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,8],"tags":[21,290,20,19,52,51,49,50,364,363,362,361],"class_list":["post-674","post","type-post","status-publish","format-standard","hentry","category-oracle","category-unix-linux","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-rlrman","tag-rlsqlplus","tag-rlwrap","tag-rlwrap-kurulumu","tag-rman-bash","tag-rman-komut-gecmisi","tag-sqlplus-bash","tag-sqlplus-komut-gecmisi"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/674","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=674"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/674\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}