After connecting to oracle error "ORA-28547: connectiontoserverfailed, probableappslenetadmin solution,

After connecting to oracle error "ORA-28547: connectiontoserverfailed, probableappslenetadmin solution,

Listener. ora is the oracle configuration file on the server.

Then, comment out this line of listener. ora, and (PROGRAM = extproc)

To:

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = prod)

(ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1)

# (PROGRAM = extproc)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.8) (PORT = 1522 ))

(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC0 ))

)

)

The second solution is as follows:

References: https://forums.oracle.com/forums/message.jspa? MessageID = 693607

As follows:

The configuration in the client configuration file sqlnet. ora is as follows:

Comment out # SQLNET. AUTHENTICATION_SERVICES = (CNT) and change it to the following!

As follows:

SQLNET. AUTHENTICATION_SERVICES = (NONE)

Modify the listener Configuration file at the same time. The specific method is to search for listener in the oracle installation directory. ora file, usually in the $/NETWORK/ADMIN directory, replace the HOST name with an ip address, for example (ADDRESS = (PROTOCOL = TCP) (HOST = HBONLINE1) (PORT = 1523 )) change to (ADDRESS = (PROTOCOL = TCP) (HOST = 168.168.168.42) (PORT = 1523 )).

Solution 3:

If you are using plsql developer or toad, the above operations can definitely solve your problem,

However, if you are using the navicat tool, these problems cannot be solved. If you use the navicat tool, the following issues occur:

Oracle is basically installed by default, and there is no exception during the installation process

Oracle has enabled two services: OracleServiceORCL and OracleOraDb11g_home1TNSListener.

Navicat cannot connect to the local Oracle

I searched a lot of information on the Internet, and most of them changed the three configuration files.

The problem still cannot be solved.

The final problem is:

If the local IP address (192.168.18.8) is entered in the Navicat host, the error code is: ORA-12541: TNS: no listener

If localhost is entered, the error code is: ORA-28547: connection to server failed, probable Oracle Net admin error

Tnsping localhost is through, tnsping 192.168.18.8 then error TNS-12541: TNS: No listener

The solution is:

The oci. dll version is incorrect.

Download client

There are many of them. According to your version, I downloaded instantclient_11_1.

In navicat's tool-Option-other-OCI, select oci. dll from the client

Set environment variables:

1) add C: \ Instantclient10_2 in the environment variable PATH;

2) Add the user environment variable SQLPATH with the value of C: \ Instantclient10_2.

3) Add the user environment variable NLS_LANG with the value AMERICAN_AMERICA.UTF8.

Select Basic connection, and you will probably be connected.

The preceding operations can be checked as follows:

Search:

1. First confirm that your database has been started. You can use net start OracleServiceORCL

2. Check whether your listener has been started. Use lsnrctl status to check whether the listener has been started. If not, use lsnrctl start to start the listener.

3. After the above is started, open sqlplus directly and enter the user name and password. you can log on directly without entering the service name.