Question

PLSQL怎么创建oracle数据库用户

Answer 1

首先下个客户端,路径放在如下
D:\oracleDataBase\app\oracle\product\11.2.0\instantclient_10_2

然后,在D:\oracleDataBase\app\oracle\product\11.2.0\instantclient_10_2\network\ADMIN
该路径下,找到tnsnames.ora.bak.然后给你贴配置,不会只能说贴主low,下面是我几个数据库的配置,其中第一个是本地的

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)