CENTOS7 Mini after installing Oracle with PL/SQL connection database

1, the original is installed after the database, local can access, and WIN10 under the Oracle Client configuration Oracle Net Manager Times Connection Timeout

Workaround:

This connection timed out, let me think of telnet connection problem, just use Telnet test, connection is denied

The Telnet and Telnet service is then installed, and the CentOS default firewall is firewall not iptables, so turn off Firewwall, install iptables, and turn on port 23

Operation Method can refer to

2, Telnet connectivity, and then in the Oracle Net Manager Test connection database, reported the connection string error, this thought and the last resolution error, the deletion of monitoring, reconfigure monitoring, restart the system, or not

Workaround:

Open and edit the file Listener.ora under the oracle_home/network/admin/path, my local file is as follows (I feel this error is caused by the environment variable is not configured properly)

 # Listener.ora Network Configuration File:/opt/oracle/product/11gr2/network/admin/ listener.ora# Generated by Oracle configuration tools. Sid_list_listener  = (sid_list  = sid_ DESC  = (sid_name  = ORCL) (Oracle_ HOME  =/opt/oracle/product/11gr2)) LISTENER  = (description_list  = (DESCRIPTION  = (A ddress  = (PROTOCOL = TCP) (HOST = 192.168 . ) (PORT = 1521  ))) Adr_base_ LISTENER  =/opt/oracle 

This file changed, and the Tnsnames.ora file in localhost changed to local IP, I do not know whether this has played a role, anyway changed is also true

# Tnsnames.ora Network Configuration File:/opt/oracle/product/11gr2/network/admin/=  =      192.168. 36.133 1521 ))) (= dedicated      )= orcl   )))           

After modifying these, stop listening and start monitoring

[[email protected] root]$ lsnrctl stop[[email protected] root]$ lsnrctl start

3. Using Oracle Net Manager to test connection database, error

Ora-01034:oracle Not available

Ora-27101:shared Memory realm does not exist linux-x8

Workaround:

CENTOS7 Native System Oracle User login, connect to Database

[Email protected] ~]$ sqlplus/nologsql> Conn/as Sysdbasql> Startup

If the startup is already started, close and then start

sql> shutdown Immediatesql> Startup

CENTOS7 Mini after installing Oracle with PL/SQL connection database