oracle登录12506,【案例】Oracle报错ORA-12560 sqlplus登录数据库时报错12560

news/2024/11/30 20:40:18/

天萃荷净

运维DBA反映，在sqlplus登录数据库时报错ORA-12560: TNS:protocol adapter error，分析原因为sqlplus版本导致

1.sqlplus登录数据库报ORA-12560

C:\Users\oracleplus>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Feb 14 23:33:31 2012

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

ERROR:

ORA-12560: TNS:protocol adapter error

Enter user-name:

ERROR:

ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

C:\Users\oracleplus>sqlplus -v

SQL*Plus: Release 11.2.0.2.0 Production

在这里发现sqlplus的版本信息不正确，我的数据库安装的11.2.0.1，这么怎么显示sqlplus是11.2.0.2，然后进入%ORACLE_HOME%/bin目录下面执行sqlplus，登录成功

C:\Users\oracleplus>cd e:\oracle\11_2_0\BIN

e:\oracle\11_

http://www.ppmy.cn/news/534217.html

UVA - 12506

Shortest Names 比赛时队友直接上的纯暴力，结果超时，我就想先排一下序，之后每次判断相邻的两个，实时更新每个字符串的喊出长度 #include <cstdio> #include <cstring> #include <iostream> #include <alg…

UVA12506 字典树简单应用

分析：构造字典树深搜采用刘汝佳的左儿子右兄弟的构树方式，节省了大量的空间。代码如下： #include <cstdio> #include <cmath> #include <cstring> using namespace std;typedef long long ll; const int maxn 1e610; i…

In a strange village, people have very long names. For example: aaaaa, bbb and abababab. You see, it’s very inconvenient to call a person, so people invented a good way: just call a preﬁx of the names. For example, if you want to call ‘aaaaa’, you can …