cool hit counter oracle Series - Part 5 PLSQL Connecting to a Local Oracle Database_Intefrankly

oracle Series - Part 5 PLSQL Connecting to a Local Oracle Database


This blog is mainly for newbies, and I'm a newbie :)

We have successfully installed oracle on our computer, so how can we connect PLSQL developer to

What about connecting to a local oracle?

First, we must have the following steps to prepare.

1.Installing Oracle

2.Install PLSQL developer

Here's how to get PLSQL developer to connect to an oracle database

Select: Net Configuration Assistant (indicated by the red box)

launch

Click Next

Click Next

The name can be any, click on the next step

Click Next

Click Next

Click Next

Click Next

Click Next

Select the local Net service name configuration and click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click Next

Click the Finish button

Start PLSQL with database selected as: ORACT

Connection successful!

Eat ......

Additional.

It can be in your oracle installation directory, mine is: F:oracleproduct10.2.0db_1NETWORKADMIN

Find the file: tnsnames.ora

 1 # tnsnames.ora Network Configuration File: F:oracleproduct10.2.0db_1
etworkadmin	nsnames.ora
 2 # Generated by Oracle configuration tools.
 3 
 4 ORACT =
 5   (DESCRIPTION =
 6     (ADDRESS_LIST =
 7       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
 8     )
 9     (CONNECT_DATA =
10       (SERVICE_NAME = oract)
11     )
12   )
13 
14 EXTPROC_CONNECTION_DATA =
15   (DESCRIPTION =
16     (ADDRESS_LIST =
17       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
18     )
19     (CONNECT_DATA =
20       (SID = PLSExtProc)
21       (PRESENTATION = RO)
22     )
23   )

As you can see, the information you just configured can be found here.

E | hongtenzone@foxmail.com B |http://www.cnblogs.com/hongten


Recommended>>
1、Centos7 offline installation of ClouderaManager 5141
2、Where are the algorithms that replace the invisible hand in the P2P market
3、Android Dependency Server Nexus
4、Redis Distributed Cluster Architecture Configuration
5、HDU1005NumberSequence matrix

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号