- 博客(12)
- 资源 (4)
- 收藏
- 关注
翻译 启动与关闭数据库实例
3 数据库的启动和关闭这一章描述了启动和关闭Oracle数据库实例的规程,包含如下主题: 启动数据库 改变数据库的可用性 关闭数据库 停顿数据库 抑制和恢复数据库启动数据库当你启动一个数据库,你就创建了这个数据库的一个实例,并且决定了这个数据库的状态。通常情况下你通过挂载、打开来启动一个数据库使其对任何有效地用户连接、执行典型的数据访问操作都是可用的。其他存在的选项我们也将在本节中讨论。本节包含如下与启动数据库实例相关的主题:
2010-09-12 20:15:00 2703
原创 FreeRadius 1.1.7 + Postgresql 8.1.5 (FreeBSD 6.1系统)
一、gmake的安装[①] 1. 需要的文件 libiconv-1.11_1.tbz
2008-10-13 15:51:00 1451
转载 vmware server 保错
Accessing the console of a Windows virtual machine through Web Access in ESX 4.0 times outSymptomsYou cannot open the console of a Windows virtual machine through vSphere Client Web Access.Opening the console of a Windows virtual machine through vSphere We
2010-11-04 18:52:00 1140
转载 Active (Current) and Inactive Redo Log Files
Active (Current) and Inactive Redo Log Files<br />Oracle Database uses only one redo log files at a time to store redo records written from the redo log buffer. The redo log file that LGWR is actively writing to is called the current redo log file.<br />Re
2010-08-23 10:57:00 506
原创 Backing Up Control Files
SQL> alter database backup controlfile to trace;Database altered.SQL> @/u01/gettrcnameTRACE_FILE_NAME--------------------------------------------------------------------------------/u01/oracle/admin/stone/udump/stone_ora_8291.trc[oracle@localhost udump]$ m
2010-08-23 10:18:00 410
转载 control_files的修改方法比较
<br />修改CONTROL_FILES 实验<br />1.OCP教材上修改控制文件的方法<br />a.configure the control_files parameter<br />b.shutdown the database instance<br />c.copy the control file to new location<br />d.restart the instance<br />2.官方文档的方法<br />a.shutdown the database<br />b.c
2010-08-22 22:48:00 658
原创 alter system set control_files =
To add a multiplexed copy of the current control file or to rename a control file:Shut down the database.Copy an existing control file to a new location, using operating system commands.Edit the CONTROL_FILES parameter in the database initialization parame
2010-08-22 22:35:00 1540
原创 dispatcher
SQL> select name,network from v$dispatcher;NAME NETWORK---- --------------------------------------------------------------------------------------------------------------------------------D000 (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(POR
2010-08-21 17:26:00 365
原创 共享服务器进程对应得服务器进程是ora_s???_SID 吗?
<br />共享服务器进程对应得服务器进程是ora_s???_SID 吗?<br /> <br />SQL> show parameters shared_servers;<br />NAME TYPE VALUE<br />------------------------------------ ----------- ------------------------------<br />max_shared_servers
2010-08-21 08:29:00 340
原创 Shutting Down a Database
Shutting Down a Database<br />To initiate database shutdown, use the SQL*Plus SHUTDOWN command. Control is not returned to the session that initiates a database shutdown until shutdown is complete. Users who attempt connections while a shutdown is in progr
2010-08-16 23:49:00 1315
原创 不知道alter database close 有什么用?
不知道alter database close 有什么用?SQL> select status from v$instance;STATUS------------OPENSQL> alter database close;alter database close*ERROR at line 1:ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected##还有别的session,断掉之后再执行SQL> alter da
2010-08-16 22:58:00 1965
原创 在RedHat Linux上安装SM
安装步骤:1. mkdir /smsetup (下载SM_LEG.tar, SM_RHL.tar, eng3119.pqi三个文件)2. tar -zvxf SM_LEG.tar tar -zvxf SM_RHL.tar3. 手动更改 /etc/sysctl.conf ,增加如下两行kernel.shmmax = 1073741824
2008-10-13 16:09:00 896
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人