Connected to an idle instance.2.连接到空闲实例，可能是数据库监听未启动，或者数据库未启动，先启监听，再启数据库。先查看监听状态 [oracle@localhost ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-JUL-2019 09:15:55 Copyright (c) 1991, 2011, Oracle. All rights...
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=lo...
Connected to an idle instance. SQL> startup ``` 其中,`startup`命令会默认尝试以标准方式启动数据库。 ### 关闭数据库 关闭数据库同样可以通过不同的方式实现。 1. **以oracle用户身份关闭:** ```bash ... orcale常用命令 Connected to an idle instance. SQL> startup^C SQL> startup...
Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 572043264 bytes Fixed Size 2215424 bytes Variable Size 171966976 bytes Database Buffers 390070272 bytes Redo Buffers 7790592 bytes Database mounted. Database opened. SQL> select instance_name from v$instance...
因root用户因不在dba组,显示权限不足,结果是正常的,但Oracle用户应该可以使用sysdba的身份登陆到数据库中,但却 显示:“Connected to an idle instance. ” ,即不能登陆到数据库中。但从操作系统中查看,使用网络连接方式,却可以连接。排除了tnsnames.ora配置错误,问题比较奇怪。
Connected to an idle instance. 解决办法: 1、进入到sqlplus启动实例 [root@oracle ~]#su - oracle--1.确认切换到oracle用户 Last login: Tue Sep 17 23:40:50 CST 2019 on pts/0 [oracle@oracle ~]$lsnrctl start--2.打开监听 LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 02-SEP-2019...
Connected to an idle instance. SQL> startup ORA-00845: MEMORY_TARGET not supported on this system SQL> 查找资料后发现在oracle 11g中新增的内存自动管理的参数MEMORY_TARGET,它能自动调整SGA和PGA。 这个特性需要用到/dev/shm共享文件系统,而且要求/dev/shm必须大于MEMORY_TARGET,如果/dev/shm比MEMORY_TARGET...
Connected to an idle instance. SQL> 可以理解为shutdown状态下的数据库为数据库的初始化状态,这个状态下可以将数据库启动到指定的状态上(除关闭状态之外的其他状态)。例如,将数据库启动到nomount状态 SQL>startup nomount ORACLE instance started.Total SystemGlobalArea1937457152bytesFixedSize2254464bytes ...
oracle启动时报Connected to an idle instance.0 版本11g,windows下连接oracle时,报错步骤如下: 1、sysdba连接 sqlplus / as sysdba 2、提示 Connected to an idle instance. 3、按照网上操作 startup 4、启动出错 ORA-00119: invalid specification for system parameter LOCAL_LISTENE ORA-00132: syntax ...
Connected to an idle instance. SYS@cdbp1> startup mount; ORACLE instance started. Total System Global Area 6876914832 bytes Fixed Size 9163920 bytes Variable Size 4311744512 bytes Database Buffers 2365587456 bytes Redo Buffers 190418944 bytes Database mounted. SYS@cdbp1> alter database archivelog; ...