oracle入门配置
oracle连接啥这么复杂啊.
oracle 10g
用ps/sql dev怎么也连不上.
用sqlplus可以登陆.net manager之前测试连接了成功的.现在搞得也连接不了.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\program\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 20090604-1449)(PORT = 1521))
)
)
------------------------------------------------------------
tnsnames.ora:
FIRSTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 5555))
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 6666))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = FirstDB)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
相关问答：
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
delphi 怎么将oracle的long raw 字段值 导入blob字段
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
看看这个
引用
vStream := TMemorySt ......
使用t-sql语句将sqlserver2k数据导入paradox的功能我已实现，用的是insert into ... from table in [ODBC][ODBC;Driver=SQL Server...]的办法，当我准备如法炮制完成paradox导入oracle时却不行，不报错但是执行后没� ......
oracle not available
shared memory realm does not exist
请问高手这个问题如何解决？
http://www.inthirties.com/thread-109-2-1.html
指定下ORACLE_SID,ORACLE_HOME看看，不行就用1楼得方法了..
cm ......
表记录
======================================
name date score
Fei Zhang 1 100
Fei Zhang ......
