ORACLE SYS

-
Default password of sys and system before oracle 9i
SYS: change_on_install
SYSTEM: manager
 
登录验证：
1. 密码；2. OS password file客户端sys登录，通过的是/$ORACLE_HOME/dbs/orapw$ORACLE_SID重建：orapwd file=文件名 password=密码 entries=最大连接个数 force=是否覆盖现有文件例如：orapwd file=orapworcl password=password entries=30 force=yFor windows server, sys just user following command to updatealter user sys identified by "<password>";3. 主机认证使用ORACLE 软件安装账户登录关闭该功能：1. oracle用户在$ORACLE_HOME/network/admin新建文件sqlnet.ora2. 修改sqlnet.ora文件：sqlnet.authentication_services=none
Password file
Linux: $ORACLE_HOME/dbs/orapw<ORACLE_SID>
Windows: $ORACLE_HOME\database\orapw<ORACLE_SID>
Feature: save the username and password of sysdba / sysoper

Database Remote Connection
Parameter "remote_login_passwordfile", value
1. None: do not allow remote login
2. Exclusive: allow remote login (by default)
3. Shared: allow the password file be shared. But file only save the password of sys user 
Change this parameter need restart oracle database

Comments

Post a Comment

Popular posts from this blog

Linux RHCE Preparation

-
RHCE 1. Start classroom-rh254 2. Set environment: yum install ./examrhce-0.0.1-l.el7.x86_64.rpm -y 3. Start server-rh254 4. Set lab environment: lab examrhce setup 5. Start desktop-rh254 6.  Set lab environment: lab examrhce setup 7. Check result: lab examrhcsa grade 1. Set Selinux A. Change config file: vim /etc/sysconfig/selinux B. Temporary set selinux: setenforce 1 C. Check selinux: getenforce If it used to be disabled, you need to restart to change to enforcing.  2. SSH Access Setting A. Disable the firewall for RHEL 6 i. systemctl mask iptables; ii. systemctl mask ip6tables; iii systemctl mask ebtable.service B. Start the firewall for RHEL 7 i. systemctl enable firewalld ii. systemctl start firewalld C. Set firewall rule i. Allow ssh: firewall-cmd --permanent --add-service=ssh ii. Block subnet for ssh: firewall-cmd --permanent --add-rich-rul='rule family=ipv4 source address=172.17.10.0/24 service=ssh reject' D. Reloa...
Read more

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more