ITPub博客

1、查看集群状态:[root@rac1 ~]# su - grid[grid@rac1 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online2、数据库实例状态：[grid@rac1 ~]$ srvctl status database -d yoonInstance...

OS:Oracle Linux Server release 5.7DB:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production在测试环...

系统版本：[root@yoon ~]# more /etc/oracle-releaseOracle Linux Server release 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLS...

系统版本：[root@yoon ~]# more /etc/oracle-releaseOracle Linux Server release 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLS...

1、环境信息：系统：oracle-linux 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production 主库：192.1...

操作系统:Oracle Linux Server release 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production...

oracle11g-11.2.0.3.0 - 64bitoracle-11g创建用户名的时候默认区分大小写

1、oracle内存结构:sga + pga ;2、oracle数据库体系结构:3、oracle工作原理:a.在数据库服务器上启动oracle实例;b.应用程序在客户端的用户进程中运行,启动oralce网络服务驱动器与服务器创建连接;c.服务器运行oralce网络服务驱动器,创建专用的服务器进程执行用户进程;d.客户端提交事务;...

系统版本:Oracle Linux Server release 5.7数据库版本：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 - Production...

SQL> create pfile from spfile;修改pfile文件，添加隐含参数 *._enable_rename_user='TRUE'，将数据库以restrict方式启动1、[oracle@yoon ~]$ cd /u01/app/oracle/product/11.2.0/db1/dbs/2、[oracle@yoon dbs]$ lshc_yoon.dat init.ora inityoon.ora lkYOON orapwyoon snapcf_yoon.f spfileyoon.o...

挂载镜像：mkdir /media/diskmount /dev/cdrom /media/disk安装oracle-linux依赖的所有包：vi /etc/yum.repos.d/public-yum-el5.repo[oel5]name = Enterprise Linux 5.7 DVDbaseurl=file:///media/disk/Server/gpgcheck=0enabled=1yum install oracle-validated --执行并安装依赖的包修改hosts，配置域...