Database 2013. 8. 31. 00:55

mm@ubuntu:~$ netstat -n
Active Internet connections (w/o servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State     
tcp        0      0 192.168.255.136:22222   192.168.255.1:58261     ESTABLISHED
tcp        0      0 127.0.0.1:5432          127.0.0.1:57425         ESTABLISHED
tcp        0      0 127.0.0.1:57425         127.0.0.1:5432          ESTABLISHED
tcp        0      0 192.168.255.136:22222   192.168.255.1:58037     ESTABLISHED
udp        0      0 127.0.0.1:56725         127.0.0.1:56725         ESTABLISHED


내부아이피에서만 접근하도록 되어 있는 것을 바꿔보자.

맥북에서 VM에 ubuntu 올리고 사용중이라 외부에서 접속가능하도록 하는게 편하다.


mm@ubuntu:~$ sudo vi /etc/postgresql/9.2/main/postgresql.conf


listen_addresses : '*'


mm@ubuntu:~$ sudo su postgres
postgres@ubuntu:/home/mm$ service postgresql restart
 * Restarting PostgreSQL 9.2 database server                                                               [ OK ]
postgres@ubuntu:/home/mm$



점검해 볼까?


postgres@ubuntu:/home/jinik$ netstat -na
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State     
tcp        0      0 0.0.0.0:27017           0.0.0.0:*               LISTEN    
tcp        0      0 0.0.0.0:22222           0.0.0.0:*               LISTEN    
tcp        0      0 0.0.0.0:28017           0.0.0.0:*               LISTEN    
tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN   




잘된다 :)

OS 레벨에서 뭔가 잠겨 있다면 (방화벽, 아이피 테이블) 그 부분도 풀어주셔야 겠죠

posted by kok
:
Database/Mongo 2012. 7. 27. 19:44

#!/bin/sh

#start


./bin/mongod --rest --port 10505 --fork --logpath ./logs/mongodb.log --dbpath ./data/db/




#!/bin/sh

#stop


if [ -z "`ps -eaf | grep mongod | grep /bin/mongod`" ]; then

       echo "Mongo DB was not started."

else

       ps -eaf | grep /bin/mongod | grep port | awk '{print $2}' |

       while read PID

               do

               echo "Killing $PID ..."

               kill $PID

               echo

               echo "Mongo DB is being shutdowned."

               done

fi


posted by kok
:
Database/Oracle 2012. 3. 19. 17:21

-- Create Data File
CREATE TABLESPACE oracle_DATA
    DATAFILE '/app/oracle/oradata/oracle_data.dbf' size 2000M AUTOEXTEND ON NEXT 500M
    EXTENT MANAGEMENT LOCAL                                                                            
        SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE oracle_IDX
    DATAFILE '/app/oracle/oradata/oracle_idx.dbf' size 1500M AUTOEXTEND ON NEXT 200M
    EXTENT MANAGEMENT LOCAL                                                                            
    SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE oracle_LOB
    DATAFILE '/app/oracle/oradata/oracle_lob.dbf' size 2000M AUTOEXTEND ON NEXT 500M
    EXTENT MANAGEMENT LOCAL                                                                            
    SEGMENT SPACE MANAGEMENT AUTO;

-- Create User
CREATE USER project identified BY projectION
DEFAULT tablespace oracle_DATA
TEMPORARY tablespace TEMP
profile DEFAULT QUOTA unlimited On oracle_DATA;

alter user project quota unlimited on oracle_LOB;
alter user project quota unlimited on oracle_IDX;

GRANT CONNECT TO project;
GRANT resource TO project;
GRANT DBA TO project;
GRANT Unlimited tablespace TO project;
GRANT CREATE ANY INDEX, CREATE DATABASE LINK, CREATE PUBLIC DATABASE LINK, GLOBAL QUERY REWRITE, QUERY REWRITE TO project;

commit;

'Database > Oracle' 카테고리의 다른 글

impdp/expdp , imp/exp  (0) 2012.03.19
승인룰 아이디로 사용중인 카테고리 찾기  (0) 2012.03.19
posted by kok
:
Database/Oracle 2012. 3. 19. 17:17

impdp ics6/asdf DUMPFILE=ics6.dmpdp SCHEMAS=ics6

expdp ics6/asdf DUMPFILE=ics6.dmpdp SCHEMAS=ics6

 

imp ics6/asdf file='ics6.dmp' fromuser=ics6 touser=ics6

exp ics6/asdf file='ics6.dmp' STATISTICS=NONE

 

간단한 건데 왜 매일 까먹을까?

'Database > Oracle' 카테고리의 다른 글

Oracle 테이블 스페이스 생성  (0) 2012.03.19
승인룰 아이디로 사용중인 카테고리 찾기  (0) 2012.03.19
posted by kok
:
Database/Oracle 2012. 3. 19. 17:04

SELECT t1.apprid,
  t1.ruletypecd,
  t2.catid
FROM user_approval_tblc t1,
  user_authority_tblc t2
WHERE t1.apprid   = 942
AND t1.userauthid = t2.userauthid ;

for V5, find category by Approval rule ID

'Database > Oracle' 카테고리의 다른 글

Oracle 테이블 스페이스 생성  (0) 2012.03.19
impdp/expdp , imp/exp  (0) 2012.03.19
posted by kok
: