随笔分类 - database
摘要:create temporary tablespace user_temp tempfile 'C:\dmp\user_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; /*第2步:创建数据表空间 */ create tablespace TBS_RI...
阅读全文
摘要:1.启动数据库 客户端链接首先要打开监听sqlplus / as sysdba startup shutdown immediate alter user 用户名 identified by 密码; 启动、关闭监听lsnrctl start lsnrctl stop 2.连接远程服务器 conn y
阅读全文
摘要:首先搞清楚字符集和字符编码概念,了解oracle字符集原理,请参考一位大神的讲解: ref:http://blog.csdn.net/dbanote/article/details/9158367#comments 1. Oracle数据库服务器字符集:即Oracle以哪种字符编码存储字符 sele
阅读全文
摘要:1.首先下载ocilib到自己目录 github:https://github.com/vrogier/ocilib 2.在下载instantclient 11.2.2的文件: instantclient-basic-linux-11.2.0.3.0.zip instantclient-sdk-li
阅读全文
摘要:1、先检测系统是否自带原有版本mysql安装包,如果有要先卸载删除,不然不能成功安装和启动; rpm -qa|grep mysql yum remove mysql mysql-server mysql-libs compat-mysql51 注意这个代码,卸载不干净rm -rf /etc/my.c
阅读全文
摘要:参照前人一步一步操作: http://leihenzhimu.blog.51cto.com/3217508/1685164 遇到如下错误: This is a prerequisite condition to test whether sufficient total swap space is
阅读全文
摘要:1.redhat yum替换参考 url:http://blog.csdn.net/zcyhappy1314/article/details/17580943 2.yum卸载mysql rpm -qa|grep -i mysql yum remove mysql mysql-server mysql
阅读全文