Skip to content

Commit f062c8c

Browse files
committed
update DB*
1 parent a6c6123 commit f062c8c

File tree

1 file changed

+9
-7
lines changed

1 file changed

+9
-7
lines changed

DB学习之路.md

Lines changed: 9 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -80,6 +80,11 @@
8080
* Database Error Messages: http://docs.oracle.com/cd/B28359_01/server.111/b28278/toc.htm
8181
* 3 Starting Up and Shutting Down: http://docs.oracle.com/database/121/ADMIN/start.htm
8282
* 5 Introduction to LOBs: http://docs.oracle.com/cd/B10500_01/appdev.920/a96583/cci05lob.htm
83+
* E Managing Oracle Database Port Numbers: http://docs.oracle.com/cd/B19306_01/install.102/b15667/app_port.htm
84+
* Configuring the Operating System Environment Variables: http://docs.oracle.com/database/121/ADMQS/GUID-EC18C4A6-3BA5-4C14-9D76-B0DD62FEFFF2.htm#ADMQS12369
85+
* 1 Administering Oracle Database: http://docs.oracle.com/database/121/UNXAR/admin_ora.htm#UNXAR001
86+
* 9 Managing Diagnostic Data: http://docs.oracle.com/database/121/ADMIN/diag.htm#ADMIN11007
87+
* 12 Managing Archived Redo Log Files: http://docs.oracle.com/database/121/ADMIN/archredo.htm#ADMIN008
8388

8489
* Oracle SQL Developer: http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
8590
* Instant Client Downloads for Microsoft Windows (32-bit): http://www.oracle.com/technetwork/topics/winsoft-085727.html
@@ -103,6 +108,9 @@
103108
* 【Foreign Key】Oracle外键约束三种删除行为 : http://blog.itpub.net/519536/viewspace-630034/
104109
* Oracle导入JAR包并调用Java: http://www.jianshu.com/p/4280ac298ded
105110
* Reclaiming Unused LOB Space: http://www.idevelopment.info/data/Oracle/DBA_tips/LOBs/LOBS_85.shtml
111+
* sqlplus 汉字乱码问题的解决: http://blog.csdn.net/tianlesoftware/article/details/5224448
112+
* Oracle 10g: Issue with startup mount command (ORA-24324, ORA-01041): http://stackoverflow.com/questions/12470893/oracle-10g-issue-with-startup-mount-command-ora-24324-ora-01041
113+
* 你所不知道的OERR: http://blog.163.com/jet_it_life/blog/static/2050970832012320146595/
106114

107115

108116
## PL/SQL Developer
@@ -124,7 +132,7 @@ windows Server 2008 服务器上安装了Oracle 11g R2,在用Navicat去连接O
124132

125133
* 在上述地址中下载文件:instantclient-basic-nt-12.1.0.2.0.zip,
126134
* 解压此安装包至:D:/app/administrator/product/instantclient_2_2_x32
127-
* 打开Navicat,选择工具→选项→其他→OCI,然后设置OCI library为:D:app/administrator/product/instantclient_12_2_x32/oci.dll,设置SQL *plus为:D:/app/administrator/product/11.2.0/dbhome_1/BIN/sqlplus.exe。确定。
135+
* 打开Navicat,选择工具→选项→其他→OCI,然后设置OCI library为:D:app/administrator/product/instantclient_12_2_x32/oci.dll,设置SQL plus为:D:/app/administrator/product/11.2.0/dbhome_1/BIN/sqlplus.exe。确定。
128136
* 测试成功。
129137

130138

@@ -208,12 +216,6 @@ Oracle客户端 需要安装配置 不用安装
208216
jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))
209217
```
210218

211-
## 与 oracle 有关的几个端口:1158、1521、5500、5560
212-
213-
* 1521端口:响应sqlplus
214-
* 1158端口:http://RemoteIP:1158/em,即通过网页方式访问em
215-
* 5560端口:http://RemoteIP:5560/isqlplus,即通过网页方式访问sqlplus
216-
217219
## Oracle 11g服务详细介绍及哪些服务是必须开启的?
218220

219221
成功安装Oracle 11g后,共有7个服务,这七个服务的含义分别为:

0 commit comments

Comments
 (0)