SQL> show parameter local_listener; value值貌似不对,对应的值为LISTENER_KSSYORCLPRD。 (3)解决方案: 但oracle的建议是:ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521). --方法1:修改local_listeener值为监听值 SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.110.48.2)(PORT...
启动报错:The listener supports no services The command completed successfully 原因:数据库实例没注册到listener 解决办法: 方法一(我所使用的方法): 1、登录到数据库: sqlplus / as sysdba startup 2、显示服务名: show parameter service 3、强制注册服务: alter system register; 注册后退出:quit 4、查看监听...
启动监听报错如下图所示: 远程连接报错如下图所示: 问题原因:数据库实例没注册到listener中 解决方法: (1)登录数据库:$sqlplus / as sysdba (2)显示服务名:sql>show parameter service_names; (3)强制注册服务:alter system register; (4)查看监听状态:lsnrctl status 注:如果数据库中有多个实例,通过export OR...
In some contexts, such as upgrades, "non-CDB" refers to a non-CDB from a previous release.Starting the Data Guard Command-Line InterfaceTo start the Data Guard command-line interface (DGMGRL), enter dgmgrl at the command-line prompt on a system where Oracle is installed. ...
Redhatlinux下安装oracle 10g 安装redhat5时要独立分配磁盘给SWAP,空间大小应该是内存大小*2,最好使用内存>1G的机器。 系统检查命令: # grep MemTotal /proc/meminfo ――检查内存大小 # grep SwapTotal /proc/meminfo ――检查交换分区大小swap # df -k /tmp ――要求/tmp 400MB ...
1. Enter the following commands to start the instance: 2. $ sqlplus /nolog 3. SQL> CONNECT SYS/sys_password as SYSDBA 4. SQL> STARTUP Stopping/Starting Oracle Net Listener 1. Enter the following command to stop the Oracle Net listener: ...
ORACLE_SID=orcl; export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin ; export PATH 修改后使用source /etc/profile或.bash_profile 命令使配置生效 11、设置安装语言设置 登陆oracle用户 因为中文安装会有乱码所以设置用英文安装 export LC_ALL=en_US
Oracle數據庫10gR2錯誤代碼TNS-01190 描述-The user is not authorized to execute the requested listener command。詳細的錯誤TNS-01190 會導致信息和操作建議。
Use the following commands to log in to and out of SQLcl. SQLCL [[option] [logon | / NOLOG] [start]] where option has the following syntax: -H[ELP] | -V[ERSION] | [ [-C[OMPATIBILITY] x.y[.z]]] [-L[OGON]] [-NOLOGINTIME] [-R[ESTRICT] {1 | 2 | 3}] [-S[ILEN...
解决:必杀技--打开"Windows任务管理器",杀死ORACLE.exe及ORADIM.exe进程,书写自己的ora_startup.bat,执行之! PS: 1、我的ora_startup.bat: net start OracleOraHome81TNSListener net start ORACLESERVICEORADB svrmgrl 一般情况下不用,不过有时少不了它的,具体步骤见第5步。