读书人

Linux下Oracle远程连接解决方法

发布时间: 2012-04-14 17:14:21 作者: rapoo

Linux下Oracle远程连接
Linux上安装了Oracle 10g
先问一个问题,
每次开机后直接 sqlplus 出现:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

然后我输入sqlplus sys/system as sysdba 然后可以直接进去,提示“只是一个暂时的实例”

这是什么机制?
2. 然后在键入startup 然后本机登录就可以了,
3.现在我需要在远程机器上进行登录,大概的配置了一下,如下 不知对不对,反正不能登录, 请各位指导指导~ 先谢谢了~
listener.ora

LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = TSH1)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.105)(PORT = 1521))
)
)

tnsnames.ora

# tnsnames.ora Network Configuration File: /usr/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

TSH1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TSH1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tsh1)
)
)


[解决办法]
  进入ORACLE_BASE/ORACLE_HOME/NETWORK/ADMIN下面找sqlnet.ora文件
  把
sqlnet.authentication_services=(NTS)
改成
  sqlnet.authentication_services=(NONE)

  然后手动重起一下你的哪个数据库服务..在开始->控制面板->管理工具->服务里然后把这个服务的启动帐号改成你的帐号

读书人网 >oracle

热点推荐