pooh

CentOS 7에서 진행 1. https://yum.postgresql.org/repopackages.php 에서 링크주소 복사 2. CentOS 7에 repo 설치 [root@test-0 ~]# yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm Loaded plugins: fastestmirror epel-release-latest-7.noarch.rpm | 15 kB 00:00 Examining /var/tmp/yum-root-o2xa_B/epel-release-latest-7.noarch.rpm: epel-release-7-11.noarch Marking /var/tmp/yum-root-o2xa_B/e..

${ALTIBASE_HOME}/conf/license 파일 교체

jdbc 를 이용하여 연결한다. 1. [http://support.altibase.com/kr/product]에서 [altijdbc6.5.1.4.2.zip]파일을 다운로드한다. 2. DBeaver의 [Database - Driver Manager]를 클릭 3. Driver Manager 창에서 New를 클릭 4. Driver Manager 창의 Library 탭의 [Add File] 버튼을 클릭하여 altibase.jar 파일을 추가 5. Driver Manager 창의 Setting 목록에 다음 입력 - Driver Name: Altibase - Class Name: Altibase.jdbc.driver.AltibaseDriver - URL Template: jdbc:Altibase://{host}[:..

여기에서 가져옴 -------------------------------------------------------------------------------------- lsThis article presents how to install Oracle 12C(12.2) Release 2 on Oracle Enterprise Linux 7 (OEL7) in silent mode.Read following article how to install Oracle Enterprise Linux 7: Install Oracle Linux 7 (OEL7) (for comfort set 4G memory for your virtual machine before proceeding with Oracle software..

여기에서 펌 -------------------------------------------------------------------------------------- This article presents how to install Oracle 12C Release 1 in silent mode.Silent mode installation allows to configure necessary Oracle components without using graphical interface nor any interaction with end user. It’s very useful method especially when you want to prepare standard installation using s..

-- Creates the login AbolrousHazem with password '340$Uuxwp7Mcxo7Khy'. CREATE LOGIN AbolrousHazem WITH PASSWORD = '340$Uuxwp7Mcxo7Khy'; GO -- Creates a database user for the login created above. CREATE USER AbolrousHazem FOR LOGIN AbolrousHazem; GO -- 테이블 생성 권한grant create table to forum_user; -- 스키마에 권한 부여(?)grant control on schema::dbo to forum_user; 참고

service 등록 [root@oracle11g ~]# /etc/rc.d/init.d/oradb #!/bin/sh## chkconfig: 345 99 99# description: oracle Database# processname: $ORA_HOME/bin/dbstart# config:# pidfile:## source function library. /etc/rc.d/init.d/functions# pull in sysconfig settings RETVAL=0 prog="Oracle Database" lock_file="oradb" ORA_OWNER="oracle" ORA_HOME=`su - $ORA_OWNER -c env | grep ORACLE_HOME | awk -F'=' '{print $2}..

여기에서 가져옴 OS configuration and preparationOS configuration is executed as root. To login as root just execute following command in terminal.su - rootAdd groups--groups for database management --groups id are the same as for 12C installations --some groups are not required here but can be used --later for grid binaries installation groupadd oinstall groupadd dba groupadd operAdd user Oracle--get d..

- tablespace 확인 select tablespace_name, bytes, file_name from dba_data_files; - tablespace 생성 create tablespace [new table name] datafile '[tablespace name].dbf' size 500M - user 생성create user [user name]identified by [password]default tablespace [new tablespace name]quota unlimited on [new tablespace name];* 12c에서 ORA-65096: invalid common user or role name 발생 시 user name 앞에 "c##" 을 붙인다. 또는 "al..

I needed to edit /usr/lib/systemd/system/mysqld.service and addLimitNOFILE=infinity LimitMEMLOCK=infinityThen run systemctl daemon-reload and systemctl restart mysql.service.Now the variable is capped at 65536 for some reason unknown, but I can live with that for now.Found this at http://unix.stackexchange.com/questions/152186/mysql-max-open-files-more-than-1024#answer-157910 출처: http://dba.stac..