sql>输入conn sys/as sysdba Enter password: connected SQL> 再次输入命令,正常
SQL> select * from v$version; SP2-0640: Not connected 解决方法: SQL> conn sys/ as sysdba; Enter password: Connected. SQL>
SP2-0640: Not connected 解决方法: SQL> conn sys/ as sysdba; Enter password: Connected. SQL>
Warning: You are no longer connected to ORACLE. SP2-0640: Not connected Cause The Oracle Listener process was not successfully created. This error indicates that the TNSNAMES.ora file was not created during the installation process. Specifying the local service will create a TNSNAMES.ora file ...
1.su - oracle 切换到oracle用户 lsnrctl status 查看数据库监听状态 lsnrctl start 打开数据库监听 2.Connected to an idle instance sqlplus /nolog执行之后 进去sqlplus 需要输入:startup 启动数据库实例 3.sp2-0640:not connected 接下来要输入:conn /as sysdba 或者coon sys,提示输入密码:as sysdba 连接到sysd...
SP2-0640: Not connected SQL> conn / as sysdba ERROR: ORA-09925: Message 9925 not found; product=RDBMS; facility=ORA Linux-x86_64 Error: 30: Read-only file system Additional information: 9925 ORA-01075: you are currently logged on
另外,在解决上述问题过程中,还出现了像如下一样的错误:SQL>conn sysSQL>show parameterSP2-0640:Not connectedSQL>conn/assysdbaERROR:ORA-09925:Message9925not found;product=RDBMS;facility=ORALinux-x86_64 Error:30:Read-only file system Additional information:9925ORA-01075:you are currently logged onSQL>...
然后再启动Oracle,即可以了。第二,在上面的过程中,还可能会碰到如ORA-09925:Unableto create audit trail file这样的问题,均于<ORACLE_BASE>有关,修改之即可。另外,在解决上述问题过程中,还出现了像如下一样的错误:SQL>conn sysSQL>show parameterSP2-0640:NotconnectedSQL>conn/assysdba...
The /NOLOG option starts SQLPlus without connecting to a database. /NOLOG选项表示启动SQLPlus但不连接数据库 [oracle@localhost~]$ sqlplus/nologSQL*Plus:Release11.2.0.1.0ProductiononTue May2810:41:102019Copyright(c)1982,2009,Oracle.Allrights reserved.SQL>selectuserfromdual;SP2-0640:NotconnectedSQL> ...
SP2-0640: Not connected //要进⾏连接，登录 SQL> conn /as sysdba Connected.SQL> select value from v$parameter where name='instance_name';VALUE --- htstandby2 ⼀、sqlplus /nolog登录⽅式 //为防⽌看到密码，直接⽤这种⽅式 [oracle@shdb02 expdir]$ sqlplus /nolog SQL*Plus: Release ...