Remote connection reports ORA-12547 after Oracle is installed

Source: Internet
Author: User

I. Error code: ORA-12547
Symptoms:
(1) Oracle listening and Service Startup are normal and no error is reported
(2) Check the log without any exception information
(3) The local commands on the server can connect to oracle and execute query commands.
(4) The customer service machine cannot be connected, error ORA-12547

Solution: Modify three files:
(1) Modify/etc/hosts as follows:

127.0.0.1 localhost. localdomain localhost
: 1 localhost6.localdomain6 localhost6
192.168.1.168 your_hostname.com your_hostname

(2) listener. ora (Note: need to modify to the following content, otherwise the error will be reported: ORA-12514)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(ORACLE_HOME =/opt/oracle/product/10g)
(SID_NAME = ORCL)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME =/opt/oracle/product/10g)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
(ADDRESS = (PROTOCOL = TCP) (HOST = your_hostname.com) (PORT = 1521 ))
)
)


(3) tnsnames. ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = your_hostname.com) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1 ))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


2. Error code: ORA-01034 ORA-27101

Check the following three items:
(1) Whether the environment variable oracle_sid is consistent with the settings in the listener
(2) check whether the environment oracle_home is consistent with the settings in the listener.
(3) Whether the memory and disk space are sufficient (for example, the disk space in the oracle partition may be insufficient)


Others: if all of the above are normal, restarting oracle still cannot solve the problem,

Note that the following methods are used to start oracle: sqlplus '/as sysdba'

Instead of (1) sqlplus/nolog (2) connect/as sysdba

Do not use shutdown abort when closing oracle; it is best to use shutdown immediate;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.