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
