17,377
社区成员
发帖
与我相关
我的任务
分享
# sqlnet.ora Network Configuration File: E:\app\lzy23\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES)
ADR_BASE = E:\app\lzy23
# listener.ora Network Configuration File: E:\app\lzy23\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app\lzy23\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app\lzy23\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Lzyyyyy)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = E:\app\lzy23
# tnsnames.ora Network Configuration File: E:\app\lzy23\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
GMYKYY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.10)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
:: 设置环境变量运行PB
:: 关闭终端回显
@echo off
:: 现环境变量输出
set Env_Path=%PATH%
set TNS=%TNS_ADMIN%
set ORA=%ORACLE_HOME%
@echo ====元环境变量====
@echo TNS:%TNS%
@echo ORA_BIN:%ORA%
@echo Path:%Env_Path%
:: 改变环境变量.仅为当前的环境 并未永久改变.
set TNS=D:\Oracle\product\11.2.0\client_1\network\admin
set ORA=D:\Oracle\product\11.2.0\client_1
set Env_Path=D:\Oracle\product\11.2.0\client_1\bin;%PATH%
@echo
@echo ====局部环境变量设置====
@echo TNS:%TNS%
@echo ORA_BIN:%ORA%
@echo Path:%Env_Path%
@echo
@echo ====局部环境运行PB====
set TNS_ADMIN=%TNS%
set ORACLE_HOME=%ORA%
set PATH=%Env_Path%
@echo TNS_ADMIN:%TNS_ADMIN%
@echo ORACLE_HOME:%ORACLE_HOME%
@echo PATH:%PATH%
start "" "D:\Sybase\PowerBuilder 9.0\pb90.exe"
pause