完完全全的 database 菜鸟
已经装好了 Instant client,可以执行 sqlplus /nolog
,但是什么用户都无法添加。
实验课上老师用的是Windows 的 Oracle XE,sql
直接登陆了安装时候设置的用户,然后 create一组新的 user 和密码,然后start
一个 txt 文件就新建了 database,不知为什么我做不到。查了很多相关资料,运行下面的这些代码,一个都不行。
SQL> create t1 identified by tiger;
SP2-0640: Not connected
SQL> conn t1/tiger
ERROR:
ORA-12545: Connect failed because target host or object does not exist
SQL> create t1@localhost identified by tiger;
SP2-0640: Not connected
SQL> conn t1/tiger@localhost
ERROR:
ORA-12541: TNS:no listener
SQL> conn scott/tiger@orcl
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
配置文件如下
tsnnames.ora file
ORALOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora file
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
)
)