[PROBLEM]
Cannot grab required information(TMOUT) from /etc/profile
[FIXED]
Edit file /etc/profile, add following line to end of file.
vi /etc/profile
# set a 5 min timeout policy for bash shell TMOUT=300 readonly TMOUT export TMOUT |
Thursday, May 19, 2016
Wednesday, May 18, 2016
How to set an expiration date for user' password on Linux
Step 1: Open file /etc/login.defs, change option for PASS_MAX_DAYS, For example:
# Password aging controls:
#
# PASS_MAX_DAYS Maximum number of days a password may be used.
# PASS_MIN_DAYS Minimum number of days allowed between password changes.
# PASS_MIN_LEN Minimum acceptable password length.
# PASS_WARN_AGE Number of days warning given before a password expires.
#
PASS_MAX_DAYS 90
Step 2: With exist user, you can change expiration date via command:
# Password aging controls:
#
# PASS_MAX_DAYS Maximum number of days a password may be used.
# PASS_MIN_DAYS Minimum number of days allowed between password changes.
# PASS_MIN_LEN Minimum acceptable password length.
# PASS_WARN_AGE Number of days warning given before a password expires.
#
PASS_MAX_DAYS 90
Step 2: With exist user, you can change expiration date via command:
[root@VTGDB.COM ~]# chage -M 90 username
Monday, May 9, 2016
Installation Mysql, php, apache
My environment:
OS
|
Red Hat Enterprise
Linux Server release 6.5 (Santiago)
|
MySQL
|
Version 5.1.73-community
MySQL Community Server (GPL)
|
PHP
|
PHP 5.6.10 (cli)
|
Htdoc Directory
|
/u01/qlts/public_html
|
Apache Configuration
Directory
|
/etc/httpd/conf
|
MySQL installation
Detail you
can read it:
Step 1: Download MySQL
You access
the internet via address:
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/
to download file.
Step 2: Extracting downloaded file to your installing
directory:
[root@VTGDB.COM
mysql]# tar -xvpf MySQL-community-5.1.73-1.rhel5.x86_64.rpm-bundle.tar
|
Step 3: Install MySQL client-server:
[root@VTGDB.COM
mysql]# rpm -ivh MySQL-server-community-5.1.73-1.rhel5.x86_64.rpm
MySQL-client-community-5.1.73-1.rhel5.x86_64.rpm
|
Step 4: Install the “Header and Libraries” that are
part of the MySQL-devel packages.
[root@VTGDB.COM mysql]# rpm
-ivh MySQL-devel-community-5.1.73-1.rhel5.x86_64.rpm
|
Step 5: Change password for root
[root@VTGDB.COM
mysql]# /usr/bin/mysqladmin -u root password '***********'
|
Step 6: Edit the MySQL Server configuration file:
[root@VTGDB.COM
etc]# vi /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
port=3306
user=mysql
#UTF 8 Setting
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
# Disabling
symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/u01/mysql/log/mysqld.log
pid-file=/u01/mysql/mysqld/mysqld.pid
[client]
port=3306
|
Step 7: Restart MySQL Server
[root@VTGDB.COM
etc]# service mysql restart
Shutting down MySQL... [ OK ]
Starting MySQL. [ OK ]
|
Step 8: Login your new MySQL Server
[root@VTGDB.COM ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL
monitor. Commands end with ; or \g.
Your MySQL
connection id is 604
Server version:
5.1.73-community MySQL Community Server (GPL)
Copyright (c) 2000,
2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a
registered trademark of Oracle Corporation and/or its
affiliates. Other
names may be trademarks of their respective
owners.
Type 'help;' or '\h'
for help. Type '\c' to clear the current input statement.
mysql>
|
Php Installation
Step 1: Download Php
You access
the internet via address:
http://php.net/get/php-5.6.21.tar.gz/from/a/mirror
to download file.
Step 2: Extract downloaded file to your installing
directory:
[root@VTGDB.COM
setup]# tar -xzvf php-5.6.10.tar.gz
|
Step 3: Run installation file
[root@VTGDB.COM setup]#
cd php-5.6.10
[root@VTGDB.COM
php-5.6.10]# ./configure --with-apxs2=/usr/sbin/apxs \
--with-mysql
--with-pdo-mysql
[root@VTGDB.COM
php-5.6.10]#make
[root@VTGDB.COM
php-5.6.10]#make install
|
Step 4: Find and Edit php configuration file
[root@VTGDB.COM
php-5.6.10]# cp php.ini-development
/usr/local/lib/php.ini
[root@VTGDB.COM php-5.6.10]# vi /usr/local/lib/php.ini
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone =
Asia/Ho_Chi_Minh
|
Step 5: Prepare application directory
[root@VTGDB.COM
php-5.6.10]# chsh -s /bin/bash apache
[root@VTGDB.COM
php-5.6.10]# mkdir -p
/u01/qlts/public_html
[root@VTGDB.COM
php-5.6.10]# chown –R apache:apache
/u01/qlts/public_html
|
Step 6: Find and Edit httpd configuration file:
[root@VTGDB.COM php-5.6.10]#
vi /etc/httpd/conf/httpd.conf
…
Listen 8080
…
User apache
Group apache
…
#
Options FollowSymLinks
#
Allow from all
#
AllowOverride None
Options FollowSymLinks
AllowOverride All
…
#AddType application/x-tar .tgz
AddType application/x-httpd-php .php
AddType application/x-httpd-php .html
…
ServerAdmin thonh53@gmail.com
DocumentRoot /u01/qlts/public_html
ServerName VTGDB.COM
ServerAlias VTGDB
ErrorLog /u01/qlts/log/error.log
# CustomLog logs/dummy-host.example.com-access_log common
|
Step 7: Restart Apache server
[root@VTGDB.COM
php-5.6.10]# service httpd restart
|
Step 8: Test php
[root@VTGDB.COM
php-5.6.10]# su – apache
[apache@VTGDB.COM ~]#
cd /u01/qlts/public_html
[apache@VTGDB.COM
public_html]# vi info.php
<?php
phpinfo();
?>
|
Open your
browser access address: http://YOUR_IP_SERVER:8080/info.php
Friday, April 8, 2016
How to fix Error Vietnamese font on Xampp
[Describe]:
[FIXED]
Step 1: Open Xampp Control Panel, Click Config on MySQL Module
Step 2: Open my.ini
Step 3: Uncomment rows following and save file my.ini
collation_server=utf8_unicode_ci
character_set_server=utf8
skip-character-set-client-handshake
character_sets-dir="C:/xampp/mysql/share/charsets"
Step 4: Restart MySQL Server on XAMPP Control Panel
Step 5: Reload the page
Monday, March 14, 2016
Install or upgrade Oracle APEX 5.0.3 for ORACLE DATABASE 12C on Linux
Step 1: Create tablespace
create tablespace apex
datafile '/u01/app/oracle/oradata/PTUD/datafile/apex.dbf' size 100M
autoextend on next 10M;
|
Step 2: Download Oracle Apex 5.0.3.00.03 from Oracle or My Google Drive
or
Step 3: extract file apex_5.0.3_en.zip to directory: /u01/setup
[oracle@VTGDB.COM ~]$cd
/u01/setup
[oracle@VTGDB.COM setup]$unzip apex_5.0.3_en.zip
[oracle@VTGDB.COM setup]$ ls
apex
apex_5.0.3_en.zip
Step 4: Go to the apex directory ( /u01/setup/apex), connect sys as sysdba then run sql scripts:
[oracle@VTGDB.COM
~]$cd /u01/setup/apex
SQL > @apexins.sql apex apex temp /i/
|
Step 5: Run script apex_epg_config.sql /u01/setup
[oracle@VTGDB.COM ~]$cd
/u01/setup/apex
[oracle@VTGDB.COM apex]$sqlplus
/ as sysdba
SQL > @apex_epg_config.sql
/u01/setup
|
Step 6: Unlock user account oracle
[oracle@VTGDB.COM apex]$sqlplus
/ as sysdba
SQL > alter user APEX_PUBLIC_USER
account unlock;
SQL > alter user
APEX_050000 account unlock;
SQL > alter user ANONYMOUS
account unlock;
|
Step 7: Verifying Oracle XML DB HTTP Port and set it to 8080
[oracle@VTGDB.COM apex]$sqlplus
/ as sysdba
SQL> SELECT
DBMS_XDB.gethttpport FROM DUAL;
GETHTTPPORT
-----------
0
SQL> EXEC DBMS_XDB.sethttpport(8080);
PL/SQL procedure successfully completed.
|
Step 8: Configure Apex application
[oracle@VTGDB.COM apex]$ sqlplus / as sysdba
SQL> @apxconf.sql
PORT
----------
8080
Enter values below for the XDB HTTP listener port and the password
for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
================================================================================
This script can be used to change the password of an Application
Express
instance administrator. If the user does not yet exist, a user record
will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [ADMIN]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port
SQL>
|
Step 9: Access your Apex application web:
http://YOUR_HOST:8080/apex
workspace: internal
username: ADMIN ( uppercase)
pass: YOUR_PASS
After you login successfully, you have your interface following:
Monday, March 7, 2016
How to create schemas for BI Publisher 11G without RCU
Contents
Prerequisite
Grant exempt access policy to user system
in order to fix ORA 39181. ( VERY IMPORTANT!).
[oracle@PTUD-SingleSignOn dpdump]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on
Mon Dec 7 15:07:35 2015
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition
Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced
Analytics and Real Application Testing options
SQL> GRANT EXEMPT ACCESS POLICY to System;
Grant succeeded.
SQL> commit;
Commit complete.
Download file dump from my google drive:
List of tablespaces
Create all of tablespaces following:
|
Name
|
SQL
Create
|
|
RMS11G_BIPLATFORM
|
CREATE TABLESPACE "RMS11G_BIPLATFORM" EXTENT
MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
DATAFILE '/u01/app/oracle/oradata/RMS11G_biplatform.dbf' SIZE 64M
AUTOEXTEND ON NEXT 16M MAXSIZE 1024M;
|
|
RMS11G_IAS_TEMP
|
CREATE
TEMPORARY TABLESPACE
"RMS11G_IAS_TEMP" EXTENT MANAGEMENT LOCAL TEMPFILE
'/u01/app/oracle/oradata/RMS11G_iastemp.dbf' SIZE 100M;
|
|
RMS11G_IAS_IAU
|
CREATE
TABLESPACE "RMS11G_IAS_IAU" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
DATAFILE '/u01/app/oracle/oradata/RMS11G_ias_iau.dbf' SIZE 60M
REUSE AUTOEXTEND ON NEXT 10240K
MAXSIZE UNLIMITED;
|
|
RMS11G_MDS
|
CREATE
TABLESPACE "RMS11G_MDS" EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO
DATAFILE '/u01/app/oracle/oradata/RMS11G_mds.dbf' SIZE 100M AUTOEXTEND
ON NEXT 50M MAXSIZE 1000M;
|
List of schemas
Create all of schemas following:
|
Name
|
SQL Create
|
|
RMS11G_BIPLATFORM
|
create
user "RMS11G_BIPLATFORM" identified by ******* profile
"DEFAULT" account unlock default tablespace "RMS11G_BIPLATFORM" temporary
tablespace "RMS11G_IAS_TEMP";
grant
CREATE SEQUENCE to "RMS11G_BIPLATFORM";
grant
UNLIMITED TABLESPACE to "RMS11G_BIPLATFORM";
grant
"CONNECT" to "RMS11G_BIPLATFORM";
grant
"RESOURCE" to "RMS11G_BIPLATFORM";
grant
CREATE VIEW to "RMS11G_BIPLATFORM";
|
|
RMS11G_IAU
|
create
user "RMS11G_IAU" identified by ******* profile "DEFAULT"
account unlock default tablespace
"RMS11G_IAS_IAU" temporary tablespace
"RMS11G_IAS_TEMP";
grant
UNLIMITED TABLESPACE to "RMS11G_IAU";
grant
"CONNECT" to "RMS11G_IAU";
grant
"RESOURCE" to "RMS11G_IAU";
|
|
RMS11G_IAU_APPEND
|
create
user "RMS11G_IAU_APPEND" identified by ******* profile
"DEFAULT" account unlock default tablespace "RMS11G_IAS_IAU" temporary
tablespace "RMS11G_IAS_TEMP";
grant
"CONNECT" to "RMS11G_IAU_APPEND";
|
|
RMS11G_IAU_VIEWER
|
create
user "RMS11G_IAU_VIEWER" identified by ******* profile
"DEFAULT" account unlock default tablespace "RMS11G_IAS_IAU" temporary
tablespace "RMS11G_IAS_TEMP";
grant
"CONNECT" to "RMS11G_IAU_VIEWER";
|
|
RMS11G_MDS
|
create
user "RMS11G_MDS" identified by ******* profile "DEFAULT"
account unlock default tablespace
"RMS11G_MDS" temporary tablespace
"RMS11G_IAS_TEMP";
grant
CREATE TABLE to "RMS11G_MDS";
grant
CREATE SEQUENCE to "RMS11G_MDS";
grant
CREATE PROCEDURE to "RMS11G_MDS";
grant
"CONNECT" to "RMS11G_MDS";
grant
CREATE TYPE to "RMS11G_MDS";
|
List of dump Files
Import data use SQL dump.
|
Name
|
SQL Dump
|
|
RMS11G_BIPLATFORM.dmp
|
expdp system/*********@ptud
schemas=RMS11G_BIPLATFORM dumpfile=RMS11G_BIPLATFORM.dmp
logfile=exRMS11G_BIPLATFORM.log version=11.2.0.4.0
|
|
impdp system/******@service_name
directory=your_directory
dumpfile= RMS11G_BIPLATFORM.dmp
logfile=
RMS11G_BIPLATFORM.log
|
|
|
RMS11G_IAU.dmp
|
expdp system/**********@ptud
schemas=RMS11G_IAU dumpfile=RMS11G_IAU.dmp logfile=exRMS11G_IAU.log
version=11.2.0.4.0
|
|
impdp system/******@service_name
directory=your_directory
dumpfile= RMS11G_IAU.dmp
logfile=
RMS11G_IAU.log
|
|
|
RMS11G_IAU_APPEND.dmp
|
expdp system/********@ptud
schemas=RMS11G_IAU_APPEND dumpfile=RMS11G_IAU_APPEND.dmp logfile=exRMS11G_IAU_APPEND.log
version=11.2.0.4.0
|
|
impdp system/******@service_name
directory=your_directory
dumpfile= RMS11G_IAU_APPEND.dmp
logfile=
im RMS11G_IAU_APPEND.log
|
|
|
RMS11G_IAU_VIEWER.dmp
|
expdp system/********@ptud
schemas=RMS11G_IAU_VIEWER dumpfile=RMS11G_IAU_VIEWER.dmp
logfile=exRMS11G_IAU_VIEWER.log version=11.2.0.4.0
|
|
impdp system/******@service_name
directory=your_directory
dumpfile= RMS11G_IAU_VIEWER.dmp
logfile=
im RMS11G_IAU_VIEWER.log
|
|
|
RMS11G_MDS.dmp
|
expdp system/**********@ptud
schemas=RMS11G_MDS dumpfile=RMS11G_MDS.dmp logfile=exRMS11G_MDS.log
version=11.2.0.4.0
|
|
impdp system/******@service_name
directory=your_directory
dumpfile= RMS11G_MDS.dmp
logfile=
imRMS11G_MDS.log
|
Unlock and set password for
schemas:
|
Name
|
SQL Dump
|
|
RMS11G_BIPLATFORM
|
Alter user RMS11G_BIPLATFORM account unlock
identified by ********;
|
|
RMS11G_IAU
|
Alter user RMS11G_IAU account unlock
identified by ********;
|
|
RMS11G_IAU_APPEND
|
Alter user RMS11G_IAU_APPEND account unlock identified by ********;
|
|
RMS11G_IAU_VIEWER
|
Alter user RMS11G_IAU_VIEWER account unlock
identified by ********;
|
|
RMS11G_MDS
|
Alter user RMS11G_MDS account unlock
identified by ********;
|
Contact:
Any question feedback thonh15@gmail.com
Subscribe to:
Posts (Atom)
Weekly
-
Installation Guide for P6 Professional Primavera R15.1 About This Document This document table... -
Table of Contents I. Prerequisite: 2 1. JDK Installation: 2 2. Installing a Database: 2 II. Download the s... -
. BI Publisher 12c High Availability Architecture My environment is following: Node 1 Node2 Hostname obiee1.vt... -
Step 1: Set JAVA environment for PENTAHO My Computer --> Properties( Click right mouse My Computer) --> Advanced system setti... -
My environment: PHP: version 5.6.30 Xampp: Xampp version: 3.2.2 (x86) Xampp Directory: C:\xampp MariaDB: version 10.1.21 My proble... -
[root@vcr-broadcast2 tmp]# rpm -q libgc rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such ...
-
Run P6 db scripts that set table statistics (orpm_stats_gather.sql) These scripts can be found at /database/scripts/common/aux_script Th...
-
First, we start AdminServer [access@ptud PrimaveraP6EPPM]$ pwd /home/access/fmw/user_projects/domains/PrimaveraP6EPPM [access@ptud Pr... -
Architecture: It’s the same way to do. Read this article for details http://vtgdb.blogspot.com/2015/09/integrate-content-reposit... -
Source Server Target Server Hostname Vtgdb1.blogspot.com Vtbdb2.blogspot.com ...