Oracle 11g configuration resolves Ora errors that occur when the connection database is started _oracle

According to the online approach and combined with practice, to organize (forget to see later), Oracle login Problem Solution:

Common logon problems encountered when connecting to an Oracle database ora-12560,01034,27101,00119,00132, and so on, you can follow these steps to check and resolve.

ORACLE11G database monitoring, database startup

1. Add listener (server side)

Open Net Manager

Add listening

Add a listening location (network address)

Add Database Service (Oracle home directory can not fill)

2. Add Service naming

3, testing

Leverage server-side sqlplus tools E:\app\20483\product\11.2.0\dbhome_1\BIN\sqlplus.exe

Open cmd into the E:\app\20483\product\11.2.0\dbhome_1\BIN directory, input command Sqlplus/as SYSDBA;

Enter startup, if successful, the configuration is not a problem, if prompted ora-01034 27101 or ora-00119 00132, you need to follow the following procedure

1 cmd to server-side bin directory

C:\users\20483>e:

E:\>cde:\app\20483\product\11.2.0\dbhome_1\bin

E:\app\20483\product\11.2.0\dbhome_1\bin>

2) Login

E:\app\20483\product\11.2.0\dbhome_1\bin>sqlplus/as SYSDBA

Sql*plus:release 11.2.0.1.0 Productionon Wednesday December 21 10:56:26 2016

Copyright (c) 1982, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-64bit Production

With the partitioning, OLAP, Data miningand Real application testing options

Sql>

3) Start

Sql>startup

When you see the ora00119 and 00132 errors, follow the steps below

4) Modify Pfile

Pfile Location: E:\app\20483\admin\orcl\pfile\init.ora.9262015114632

Turn on the init.ora.9262015114632, find the Local_listener, and replace its value (the original value is called LISTENER_ORCL), and replace it with the Address_ in its own server-side Tnsnames.ora LIST (e.g. ORCL)

5) Create SPFile

6) sql>create spfile from pfile = ' E:\app\20483\admin\orcl\pfile\init.ora.9262015114632 '

7) Start

Sql>startup

At this point, you should see that the database started successfully.

4, configure the Client service name, configuration can use the Plsqldeveloper tool

The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.