日期:2014-05-16  浏览次数:20616 次

Linux下oracle安装完毕 连接PL/SQL

安装完毕
测试:
sqlplus /nolog
conn /as sysdba
startup

?

create user xxx identified by xxx;

grant connect,resource,dba to xxx;

?

配置远程PL sqlplus:修改 OracleXEUniv\app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsnames.ora
改 名字 和IP

nontax_162=
? (DESCRIPTION =
??? (ADDRESS_LIST =
????? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.162)(PORT = 1521))
??? )
??? (CONNECT_DATA =
????? (SERVICE_NAME = orcl)
??? )
? )

监听器启动:lsnrctl start