Oracle Database -- configure remote connection on the server

Preface

We use Oracle databases for Project names. In terms of query and modification, there is no problem with SQL Server. However, we are new to users and are unfamiliar with it. For example, to create a tablespace and create a user, we also need to grant permissions to the user.

I am using PL/SQL. After using these days, I feel that the permission granted by Oracle is really powerful. I vaguely remember that when I was dealing with an FTP server, I had to pay a huge discount for permission control. The powerful feature is cascading deletion. When using SqlServer, you also need to write a trigger to implement it. Oracle only needs to implement it in one sentence, which makes people feel powerful.

However, behind the power is its tedious steps.

We developed our cooperation, and the database was installed on my computer. The other two people only installed PL/SQL. Oracle remote connection, Unlike SQL Server, is used to input an IP address on the login interface. When you search for it, someone will teach you how to remotely connect to the database using PL/SQL.

Here, I am just giving you a connection. It is also a virtue to recommend other people's blogs. You can use PLSQL to remotely connect to the database (ORACLE database is not installed on the local machine)

Problem description

If it is over, this blog will not be published.

The problem is that no matter how configured it is, it means that the login fails. I called the user who wrote this blog to get the result, but it still didn't work. Later, I used this method to remotely access other users' points, yes, so I started to point the finger at the server.

I thought there were missing options in the installation process. So I found an installation tutorial and looked at it. It was almost the next step. Even if there was a setup, it was not something like setting a listener, so there is no reinstallation (I use ORACLE 11G, if it is 10G, it may not have this problem ).

So I started my experiment and found tnsnames. ora under "oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. I changed the localhost to my own IP address and found that it was not feasible. So I decided that the source of the problem was my database.

Solutions

Note: If the remote connection to SqlServer is unavailable, it can be configured. First, check the firewall. Second, you can find an article on the Internet about ORACLE remote connection configuration server.

Solution

Remote Server Configuration:

1. Database Configuration (this is not my mistake)

Configure the database operation mode to "Shared Service Mode". If you are not sure about the database operation mode, you can enable

Configure Database options in the database of the "DatabaseConfiguration Assistant" tool.

2. Database Service

Open the database service ). Run the command Han Gang and enter services. msc to check whether the Oracle service is enabled.

3. Listening Program (I encountered a problem in this link)

Make sure the database has been attached to the listener and the listener is enabled.

My Database Listener is opened, but the database is not included in the listener. The method is: Find your listener in net manager, and then

Add the server name and Oracle_home path to the database.

Save and restart the listening server.

4. Network Status

Make sure that the port used by the listener has been listed as permitted by the firewall. (This is a bit strange to us, firewall, and I usually

Close all ....)

Feelings

Now, the server has been set up. Can someone connect to you? Do you have to wait until such a tragedy happens before you know that you are reflecting on yourself? If you can test it earlier, it will not delay some people's time.

The test method is very simple, that is, to open the command line and use the "tnsping Server IP Address". If the ping is successful, it means that someone else on your server can remotely access it, you can safely allow others to remotely access your database.

Written at the end

I have taken a preliminary look at the Oracle database tutorial. At present, the knowledge of Oracle databases is still a bit small and has not been fully migrated to SqlServer. However, I believe you only need to learn a little, just migrate a little to what you have learned. It's not big to learn.

Ps: the permissions in our system have been changed, but I still want to implement the permissions. So if I leave it blank, I will knock on the Demo and upload a complete code example ~~

Remotely connect to the server using Oracle Instant Client in Linux