Notes
Notes - notes.io |
[root@centos7 ~]# groupadd oinstall
[root@centos7 ~]# groupadd dba
[root@centos7 ~]# useradd -g oinstall -G dba oracle
[root@centos7 ~]# useradd -g oinstall -G dba zxin10
[root@centos7 ~]# passwd oracle
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/5/html/tuning_and_optimizing_red_hat_enterprise_linux_for_oracle_9i_and_10g_databases/chap-oracle_9i_and_10g_tuning_guide-oracle_10g_and_linux_installation_errors_and_troubleshooting
[root@centos7 ~]# /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
[root@centos7 ~]# sysctl -p
[root@centos7 ~]# sysctl -a
[root@centos7 ~]# /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64
glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64
libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64 libXp*
mkdir -p /home/oracle/oracle10g
mkdir -p /home/oracle/zxindbf
mkdir -p /home/oracle/zxinbak
mkdir -p /home/oracle/zxindata
chown -R oracle.oinstall /home/oracle/*
yum install -y xorg-x11-twm xsetroot tigervnc-server.x86_64 tigervnc-server-module.x86_64 tigervnc-server-applet.noarchlibvncserver.x86_64 libvncserver-devel.x86_64
yum groupinstall -y "X Window System"
==================================================================================================================================
1. Check tablespace used by schema in oracle
SQL> select distinct tablespace_name from dba_segments where owner='&schema';
List datafiles in tablespace in oracle
SQL> select file_name from dba_data_files where tablespace_name like '%&tablespace%';
List datafiles with size in tablespace in oracle
Tính theo MB
SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name like '%&tablespace%';
Tính theo GB
SQL> select file_name,bytes/1024/1024/1024 from dba_data_files where tablespace_name like '%&tablespace%';
SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;
or
SQL> select a.tablespace_name, b.file_name from dba_tablespaces a join dba_data_files b on (a.tablespace_name=b.tablespace_name) order by tablespace_name;
2. Create tablespace
CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE '/zxindata/oracle/system/undo01.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL
CREATE TABLESPACE "SYSAUX" BLOCKSIZE 8192 DATAFILE '/zxindata/oracle/system/sysaux01.dbf' SIZE 8192M REUSE EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/oracle/system/temp01.dbf' SIZE 8192M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
CREATE TABLESPACE "ZXIN_DATA" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file0/zxin_data001.dbf' SIZE 20480M REUSE, '/zxindata/zxin_file0/zxin_data002.dbf' SIZE 20480M REUSE, '/zxindata/zxin_file0/zxin_data003.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "ZXIN_TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/zxin_temp/zxin_temp001.dbf' SIZE 10240M REUSE, '/zxindata/zxin_temp/zxin_temp002.dbf' SIZE 10240M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
CREATE TABLESPACE "ZXIN_BILL" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file1/zxin_bill001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_OMM" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file2/zxin_omm001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_INDEX" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_index/zxin_index001.dbf' SIZE 1073741824 REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_870" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_870/zxin_870001.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "SSB_DATA_JWF" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_jwf/ssb_data_jwf001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXDBM_DATA" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_data/zxdbm_data001.dbf' SIZE 4096M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "ZXDBM_TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/zxdbm_data/zxdbm_temp001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ALTER USER "SYS" IDENTIFIED BY VALUES '5638228DAF52805F' TEMPORARY TABLESPACE "ZXIN_TEMP"
ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' TEMPORARY TABLESPACE "ZXIN_TEMP" ACCOUNT LOCK
CREATE USER "TSMSYS" IDENTIFIED BY VALUES '3DF26A8B17D0F29F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP" PASSWORD EXPIRE ACCOUNT LOCK
CREATE USER "ZXLOGIN" IDENTIFIED BY VALUES 'D02F5555BAD4A0DE' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXIN_SMAP" IDENTIFIED BY VALUES '07F202D175BA539B' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINSYS" IDENTIFIED BY VALUES 'F4763B55388FD77F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXIN" IDENTIFIED BY VALUES '10C70A8D59DE054A' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINCHARGE" IDENTIFIED BY VALUES '713FD04342561308' DEFAULT TABLESPACE "ZXIN_BILL" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINALARM" IDENTIFIED BY VALUES 'BC02F71E34825460' DEFAULT TABLESPACE "ZXIN_OMM" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINMEASURE" IDENTIFIED BY VALUES 'F606CC6E15213A29' DEFAULT TABLESPACE "ZXIN_OMM" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_830" IDENTIFIED BY VALUES '16022443E19F7C5F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_870" IDENTIFIED BY VALUES 'B655E2D8C5B6EAF2' DEFAULT TABLESPACE "ZXIN_870" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_UCM" IDENTIFIED BY VALUES '91838FA57DC8B251' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_AD" IDENTIFIED BY VALUES 'F5A4E00DFD9F1001' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_HOTEL" IDENTIFIED BY VALUES 'CE50F7AD01A41300' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_IPTV" IDENTIFIED BY VALUES '9FC8BB35D8B1F596' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_UMAP" IDENTIFIED BY VALUES '6F074AB0B1B0114F' DEFAULT TABLESPACE "ZXDBM_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_890" IDENTIFIED BY VALUES 'E4F3B838EC4147C7' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE ROLE "SELECT_CATALOG_ROLE"
REVOKE "SELECT_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "EXECUTE_CATALOG_ROLE"
REVOKE "EXECUTE_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "DELETE_CATALOG_ROLE"
REVOKE "DELETE_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "RECOVERY_CATALOG_OWNER"
REVOKE "RECOVERY_CATALOG_OWNER" FROM SYSTEM
CREATE ROLE "GATHER_SYSTEM_STATISTICS"
REVOKE "GATHER_SYSTEM_STATISTICS" FROM SYSTEM
CREATE ROLE "LOGSTDBY_ADMINISTRATOR"
REVOKE "LOGSTDBY_ADMINISTRATOR" FROM SYSTEM
CREATE ROLE "AQ_ADMINISTRATOR_ROLE"
REVOKE "AQ_ADMINISTRATOR_ROLE" FROM SYSTEM
CREATE ROLE "AQ_USER_ROLE"
REVOKE "AQ_USER_ROLE" FROM SYSTEM
CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY
CREATE ROLE "SCHEDULER_ADMIN"
REVOKE "SCHEDULER_ADMIN" FROM SYSTEM
CREATE ROLE "HS_ADMIN_ROLE"
REVOKE "HS_ADMIN_ROLE" FROM SYSTEM
GRANT UNLIMITED TABLESPACE TO "SYSTEM" WITH ADMIN OPTION
GRANT CREATE SESSION TO "OUTLN"
GRANT UNLIMITED TABLESPACE TO "OUTLN"
GRANT EXECUTE ANY PROCEDURE TO "OUTLN"
GRANT CREATE TABLE TO "SYSTEM"
GRANT CREATE MATERIALIZED VIEW TO "SYSTEM"
GRANT SELECT ANY TABLE TO "SYSTEM"
GRANT GLOBAL QUERY REWRITE TO "SYSTEM"
GRANT CREATE SESSION TO "RECOVERY_CATALOG_OWNER"
GRANT ALTER SESSION TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TABLE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE CLUSTER TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE SYNONYM TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE VIEW TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE SEQUENCE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE DATABASE LINK TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE PROCEDURE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TRIGGER TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TYPE TO "RECOVERY_CATALOG_OWNER"
GRANT SELECT ANY TABLE TO "SYS" WITH ADMIN OPTION
GRANT INSERT ANY TABLE TO "SYS"
GRANT UPDATE ANY TABLE TO "SYS"
GRANT DELETE ANY TABLE TO "SYS"
GRANT SELECT ANY SEQUENCE TO "SYS"
GRANT EXECUTE ANY TYPE TO "SYS"
GRANT ANALYZE ANY TO "SYS"
GRANT CREATE JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT CREATE ANY JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT EXECUTE ANY PROGRAM TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT EXECUTE ANY CLASS TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT MANAGE SCHEDULER TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT CREATE EXTERNAL JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT LOCK ANY TABLE TO "SYS"
GRANT EXECUTE ANY PROCEDURE TO "SYS"
GRANT UNLIMITED TABLESPACE TO "TSMSYS"
GRANT UNLIMITED TABLESPACE TO "ZXIN_SMAP"
GRANT SELECT ANY TABLE TO "ZXIN_SMAP"
GRANT UNLIMITED TABLESPACE TO "ZXINSYS"
GRANT UNLIMITED TABLESPACE TO "ZXIN"
GRANT UNLIMITED TABLESPACE TO "ZXINCHARGE"
GRANT UNLIMITED TABLESPACE TO "ZXINALARM"
GRANT UNLIMITED TABLESPACE TO "ZXINMEASURE"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_830"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_870"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_UCM"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_AD"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_HOTEL"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_IPTV"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_UMAP"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_890"
GRANT INSERT ANY TABLE TO "ZXIN_SMAP"
GRANT UPDATE ANY TABLE TO "ZXIN_SMAP"
GRANT DELETE ANY TABLE TO "ZXIN_SMAP"
GRANT EXECUTE ANY PROCEDURE TO "ZXIN_SMAP"
GRANT SELECT ANY TABLE TO "ZXDBM_830"
GRANT SELECT ANY TABLE TO "ZXDBM_UCM"
GRANT "CONNECT" TO "SYS" WITH ADMIN OPTION
GRANT "RESOURCE" TO "SYS" WITH ADMIN OPTION
GRANT "DBA" TO "SYS" WITH ADMIN OPTION
GRANT "DBA" TO "SYSTEM" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "EXECUTE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "DELETE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "EXECUTE_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "DELETE_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "EXP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION
GRANT "IMP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "EXP_FULL_DATABASE"
GRANT "SELECT_CATALOG_ROLE" TO "IMP_FULL_DATABASE"
GRANT "EXECUTE_CATALOG_ROLE" TO "IMP_FULL_DATABASE"
GRANT "EXECUTE_CATALOG_ROLE" TO "EXP_FULL_DATABASE"
GRANT "RESOURCE" TO "OUTLN"
GRANT "EXP_FULL_DATABASE" TO "DBA"
GRANT "IMP_FULL_DATABASE" TO "DBA"
GRANT "RECOVERY_CATALOG_OWNER" TO "SYS" WITH ADMIN OPTION
GRANT "GATHER_SYSTEM_STATISTICS" TO "SYS" WITH ADMIN OPTION
GRANT "GATHER_SYSTEM_STATISTICS" TO "DBA"
GRANT "LOGSTDBY_ADMINISTRATOR" TO "SYS" WITH ADMIN OPTION
GRANT "RESOURCE" TO "LOGSTDBY_ADMINISTRATOR"
GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "AQ_USER_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYSTEM" WITH ADMIN OPTION
GRANT "SCHEDULER_ADMIN" TO "SYS" WITH ADMIN OPTION
GRANT "SCHEDULER_ADMIN" TO "DBA" WITH ADMIN OPTION
GRANT "HS_ADMIN_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "HS_ADMIN_ROLE" TO "SELECT_CATALOG_ROLE"
GRANT "HS_ADMIN_ROLE" TO "EXECUTE_CATALOG_ROLE"
GRANT "RESOURCE" TO "TSMSYS"
GRANT "CONNECT" TO "ZXLOGIN"
GRANT "CONNECT" TO "ZXIN_SMAP"
GRANT "RESOURCE" TO "ZXIN_SMAP"
GRANT "DBA" TO "ZXIN_SMAP"
GRANT "EXP_FULL_DATABASE" TO "ZXIN_SMAP"
GRANT "IMP_FULL_DATABASE" TO "ZXIN_SMAP"
GRANT "CONNECT" TO "ZXINSYS"
GRANT "RESOURCE" TO "ZXINSYS"
GRANT "DBA" TO "ZXINSYS"
GRANT "CONNECT" TO "ZXIN"
GRANT "RESOURCE" TO "ZXIN"
GRANT "DBA" TO "ZXIN"
GRANT "CONNECT" TO "ZXINCHARGE"
GRANT "RESOURCE" TO "ZXINCHARGE"
GRANT "DBA" TO "ZXINCHARGE"
GRANT "CONNECT" TO "ZXINALARM"
GRANT "RESOURCE" TO "ZXINALARM"
GRANT "DBA" TO "ZXINALARM"
GRANT "CONNECT" TO "ZXINMEASURE"
GRANT "RESOURCE" TO "ZXINMEASURE"
GRANT "DBA" TO "ZXINMEASURE"
GRANT "CONNECT" TO "ZXDBM_830"
GRANT "RESOURCE" TO "ZXDBM_830"
GRANT "DBA" TO "ZXDBM_830"
GRANT "CONNECT" TO "ZXDBM_870"
GRANT "RESOURCE" TO "ZXDBM_870"
GRANT "DBA" TO "ZXDBM_870"
GRANT "CONNECT" TO "ZXDBM_UCM"
GRANT "RESOURCE" TO "ZXDBM_UCM"
GRANT "DBA" TO "ZXDBM_UCM"
GRANT "CONNECT" TO "ZXDBM_AD"
GRANT "RESOURCE" TO "ZXDBM_AD"
GRANT "DBA" TO "ZXDBM_AD"
GRANT "CONNECT" TO "ZXDBM_HOTEL"
GRANT "RESOURCE" TO "ZXDBM_HOTEL"
GRANT "DBA" TO "ZXDBM_HOTEL"
GRANT "CONNECT" TO "ZXDBM_IPTV"
GRANT "RESOURCE" TO "ZXDBM_IPTV"
GRANT "DBA" TO "ZXDBM_IPTV"
GRANT "CONNECT" TO "ZXDBM_UMAP"
GRANT "RESOURCE" TO "ZXDBM_UMAP"
GRANT "DBA" TO "ZXDBM_UMAP"
GRANT "CONNECT" TO "ZXDBM_890"
GRANT "RESOURCE" TO "ZXDBM_890"
GRANT "DBA" TO "ZXDBM_890"
ALTER USER "ZXDBM_890" DEFAULT ROLE ALL
ALTER USER "ZXDBM_UMAP" DEFAULT ROLE ALL
ALTER USER "ZXDBM_IPTV" DEFAULT ROLE ALL
ALTER USER "ZXDBM_HOTEL" DEFAULT ROLE ALL
ALTER USER "ZXDBM_AD" DEFAULT ROLE ALL
ALTER USER "ZXDBM_UCM" DEFAULT ROLE ALL
ALTER USER "ZXDBM_870" DEFAULT ROLE ALL
ALTER USER "ZXDBM_830" DEFAULT ROLE ALL
ALTER USER "ZXINMEASURE" DEFAULT ROLE ALL
ALTER USER "ZXINALARM" DEFAULT ROLE ALL
ALTER USER "ZXINCHARGE" DEFAULT ROLE ALL
ALTER USER "ZXIN" DEFAULT ROLE ALL
ALTER USER "ZXINSYS" DEFAULT ROLE ALL
ALTER USER "ZXIN_SMAP" DEFAULT ROLE ALL
ALTER USER "ZXLOGIN" DEFAULT ROLE ALL
ALTER USER "TSMSYS" DEFAULT ROLE ALL
ALTER USER "OUTLN" DEFAULT ROLE ALL
ALTER USER "SYSTEM" DEFAULT ROLE ALL
[root@centos7 ~]# groupadd dba
[root@centos7 ~]# useradd -g oinstall -G dba oracle
[root@centos7 ~]# useradd -g oinstall -G dba zxin10
[root@centos7 ~]# passwd oracle
https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/5/html/tuning_and_optimizing_red_hat_enterprise_linux_for_oracle_9i_and_10g_databases/chap-oracle_9i_and_10g_tuning_guide-oracle_10g_and_linux_installation_errors_and_troubleshooting
[root@centos7 ~]# /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1987162112
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048586
[root@centos7 ~]# sysctl -p
[root@centos7 ~]# sysctl -a
[root@centos7 ~]# /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
yum install -y binutils.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc.i686 glibc.x86_64
glibc-devel.i686 glibc-devel.x86_64 ksh compat-libstdc++-33 libaio.i686 libaio.x86_64 libaio-devel.i686 libaio-devel.x86_64
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686 libstdc++-devel.x86_64 libXi.i686 libXi.x86_64
libXtst.i686 libXtst.x86_64 make.x86_64 sysstat.x86_64 libXp*
mkdir -p /home/oracle/oracle10g
mkdir -p /home/oracle/zxindbf
mkdir -p /home/oracle/zxinbak
mkdir -p /home/oracle/zxindata
chown -R oracle.oinstall /home/oracle/*
yum install -y xorg-x11-twm xsetroot tigervnc-server.x86_64 tigervnc-server-module.x86_64 tigervnc-server-applet.noarchlibvncserver.x86_64 libvncserver-devel.x86_64
yum groupinstall -y "X Window System"
==================================================================================================================================
1. Check tablespace used by schema in oracle
SQL> select distinct tablespace_name from dba_segments where owner='&schema';
List datafiles in tablespace in oracle
SQL> select file_name from dba_data_files where tablespace_name like '%&tablespace%';
List datafiles with size in tablespace in oracle
Tính theo MB
SQL> select file_name,bytes/1024/1024 from dba_data_files where tablespace_name like '%&tablespace%';
Tính theo GB
SQL> select file_name,bytes/1024/1024/1024 from dba_data_files where tablespace_name like '%&tablespace%';
SQL> SELECT TABLESPACE_NAME, STATUS, CONTENTS FROM USER_TABLESPACES;
or
SQL> select a.tablespace_name, b.file_name from dba_tablespaces a join dba_data_files b on (a.tablespace_name=b.tablespace_name) order by tablespace_name;
2. Create tablespace
CREATE UNDO TABLESPACE "UNDOTBS1" BLOCKSIZE 8192 DATAFILE '/zxindata/oracle/system/undo01.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL
CREATE TABLESPACE "SYSAUX" BLOCKSIZE 8192 DATAFILE '/zxindata/oracle/system/sysaux01.dbf' SIZE 8192M REUSE EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/oracle/system/temp01.dbf' SIZE 8192M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
CREATE TABLESPACE "ZXIN_DATA" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file0/zxin_data001.dbf' SIZE 20480M REUSE, '/zxindata/zxin_file0/zxin_data002.dbf' SIZE 20480M REUSE, '/zxindata/zxin_file0/zxin_data003.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "ZXIN_TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/zxin_temp/zxin_temp001.dbf' SIZE 10240M REUSE, '/zxindata/zxin_temp/zxin_temp002.dbf' SIZE 10240M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
CREATE TABLESPACE "ZXIN_BILL" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file1/zxin_bill001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_OMM" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_file2/zxin_omm001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_INDEX" BLOCKSIZE 8192 DATAFILE '/zxindata/zxin_index/zxin_index001.dbf' SIZE 1073741824 REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXIN_870" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_870/zxin_870001.dbf' SIZE 20480M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "SSB_DATA_JWF" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_jwf/ssb_data_jwf001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE "ZXDBM_DATA" BLOCKSIZE 8192 DATAFILE '/zxindata/zxdbm_data/zxdbm_data001.dbf' SIZE 4096M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576 ONLINE PERMANENT SEGMENT SPACE MANAGEMENT AUTO
CREATE TEMPORARY TABLESPACE "ZXDBM_TEMP" BLOCKSIZE 8192 TEMPFILE '/zxindata/zxdbm_data/zxdbm_temp001.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576
ALTER USER "SYS" IDENTIFIED BY VALUES '5638228DAF52805F' TEMPORARY TABLESPACE "ZXIN_TEMP"
ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'D4DF7931AB130E37' TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81' TEMPORARY TABLESPACE "ZXIN_TEMP" ACCOUNT LOCK
CREATE USER "TSMSYS" IDENTIFIED BY VALUES '3DF26A8B17D0F29F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP" PASSWORD EXPIRE ACCOUNT LOCK
CREATE USER "ZXLOGIN" IDENTIFIED BY VALUES 'D02F5555BAD4A0DE' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXIN_SMAP" IDENTIFIED BY VALUES '07F202D175BA539B' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINSYS" IDENTIFIED BY VALUES 'F4763B55388FD77F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXIN" IDENTIFIED BY VALUES '10C70A8D59DE054A' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINCHARGE" IDENTIFIED BY VALUES '713FD04342561308' DEFAULT TABLESPACE "ZXIN_BILL" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINALARM" IDENTIFIED BY VALUES 'BC02F71E34825460' DEFAULT TABLESPACE "ZXIN_OMM" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXINMEASURE" IDENTIFIED BY VALUES 'F606CC6E15213A29' DEFAULT TABLESPACE "ZXIN_OMM" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_830" IDENTIFIED BY VALUES '16022443E19F7C5F' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_870" IDENTIFIED BY VALUES 'B655E2D8C5B6EAF2' DEFAULT TABLESPACE "ZXIN_870" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_UCM" IDENTIFIED BY VALUES '91838FA57DC8B251' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_AD" IDENTIFIED BY VALUES 'F5A4E00DFD9F1001' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_HOTEL" IDENTIFIED BY VALUES 'CE50F7AD01A41300' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_IPTV" IDENTIFIED BY VALUES '9FC8BB35D8B1F596' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_UMAP" IDENTIFIED BY VALUES '6F074AB0B1B0114F' DEFAULT TABLESPACE "ZXDBM_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE USER "ZXDBM_890" IDENTIFIED BY VALUES 'E4F3B838EC4147C7' DEFAULT TABLESPACE "ZXIN_DATA" TEMPORARY TABLESPACE "ZXIN_TEMP"
CREATE ROLE "SELECT_CATALOG_ROLE"
REVOKE "SELECT_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "EXECUTE_CATALOG_ROLE"
REVOKE "EXECUTE_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "DELETE_CATALOG_ROLE"
REVOKE "DELETE_CATALOG_ROLE" FROM SYSTEM
CREATE ROLE "RECOVERY_CATALOG_OWNER"
REVOKE "RECOVERY_CATALOG_OWNER" FROM SYSTEM
CREATE ROLE "GATHER_SYSTEM_STATISTICS"
REVOKE "GATHER_SYSTEM_STATISTICS" FROM SYSTEM
CREATE ROLE "LOGSTDBY_ADMINISTRATOR"
REVOKE "LOGSTDBY_ADMINISTRATOR" FROM SYSTEM
CREATE ROLE "AQ_ADMINISTRATOR_ROLE"
REVOKE "AQ_ADMINISTRATOR_ROLE" FROM SYSTEM
CREATE ROLE "AQ_USER_ROLE"
REVOKE "AQ_USER_ROLE" FROM SYSTEM
CREATE ROLE "GLOBAL_AQ_USER_ROLE" IDENTIFIED GLOBALLY
CREATE ROLE "SCHEDULER_ADMIN"
REVOKE "SCHEDULER_ADMIN" FROM SYSTEM
CREATE ROLE "HS_ADMIN_ROLE"
REVOKE "HS_ADMIN_ROLE" FROM SYSTEM
GRANT UNLIMITED TABLESPACE TO "SYSTEM" WITH ADMIN OPTION
GRANT CREATE SESSION TO "OUTLN"
GRANT UNLIMITED TABLESPACE TO "OUTLN"
GRANT EXECUTE ANY PROCEDURE TO "OUTLN"
GRANT CREATE TABLE TO "SYSTEM"
GRANT CREATE MATERIALIZED VIEW TO "SYSTEM"
GRANT SELECT ANY TABLE TO "SYSTEM"
GRANT GLOBAL QUERY REWRITE TO "SYSTEM"
GRANT CREATE SESSION TO "RECOVERY_CATALOG_OWNER"
GRANT ALTER SESSION TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TABLE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE CLUSTER TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE SYNONYM TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE VIEW TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE SEQUENCE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE DATABASE LINK TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE PROCEDURE TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TRIGGER TO "RECOVERY_CATALOG_OWNER"
GRANT CREATE TYPE TO "RECOVERY_CATALOG_OWNER"
GRANT SELECT ANY TABLE TO "SYS" WITH ADMIN OPTION
GRANT INSERT ANY TABLE TO "SYS"
GRANT UPDATE ANY TABLE TO "SYS"
GRANT DELETE ANY TABLE TO "SYS"
GRANT SELECT ANY SEQUENCE TO "SYS"
GRANT EXECUTE ANY TYPE TO "SYS"
GRANT ANALYZE ANY TO "SYS"
GRANT CREATE JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT CREATE ANY JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT EXECUTE ANY PROGRAM TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT EXECUTE ANY CLASS TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT MANAGE SCHEDULER TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT CREATE EXTERNAL JOB TO "SCHEDULER_ADMIN" WITH ADMIN OPTION
GRANT LOCK ANY TABLE TO "SYS"
GRANT EXECUTE ANY PROCEDURE TO "SYS"
GRANT UNLIMITED TABLESPACE TO "TSMSYS"
GRANT UNLIMITED TABLESPACE TO "ZXIN_SMAP"
GRANT SELECT ANY TABLE TO "ZXIN_SMAP"
GRANT UNLIMITED TABLESPACE TO "ZXINSYS"
GRANT UNLIMITED TABLESPACE TO "ZXIN"
GRANT UNLIMITED TABLESPACE TO "ZXINCHARGE"
GRANT UNLIMITED TABLESPACE TO "ZXINALARM"
GRANT UNLIMITED TABLESPACE TO "ZXINMEASURE"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_830"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_870"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_UCM"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_AD"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_HOTEL"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_IPTV"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_UMAP"
GRANT UNLIMITED TABLESPACE TO "ZXDBM_890"
GRANT INSERT ANY TABLE TO "ZXIN_SMAP"
GRANT UPDATE ANY TABLE TO "ZXIN_SMAP"
GRANT DELETE ANY TABLE TO "ZXIN_SMAP"
GRANT EXECUTE ANY PROCEDURE TO "ZXIN_SMAP"
GRANT SELECT ANY TABLE TO "ZXDBM_830"
GRANT SELECT ANY TABLE TO "ZXDBM_UCM"
GRANT "CONNECT" TO "SYS" WITH ADMIN OPTION
GRANT "RESOURCE" TO "SYS" WITH ADMIN OPTION
GRANT "DBA" TO "SYS" WITH ADMIN OPTION
GRANT "DBA" TO "SYSTEM" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "EXECUTE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "DELETE_CATALOG_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "EXECUTE_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "DELETE_CATALOG_ROLE" TO "DBA" WITH ADMIN OPTION
GRANT "EXP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION
GRANT "IMP_FULL_DATABASE" TO "SYS" WITH ADMIN OPTION
GRANT "SELECT_CATALOG_ROLE" TO "EXP_FULL_DATABASE"
GRANT "SELECT_CATALOG_ROLE" TO "IMP_FULL_DATABASE"
GRANT "EXECUTE_CATALOG_ROLE" TO "IMP_FULL_DATABASE"
GRANT "EXECUTE_CATALOG_ROLE" TO "EXP_FULL_DATABASE"
GRANT "RESOURCE" TO "OUTLN"
GRANT "EXP_FULL_DATABASE" TO "DBA"
GRANT "IMP_FULL_DATABASE" TO "DBA"
GRANT "RECOVERY_CATALOG_OWNER" TO "SYS" WITH ADMIN OPTION
GRANT "GATHER_SYSTEM_STATISTICS" TO "SYS" WITH ADMIN OPTION
GRANT "GATHER_SYSTEM_STATISTICS" TO "DBA"
GRANT "LOGSTDBY_ADMINISTRATOR" TO "SYS" WITH ADMIN OPTION
GRANT "RESOURCE" TO "LOGSTDBY_ADMINISTRATOR"
GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "AQ_USER_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "AQ_ADMINISTRATOR_ROLE" TO "SYSTEM" WITH ADMIN OPTION
GRANT "SCHEDULER_ADMIN" TO "SYS" WITH ADMIN OPTION
GRANT "SCHEDULER_ADMIN" TO "DBA" WITH ADMIN OPTION
GRANT "HS_ADMIN_ROLE" TO "SYS" WITH ADMIN OPTION
GRANT "HS_ADMIN_ROLE" TO "SELECT_CATALOG_ROLE"
GRANT "HS_ADMIN_ROLE" TO "EXECUTE_CATALOG_ROLE"
GRANT "RESOURCE" TO "TSMSYS"
GRANT "CONNECT" TO "ZXLOGIN"
GRANT "CONNECT" TO "ZXIN_SMAP"
GRANT "RESOURCE" TO "ZXIN_SMAP"
GRANT "DBA" TO "ZXIN_SMAP"
GRANT "EXP_FULL_DATABASE" TO "ZXIN_SMAP"
GRANT "IMP_FULL_DATABASE" TO "ZXIN_SMAP"
GRANT "CONNECT" TO "ZXINSYS"
GRANT "RESOURCE" TO "ZXINSYS"
GRANT "DBA" TO "ZXINSYS"
GRANT "CONNECT" TO "ZXIN"
GRANT "RESOURCE" TO "ZXIN"
GRANT "DBA" TO "ZXIN"
GRANT "CONNECT" TO "ZXINCHARGE"
GRANT "RESOURCE" TO "ZXINCHARGE"
GRANT "DBA" TO "ZXINCHARGE"
GRANT "CONNECT" TO "ZXINALARM"
GRANT "RESOURCE" TO "ZXINALARM"
GRANT "DBA" TO "ZXINALARM"
GRANT "CONNECT" TO "ZXINMEASURE"
GRANT "RESOURCE" TO "ZXINMEASURE"
GRANT "DBA" TO "ZXINMEASURE"
GRANT "CONNECT" TO "ZXDBM_830"
GRANT "RESOURCE" TO "ZXDBM_830"
GRANT "DBA" TO "ZXDBM_830"
GRANT "CONNECT" TO "ZXDBM_870"
GRANT "RESOURCE" TO "ZXDBM_870"
GRANT "DBA" TO "ZXDBM_870"
GRANT "CONNECT" TO "ZXDBM_UCM"
GRANT "RESOURCE" TO "ZXDBM_UCM"
GRANT "DBA" TO "ZXDBM_UCM"
GRANT "CONNECT" TO "ZXDBM_AD"
GRANT "RESOURCE" TO "ZXDBM_AD"
GRANT "DBA" TO "ZXDBM_AD"
GRANT "CONNECT" TO "ZXDBM_HOTEL"
GRANT "RESOURCE" TO "ZXDBM_HOTEL"
GRANT "DBA" TO "ZXDBM_HOTEL"
GRANT "CONNECT" TO "ZXDBM_IPTV"
GRANT "RESOURCE" TO "ZXDBM_IPTV"
GRANT "DBA" TO "ZXDBM_IPTV"
GRANT "CONNECT" TO "ZXDBM_UMAP"
GRANT "RESOURCE" TO "ZXDBM_UMAP"
GRANT "DBA" TO "ZXDBM_UMAP"
GRANT "CONNECT" TO "ZXDBM_890"
GRANT "RESOURCE" TO "ZXDBM_890"
GRANT "DBA" TO "ZXDBM_890"
ALTER USER "ZXDBM_890" DEFAULT ROLE ALL
ALTER USER "ZXDBM_UMAP" DEFAULT ROLE ALL
ALTER USER "ZXDBM_IPTV" DEFAULT ROLE ALL
ALTER USER "ZXDBM_HOTEL" DEFAULT ROLE ALL
ALTER USER "ZXDBM_AD" DEFAULT ROLE ALL
ALTER USER "ZXDBM_UCM" DEFAULT ROLE ALL
ALTER USER "ZXDBM_870" DEFAULT ROLE ALL
ALTER USER "ZXDBM_830" DEFAULT ROLE ALL
ALTER USER "ZXINMEASURE" DEFAULT ROLE ALL
ALTER USER "ZXINALARM" DEFAULT ROLE ALL
ALTER USER "ZXINCHARGE" DEFAULT ROLE ALL
ALTER USER "ZXIN" DEFAULT ROLE ALL
ALTER USER "ZXINSYS" DEFAULT ROLE ALL
ALTER USER "ZXIN_SMAP" DEFAULT ROLE ALL
ALTER USER "ZXLOGIN" DEFAULT ROLE ALL
ALTER USER "TSMSYS" DEFAULT ROLE ALL
ALTER USER "OUTLN" DEFAULT ROLE ALL
ALTER USER "SYSTEM" DEFAULT ROLE ALL
|
|
Notes is a web-based application for online taking notes. You can take your notes and share with others people. If you like taking long notes, notes.io is designed for you. To date, over 8,000,000,000+ notes created and continuing...
With notes.io;
- * You can take a note from anywhere and any device with internet connection.
- * You can share the notes in social platforms (YouTube, Facebook, Twitter, instagram etc.).
- * You can quickly share your contents without website, blog and e-mail.
- * You don't need to create any Account to share a note. As you wish you can use quick, easy and best shortened notes with sms, websites, e-mail, or messaging services (WhatsApp, iMessage, Telegram, Signal).
- * Notes.io has fabulous infrastructure design for a short link and allows you to share the note as an easy and understandable link.
Fast: Notes.io is built for speed and performance. You can take a notes quickly and browse your archive.
Easy: Notes.io doesn’t require installation. Just write and share note!
Short: Notes.io’s url just 8 character. You’ll get shorten link of your note when you want to share. (Ex: notes.io/q )
Free: Notes.io works for 14 years and has been free since the day it was started.
You immediately create your first note and start sharing with the ones you wish. If you want to contact us, you can use the following communication channels;
Email: [email protected]
Twitter: http://twitter.com/notesio
Instagram: http://instagram.com/notes.io
Facebook: http://facebook.com/notesio
Regards;
Notes.io Team
