http://iotn.co.kr 연락처: gilho.kr@gmail.com [ The Japanese government should apologize to Japanese Military Sexual Slavery victim. / 日本政府は日本軍の性的奴隷?牲者に謝罪すべき. ]

사용자

ID:
PW:

INDEX
01.게시판
게시판 [71]
02.File Book
File 자료실 [95]
Site Link [17]
개인폴더 [201]
03.Field Book
Altibase [19]
Tibero [30]
MS-SQL [25]
MySQL [43]
DB2 [79]
ORACLE [3003]
PSQL [134]
기타정보 [155]
운영체제 [603]
04.Q/A Book
Q/A [53]
05.방명록
방명록 [54]
레벨업 [37]
구인/구직 [2]

기념일
Search
LINK
+ 가족 Hompy
+ DNSEver
IOTN :: Field Book :: PostgreSQL

 회원가입

oracle to psql dblink
최길호 [LIST]   2021-11-09 13:57:50, 조회 : 235

# ORACLE
export NLS_LANG=.AL32UTF8
export LANG=en_US.UTF-8
# sw encoding UTF-8

sqlplus user_000/user_000@db18
select * from user_000.zipcode where rownum < 10;

https://www.oracle.com/kr/database/technologies/releasenote-odbc-ic.html
ODBC driver shared library file:
For 19c: $ORACLE_HOME/lib/libsqora.so.19.1
For 18c: $ORACLE_HOME/lib/libsqora.so.18.1
For 12c: $ORACLE_HOME/lib/libsqora.so.12.1
For 11g: $ORACLE_HOME/lib/libsqora.so.11.1

# login test
sqlplus system/oracle@localhost:1521/db18

cat >> /etc/odbcinst.ini
#
[Oracle]
Description = Oracle ODBC driver for Oracle
Driver = /oracle/product/18/lib/libsqora.so.18.1

cat >> /etc/odbc.ini
#
[Oracle]
Driver = /oracle/product/18/lib/libsqora.so.18.1
ServerName = //localhost:1521/db18
UserID = user_000
Password = user_000

## 연결 , 한글 확인
export NLS_LANG=.AL32UTF8
isql -v oracle user_000 user_000
select '한글' from dual;
+-------------+
| **ERROR**   |
+-------------+
select * from user_000.zipcode where rownum < 10;
잘보임.

## oracle 다른 계정 사용시 에러
isql -v oracle user_000 user_000
[01000][unixODBC][Driver Manager]Can't open lib '/oracle/product/18/lib/libsqora.so.18.1' : file not found
[ISQL]ERROR: Could not SQLConnect
ldd /oracle/product/18/lib/libsqora.so.18.1 | grep not
        libclntsh.so.18.1 => not found
        libclntshcore.so.18.1 => not found
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/oracle/product/18/lib
## core dump 발생
isql -v oracle user_000 user_000
Segmentation fault (core dumped)

## 조치
. oraenv
ORACLE_SID = [root] ? db18
[root ~]# isql -v oracle user_000 user_000
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>

진행중....
3.235.60.197


  LIST

제목 작성자 작성일 조회
Admin  psql 10.7 oracle dblink [ oracle_fdw db link ]    최길호 2023/07/25 20
Admin  HA 복구 test    최길호 2023/03/03 31
Admin  log: COPY public.xxxx (xxx, xxx, xxx) TO stdout; / pg_dump 백업시 발생    최길호 2023/03/03 14
Admin  requested timeline x is not a child of this server's history    최길호 2023/03/02 16
Admin  recovery_target_action / archive log 받아서 계속 복구    최길호 2023/02/28 25
Admin  recovery_target_action = 'pause' / select pg_wal_replay_pause(); / select pg_get_wal_replay_pause_state();    최길호 2023/02/27 6
Admin  memory buffer cache    최길호 2023/02/06 14
Admin  active session, pid, lock sql , kill pid / pg_terminate_backend    최길호 2023/02/06 60
Admin  psql HA    최길호 2023/02/05 46
Admin  pg_ctl start -D . | postmaster.pid | /tmp/.s.PGSQL.5432 |    최길호 2023/02/03 31
Admin  pg_waldump    최길호 2023/02/03 9
Troubleshoot  $PGDATA/pg_wal/00000002.history 없는경우 [ ERROR: could not open file "pg_wal/00000002.history": ENOENT ]    최길호 2023/02/02 24
Admin  pg_basebackup 복구 test lv:9   최길호 2023/02/02 23
Admin  shmem_exit(0): 0 before_shmem_exit callbacks to make [ 로그 기록용 ]    최길호 2023/02/01 46
Troubleshoot  LOG: invalid resource manager ID in primary checkpoint record    최길호 2023/02/01 24
Admin  pg_restore [ 다른 계정, 다른 DB, sql 파일로 저장 ]    최길호 2023/01/30 16
Admin  pg_basebackup pg_dump pg_dumpall backup script    최길호 2023/01/30 79
Admin  session 정보    최길호 2023/01/27 21

    목록보기   다음페이지 1 [2][3][4][5][6][7]
       

Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
최근 댓글
최근 게시물
12/01
[ORACLE]
dgmgrl 운영, db11st h/w 교체 시나리....
by 최길호
12/01
[ORACLE]
DGMGRL> show configuration;....
by 최길호
11/23
[운영체제]
arch filesystem 100% full 예방 /....
by 최길호