ITPub博客

查看环境变量env    #显示全局变量,export的变量. 取消unset.set    #能将env的结果都显示出来，并将user的显示出来*      # *前面的字符是0个或多个字符 .      # 任意一个字符?      # ? 前面的字符 0个...

HP Unix server vg自动激活AUTO_VG_ACTIVATE=0      #表示不激活custom_vg_activation()          #里面表示自动启动{        /sbin/vgchange -a y /dev/vg00       ...

UX:vxfs mount: ERROR: V-3-21264: /dev/vgora/oragrid is already mounted, /oragrid is busy, allowable number of mount points exceeded 解决方法:把/oragrid删掉，去掉/etc/fstab中的记录重新mkdir /oragrid，再在/etc/fstab中添加记录。ok

1.Hardware check.  (1)machinfo | grep -i memory   # memory>2G  (2)swapinfo -a  (3)bdf                         #Disk Space Require2.Software Check.&nb...

vgremove 不成功措施(vgexport).[xxxx]# vgremove vgoravgremove: Couldn't delete physical volume:No such device or addressvgremove: Couldn't remove volume group "vgora".[xxxx]# vgexport vgoravgexport: Volume group "vgora" is still active.vgexport: Couldn't export volume group "vgora".[xxxx]# ...

##linux7设置ssh面密码登录(密码变更后一样可以登录)[root@rhel7 ~]$ ssh-keygen          #生产密钥文件Generating public/private rsa key pair.Enter file in which to save the key (/root/.ssh/id_rsa): /root/.ssh/id_rsa already exists.Overwrite (y/n)? yEnte...

1.mysql source code install(5.7.15)mysql版本相关知识mysql的命名机制使用3个数字和一个后最组成的版本号mysql-5.0.0-beta  5表示主版本号,0表示级别，9表示发行系列的版本号 alpha -有未被测试的新代码 beta  -alpha版使用一个月之后没有致命漏洞 rc    -发行了一段时间...

最常用的两个命令switchshowcfgshow    1.先建立config文件后，在建立zone2.fcmsutil /dev/fcd2 后  N_Port Node World Wide Name = 0x5xxxxxxxxxxxxxxx  N_Port Port World Wide Name = 0x5xxxxxxxxxxxxxxx      这个是提供给sanswich的WWN号  Switch Por...

[root@rhel7 ~]# cd /etc/ssh[root@rhel7 ssh]# more sshd_configGSSAPIAuthentication noUseDNS no[root@rhel7 ssh]# systemctl restart sshd后正常.

HP Unix Install Oracle11g(Single Instance)1.Hardware check.  (1)machinfo | grep -i memory   # memory>2G  (2)swapinfo -a  (3)bdf                       &nbsp...

[root@testdb:/#] pvcreate /dev/rdsk/c2t1d4                  #使用的字符设备Physical volume "/dev/rdsk/c2t1d4" has been successfully created.[root@testdb:/#] vgcreate vgora /dev/dsk/c2t1d4    &...

方法1，set_parms hostname     #这个需要重启,这个要在/etc/hosts中配置一下方法2,vi /etc/rc.config.d/netconf  HOSTNAME="xxxxxxxxx"         #修改电脑名称OPERATING_SYSTEM=HP-UXLOOPBACK_ADDRESS=127.0.0.1shutdown -ry 0  &n...

C:\Users\Admin>set ORACLE_HOME=E:\oracle11g\product\11.2.0\dbhome_1C:\Users\Admin>set ORACLE_SID=bruceC:\Users\Admin>oradim -new -sid bruceInstance created.初始化参数文件内容(11g):db_name=bruceaudit_file_dest=E:\oracle11gaudit_trail =dbdb_block_size=8192control_files = ('E:\oracle11g\ora...

===============================change root password=====================================================恢复root密码 （1）按e编辑grub菜单 （2）选择linux16那行，追加 init=/bin/sh   (中间有个空格)（3）ctrl+X引导 （4）# mount  -o  remount,rw  /（6）# echo "12345...

ASM Header BACKUP[root@#] more /oracle/ASM/asm_dg_meta_backup.sh. ~oracle/.bash_profileexport ORACLE_SID=+ASM1export ORACLE_BASE=/u02/oracleexport ORACLE_HOME=/u02/11204/gridexport GRID_HOME=$ORACLE_HOMEASMHEADER_BACKUP_HOME=/oracle/ASMBACKUP_FILE=$ASMHEADER_BACKUP_HOME/ASM_DG_META_BACKU...

before we start to PSU upgrade,we should backup database(cold or hot backup) and the oracle home directory. C:\Users\Admin>chcp 437    #change language mode to english.D:\>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1D:\>echo %ORACLE_HOME%E:\oracle\product\10.2.0\db_1E:\oracle...

Oracle 10.2.0.5 opatch utility upgrade.E:\oracle\product\10.2.0\db_1\OPatch>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1E:\oracle\product\10.2.0\db_1\OPatch>echo %ORACLE_HOME%E:\oracle\product\10.2.0\db_1E:\oracle\product\10.2.0\db_1\OPatch>opatch versionInvoking OPatch 10.2.0.4.9OPatch Ve...

从oracle官网上下载相关patchset:https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=qdu85yeys_9&_afrLoop=602692658891347p8202632_10205_WINNT.zip 注意这个是windows 32bit的1.安装过程的话和正常的安装一样，根据提示一步一步往下操作.(图形界面)安装过程中遇到的问题提示ORASLAX10.D...

Oracle收集统计信息的采样比例: SELECT owner, segment_name, ROUND (SUM (bytes) / 1024 / 1024) size_mb,         case when sum(bytes)/1024/1024 = 1  ...

Top sql: select rownum as rank, a.*from (select PARSING_SCHEMA_NAME RUN_USER, --执行用户SQL_FULLTEXT, --SQL文本,全，带格式sql_text, --SQL文本前面部分elapsed_Time , --单位是微秒，语句执行完的总时间，包括CPU时间和等待时间cpu_time , --CPU时间，语句运行的时间elapsed_Time - cpu_time wait_time,tru...