- 博客(7)
- 收藏
- 关注
ORA-00845: MEMORY_TARGET not supported on this system
SQL> startupORA-00845: MEMORY_TARGET not supported on this system [oracle@host2 ~]$ df -h (查询磁盘空间占用情况)Filesystem Size Used Avail Use% Mounted on/dev/sda3 35G ...
2016-12-06 11:33:36
115
监听listener
监听的目录 : cd $ORACLE_HOME/network/admin (cd /u01/app/oracle/product/11.2.0/dbhome_1/network/admin)停止监听:lsnrctl stop启动监听:lsnrctl start监听状态:lsnrctl statusStatus命令显示监听器是不是活动的,日志与跟踪文件的位置,监听器已经...
2016-12-04 21:20:31
139
数据库启动的三种状态:nomount、mount、open
数据库启动的三个步骤:第一步:nomount 启动实例(分配内存(来源参数文件),启动后台进程,只要有参数文件)(如果参数文件被破坏或者丢失,数据库只能启动到nomount状态) SQL> startup nomountORACLE instance started. Total System Global Area 830930944 bytesFix...
2016-12-04 21:12:44
10835
手工建库
关闭现有数据库:SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.查看参数文件:[oracle@host2 dbs]$ cd $ORACLE_HOME/dbs[oracle@host2 dbs]$ lshc_ORA11GR2.dat in...
2016-12-04 20:51:18
144
ORA-28000: the account is locked
SQL> conn hr/hr (hr用户名/ hr 密码)ERROR:ORA-28000: the account is lockedWarning: You are no longer connected to ORACLE.解决方案:SQL> conn / as sysdbaConnected.SQL> alter user hr identified by hr ac...
2016-12-01 16:09:33
207
原创 安装tools
安装tools,解压到桌面:回到操作系统,将光驱挂载到/mnt下:mount /dev/cdrom /mntcd ~/Desktoptar -xzvf /mnt/VMwareTools-10.0.0-2977863.tar.gz[root@host Desktop]# cd vmware-tools-distrib/[root@host vmware-tools-di...
2016-12-01 16:00:22
266
原创 Vmware 安装tools
安装tools,解压到桌面:回到操作系统,将光驱挂载到/mnt下:mount /dev/cdrom /mntcd ~/Desktoptar -xzvf /mnt/VMwareTools-10.0.0-2977863.tar.gz[root@host Desktop]# cd vmware-tools-distrib/[root@host vmware-tools-di
2016-11-30 14:06:47
242
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人