读书人

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

发布时间: 2012-09-28 00:03:35 作者: rapoo

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

读书人网 >UNIXLINUX

热点推荐