1、
sqlplus登陆:
create user ** identified by **(前为用户名/后为密码)
grant connect,resource to **(给你刚刚创建的用户授权)
2、
你的监听器服务没启动;
cmd>lsnrctl start;
sqlplus登陆:
create user ** identified by **(前为用户名/后为密码)
grant connect,resource to **(给你刚刚创建的用户授权)
2、
你的监听器服务没启动;
cmd>lsnrctl start;
SQL> create user a identified by a;(默认建在SYSTEM表空间下)
SQL> grant connect,resource to a;配置net8
系统参数文件为F:\oracle\ora92\network\admin\listener.ora
写入F:\oracle\ora92\network\log\listener.log的日志信息
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.2)(PORT=15
21)))
TNS-12545: 因目标主机或对象不存在,连接失败
TNS-12560: TNS: 协议适配器错误
TNS-00515: 因目标主机或对象不存在,连接失败
32-bit Windows Error: 49: Unknown error监听程序未能启动。请参阅上面的错误消息...
还有建立完用户后,怎么给这个用户设置密码吗?建用户以及密码不用写语句,直接在图形界面进行,可以吗?若可以,请问怎么操作?多谢了!
---------------------------------------------------------------
check your tnsnames.ora on the client , the section specified (same as the service name in your connection string) contains wrong content ( either IP or instance name)
make change by using net assistant
---------------------------------------------------------------
你写的服务名不能在服务器上的监听器上进行解析--
你写的服务名不能被服务器所识别。
检查一下你是不是写错了。
---------------------------------------------------------------
检查或重新配置net
NET配置全过程:
1.在'新的网络服务名'里随便填一个名字
2.一直点"下一步"
3."主机名"填你的服务器名字或它的ip地址
4."服务名"填 你要联的数据库名
5.测试一下,出现成功信息就行了
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = pgl-zfrtc2re0re)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库机器名或IP)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = 数据库SERVER_NAME)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = 数据库SID_NAME)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库机器名或IP)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库机器名或IP)(PORT = 2481))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = 数据库SERVER_NAME)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = 数据库SID_NAME)
)
)