ORACLE的几点学习经验

最新推荐文章于 2024-11-14 05:45:52 发布

caoxiaohong

最新推荐文章于 2024-11-14 05:45:52 发布

阅读量557

点赞数

文章标签： oracle database session server date list

本文链接：https://blog.csdn.net/caoxiaohong/article/details/1917500

版权

常用的四个进程:
OracleOraHome90Agent
OracleOraHome90HTTPServer
OracleOraHome90TNSListener
OracleServiceOR90

修改日期格式：
SQL> alter session set nls_date_format='yyyy-mm-dd hh:mi:ss';

create public database link ANALYSE connect TO sa IDENTIFIED BY sa using 'ANALYSE';

select * from A_title@ANALYSE

要从网络入口进入时必须修改的两个文件:
D:/oracle/ora90/network/ADMIN
----TNSNAMES.ORA
ANALYSE=
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cxh)(PORT = 1521))
    )
    (CONNECT_DATA =
(SID = tg4msql)
(SERVER = DEDICATED)
    )
    (HS = OK )
)

-----LISTENER.ORA
    (SID_DESC =
      (GLOBAL_DBNAME = tg4msql)
      (ORACLE_HOME = c:/oracle/ora90)
      (SID_NAME = tg4msql)
      (PROGRAM = tg4msql)
    )