Dev/oracle
-
SQLPLUS hangs in linuxDev/oracle 2011. 10. 6. 11:51
리눅스에서 sqlplus 를 이용하여 오라클 10g 서버 접속 시 hang 발생. * 환경 OS : CentOS v5.x Oracle Client : SQL*Plus: Release 10.2.0.1.0 [oracle@test ~]$ uptime 11:42:55 up 413 days, 2:40, 1 user, load average: 0.02, 0.02, 0.00 * 조치사항 : 재부팅 [oracle@test ~]$ reboot * 결과 : 정상 접속 가능 참고사이트 : http://oradbastuff.blogspot.com/2010/02/sqlplus-hangs-in-linux.html
-
oracle datapump 를 이용한 exp 와 impDev/oracle 2011. 9. 19. 14:59
* 환경설정 # mkdir /data/datapump # chown -R oracle.oinstall /data # su - oracle $ sqlplus / as sysdba SQL> create or replace directory datapump as '/data/datapump'; SQL> grant read,write on directory datapump to scott; SQL> grant create any directory to scott; SQL> exit $ expdp scott/tiger schemas=scott directory=datapump dumpfile=scott_backup.dmp logfile=scott_exp.log $ impdp scott/tiger directory..
-
Oracle 10g 설치 [CentOS]Dev/oracle 2011. 9. 8. 19:15
* Oracle 10g 다운로드 - http://www.oracle.com/technology/software/products/database/index.html 접속 - Oracle Database 10g Release2(10.2.0.1.0) For Linux x86 다운로드 - 다운로드 후 /oracle10g 디렉토리에 압축 해제 # mkdir /oracle10g # mv 10201_database_linux32.zip /oracle10g/10201_database_linux32.zip # unzip 10201_database_linux32.zip * Oracle 10g 설치 환경 구성 - /etc/redhat-release 수정 # vim /etc/redhat-release CentOS releas..
-
SSH 를 이용한 오라클 원격 설치 환경 준비Dev/oracle 2011. 9. 8. 15:27
* 내 리눅스 PC 에서 준비할 일 # xhost + 서버IP # vim /etc/ssh/ssh_config Host * ForwardX11 yes * 오라클 설치할 PC # export LANG=c * 내 리눅스 PC 에서 서버로 접속 # ssh oracle@서버IP # echo $DISPLAY localhost:10.0 # xclock 시계가 표시되는지 확인 # ./runInstaller 오라클 설치 출처 : http://cafe.naver.com/ocmkorea/4372
-
-
Oracle 10g DBMS_SCHEDULERDev/oracle 2011. 8. 31. 11:37
Programs The scheduler allows you to optionally create programs which hold metadata about a task, but no schedule information. A program may related to a PL/SQL block, a stored procedure or an OS executable file. Programs are created using the CREATE_PROGRAM procedure. -- Create the test programs. BEGIN -- PL/SQL Block. DBMS_SCHEDULER.create_program ( program_name => 'test_plsql_block_prog', pro..