Oracle Study之案例--Oracle Sqlplus错误-mysql教程-PHP中文网

首页

数据库

mysql教程

Oracle Study之案例--Oracle Sqlplus错误

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:40 PM

oraclestudy案例

OracleStudy之案例--OracleSqlplus错误系统环境：操作系统：AIX5.3数据库：Oracle10gR2案例分析：1、查看空间信息[oracle@aix220~]$df-mFilesystemMB&nbs..

Oracle Study之案例--Oracle Sqlplus错误

系统环境：

操作系统：AIX5.3

数据库： Oracle 10gR2

案例分析：

1、查看空间信息 [oracle@aix220 ~]$df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 17408.00 1238.15 93% 37699 12% / /dev/hd2 8192.00 6310.39 23% 46534 4% /usr /dev/hd9var 2048.00 1725.55 16% 1704 1% /var /dev/hd3 2048.00 1902.58 8% 420 1% /tmp /dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform /dev/hd1 2048.00 1821.98 12% 74 1% /home /proc - - - - - /proc /dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt /dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd /dev/arch 10240.00 8347.63 19% /dev/lv02 15360.00 10097.80 35% 123693 4% /u01 2、查看文件权限 [oracle@aix220 ~]$ls -ld /u01/app/oracle/admin/master/ drwxr-x--- 8 oracle dba 512 Feb 17 16:40 /u01/app/oracle/admin/master/ [oracle@aix220 ~]$ls -ld /u01/app/oracle/admin/master/adump/ drwxr-x--- 2 oracle dba 1536 Feb 17 19:48 /u01/app/oracle/admin/master/adump/ 3、查看文件系统信息 [oracle@aix220 dbs]$cat /etc/filesystems /u01: dev = /dev/lv02 vfs = jfs log = /dev/loglv00 mount = true options = rw account = false [root@aix220 /]#lsvg -l oraclevg oraclevg: LV NAME TYPE LPs PPs PVs LV STATE MOUNT POINT loglv00 jfslog 1 1 1 closed/syncd N/A lv02 jfs 120 120 1 closed/syncd /u01 [root@aix220 /]#df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 17408.00 1238.18 93% 37700 12% / /dev/hd2 8192.00 6310.39 23% 46534 4% /usr /dev/hd9var 2048.00 1725.56 16% 1704 1% /var /dev/hd3 2048.00 1902.58 8% 420 1% /tmp /dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform /dev/hd1 2048.00 1821.98 12% 74 1% /home /proc - - - - - /proc /dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt /dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd /dev/arch 10240.00 8347.63 19% 52 1% /arch /dev/lv01 5120.00 4959.25 4% 16 1% /flash /dev/lv03 25600.00 24796.43 4% 17 1% /home/oracle/arch_master rhel152:/backup/cuug15/storage30 14111.05 13052.23 8% 31 1% /backup mount文件系统失败： [root@aix220 /]#mount /u01 Replaying log for /dev/lv02. mount: /dev/lv02 on /u01: Unformatted or incompatible media The superblock on /dev/lv02 is dirty. Run a full fsck to fix. 修复文件系统： [root@aix220 /]#fsck -y /dev/lv02 ...... ** Phase 5 - Check Inode Map ** Phase 6 - Check Block Map Bad Block Map (SALVAGED) ** Phase 6b - Salvage Block Map Superblock is marked dirty (FIXED) 123665 files 10749336 blocks 20707944 free ***** Filesystem was modified ***** mount文件系统成功： [root@aix220 /]#mount /u01 [root@aix220 /]#df -m Filesystem MB blocks Free %Used Iused %Iused Mounted on /dev/hd4 17408.00 1238.16 93% 37699 12% / /dev/hd2 8192.00 6310.39 23% 46534 4% /usr /dev/hd9var 2048.00 1725.55 16% 1704 1% /var /dev/hd3 2048.00 1902.58 8% 420 1% /tmp /dev/fwdump 3072.00 3071.21 1% 4 1% /var/adm/ras/platform /dev/hd1 2048.00 1821.98 12% 74 1% /home /proc - - - - - /proc /dev/hd10opt 2048.00 1374.77 33% 8934 3% /opt /dev/lv00 1024.00 991.80 4% 18 1% /var/adm/csd /dev/lv02 15360.00 10111.30 35% 123674 4% /u01 执行sqlplus命令成功： [root@aix220 /]#su - oracle [oracle@aix220 ~]$sqlplus '/as sysdba' SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 17 19:46:03 2015 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to an idle instance. SQL>

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

mysql blob：有什么限制吗？May 08, 2025 am 12:22 AM

mysqlblobshavelimits：tinyblob（255bytes），blob（65,535 bytes），中间布洛布（16,777,215个比例），andlongblob（4,294,967,967,295 bytes）.tousebl观察性：1）考虑performance impactsandSandStorelargeblobsextern; 2）管理backbackupsandreplication carecration; 3）usepathsinst

MySQL：自动化用户创建的最佳工具是什么？May 08, 2025 am 12:22 AM

自动化在MySQL中创建用户的最佳工具和技术包括：1.MySQLWorkbench，适用于小型到中型环境，易于使用但资源消耗大；2.Ansible，适用于多服务器环境，简单但学习曲线陡峭；3.自定义Python脚本，灵活但需确保脚本安全性；4.Puppet和Chef，适用于大规模环境，复杂但可扩展。选择时需考虑规模、学习曲线和集成需求。

mysql：我可以在斑点内搜索吗？May 08, 2025 am 12:20 AM

是的，YouCansearchInIdeAblobInMysqlusingsPecificteChniques.1）转换theblobtoautf-8StringWithConvertFunctionWithConvertFunctionandSearchusiseLike.2）forCompresseBlyblobs，useuncompresseblobs，useuncompressbeforeconversion.3）acpperformance impperformance imperformance imptactsanddataEccoding.4）

MySQL字符串数据类型：综合指南May 08, 2025 am 12:14 AM

mysqloffersvariousStringDatatYpes：1）charforfixed Lengtth Strings，IdealforConsistLengthDatalikeCountryCodes; 2）varcharforvariable长度长，合适的forfieldslikenames; 3）texttypefesforepesforlargertext，forforlargertext，goodforforblogblogpostsbutcan impactcuctcuctcuctpercrance; 4）biland;

掌握mysql blobs：逐步教程May 08, 2025 am 12:01 AM

TomasterMySQLBLOBs,followthesesteps:1)ChoosetheappropriateBLOBtype(TINYBLOB,BLOB,MEDIUMBLOB,LONGBLOB)basedondatasize.2)InsertdatausingLOAD_FILEforefficiency.3)Storefilereferencesinsteadoffilestoimproveperformance.4)UseDUMPFILEtoretrieveandsaveBLOBsco

MySQL中的BLOB数据类型：开发人员的详细概述May 07, 2025 pm 05:41 PM

blobdatatypesinmysqlareusedforvorvoringlargebinarydatalikeimagesoraudio.1）useblobtypes（tinyblobtolonglongblob）基于dondatasizeneeds。 2）库孔素pet petooptimize绩效。3）考虑Xternal Storage Forel Blob romana databasesizerIndimprovebackupe

如何将用户从命令行添加到MySQLMay 07, 2025 pm 05:01 PM

toadDuserStomySqlfromtheCommandline，loginasroot，thenusecreateuser'username'@'host'host'Indessifiedby'password'; tocreateanewuser.grantpermissionswithgrantprantallprivilegesondatabase

MySQL中有哪些不同的字符串数据类型？详细的概述May 07, 2025 pm 03:33 PM

mySqlofferSeightStringDatateTypes：char，varchar，二进制，二进制，varbinary，blob，文本，枚举，枚举和set.1）长度，理想的forconsistentDatatalIkeCountryCodes.2）varcharisvariable长度，长度，效率foriforitifforiticforiticforiticforiticforiticforitic forvaryingdatalikename.3）

See all articles