Oracle在修改参数后启动时报下列错误SYS@PROD >startupORA-00119: invalid specification for system parameter DISPATCHERSORA-00111: invalid attribute DISPPATCHERS&nbs
启动Oracle数据库时出现下列错误SYS@PROD>startupORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total Sys
在启动数据库时出现下列错误[oracle@edbjr2p1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon May 5 21:56:00 2014Copyright&n
1.登录数据库[oracle@edbjr2p1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Sun May 4 11:19:40 2014Copyright (c
1.关闭数据库SYS@PROD>shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.2.退出SYS@PROD>exitDisconnected from Oracle Database&nb
在执行该命令时出现下列错误SYS@PROD>alter system set UTL_FILE_DIR='/home/oracle','/home/oracle/temp','/home/oracle/scripts' scope=spfile;alter system set UTL_FILE_DIR='/home/or
当执行下列命令时出现ORA-12514错误[oracle@edbjr2p1 admin]$ sqlplus system/oracle@PRODSQL*Plus: Release 11.2.0.4.0 Production on Sat May 3 12:25:27 2014Co
1.创建目录[oracle@db1~]$ ~ $mkdir -p /u01/app/oracle/admin/orcl/wallet2.修改sqlnet.ora[oracle@db1~]$ ~ $cd /u01/app/oracle/product/11.1.0/db_1/network/admin/[oracle@db1~]$
1.备份[oracle@db1 ~]$ ps -ef | grep oracle | wc -l752.[oracle@db1 ~]$ sqlplus system/Oracle2013@orcl1SQL*Plus: Release 11.2.0.4.0&nb
1.创建表空间[oracle@db1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 18:50:03 2014Copyright (c)&nb
1.创建一个表空间SQL> create tablespace INVENTORY 2 datafile '/u01/app/oracle/oradata/orcl1/inventory01.dbf' 3 size 5M autoextend&n
1.登录数据库并查看undo表空间大小[oracle@db1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 18:11:48 2014Copyright
1.查看job_queue_processes参数[oracle@db1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Mon Apr 28 15:18:34 2014Cop
1.在EM中选择“Related Links">"Advisor Central" 2.单击“Automatic Undo Management"3.选择”Last Seven Days"4.查看分析出的结果5.单击“Edit Undo Tablespace"6.单击”Edit"7.输入要更改的大小&n
SQL> alter user sys identified by Oracle2013;User altered.
[oracle@db1 ~]$ emctl start dbconsole Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0 Copyright (c) 1996,&n
1.在浏览器输入网址，出现下列界面时点击”Add Exception"2.点击“Get Certificate" 3.点击”Confirm Security Exception“ 4.进入EM登录界面 5.输入用户名和密码 6.点击”Server“找到”Database Configuration
在创建数据库时出现下列错误解决方法：查看监听器的状态发现监听器没有启动，启动监听器错误消失
1.在命令提示符下执行dbca命令2.在弹出的下列界面中选择“Next”3.选择“Create a Database"然后单击”Next“4.选择“General Purpose or Transaction Processing"然后点击”Next“5.输入数据库的"Global Database Nam
当用oracle用户执行dbca时出现下列错误解决方法：再用oracle用户执行该命令问题解决！
1.在命令提示符中输入netca2.在弹出的欢迎界面中按如下选择3.选择"Add"后单击"Next"4.输入监听器的名称后，单击"Next"5.选择TCP协议后，单击"Next"6.选择标准的端口号，然后单击”Next"7.选择No,单击“Next"8.单击”Next“9.单击"Finsh"10.为新的数据库配置local naming (1)按下列选择好后单击”N
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号
