Parkhomets Andrey
Дата: 30.05.2006 20:52:30
Я чего то не пойму.... что сделал не так ?
pts/1 oracle@raclinux1:/>tnsping SID_DB_ALIAS
TNS Ping Utility for Linux: Version 9.2.0.7.0 - Production on 30-MAY-2006 19:38:57
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/u01/app/oracle/product/9.2/client/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
)SERVICE_NAME = oradb) = TCP)(HOST = 10.10.0.15)(PORT = 1521))
OK (10 msec)
19:38 Tue May 30 EEST
-- после этого
pts/1 oracle@raclinux1:/>sqlplus /nolog
SQL*Plus: Release 9.2.0.7.0 - Production on Tue May 30 19:40:48 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys@SID_DB_ALIAS as sysdba
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name
--смотри сюда :
pts/1 oracle@raclinux1:/>less $TNS_ADMIN/sqlnet.ora
# SQLNET.ORA Network Configuration File: /u01/app/oracle/product/9.2/client/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
-- т.е. пусто
--смотрим дальше:
pts/1 oracle@raclinux1:/>whoami
oracle
-- переменные
pts/1 oracle@raclinux1:/>set | grep ORA
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/9.2/client
ORACLE_TERM=xterm
ORA_NLS33=/u01/app/oracle/product/9.2/client/ocommon/nls/admin/data
pts/1 oracle@raclinux1:/>set | grep TNS
TNS_ADMIN=/u01/app/oracle/product/9.2/client/network/admin
pts/1 oracle@raclinux1:/>set | grep PATH
CLASSPATH=/u01/app/oracle/product/9.2/client/JRE:/u01/app/oracle/product/9.2/client/jlib:/u01/app/oracle/product/9.2/client/rdbms/jlib:/u01/app/oracle/product/9.2/client/network/jlib
LD_LIBRARY_PATH=/u01/app/oracle/product/9.2/client/lib:/lib:/usr/lib:/usr/local/lib
PATH=/u01/app/oracle/product/9.2/client/bin
-- Это всё на RH 4.0 ( тока что поставил)