Oracle 11g configuration solves the ora error that occurs when starting to connect to the database

According to online methods and combined with practice, I sorted it out (if you forget it in the future, you can take a look), the solution to the oracle login problem:

Common problems encountered when logging in to connect to the oracle database ora -12560,01034,27101,00119,00132, etc., can be checked and solved by following the steps below.

Oracle11g database monitoring, database startup

1. Add the listening program (server side)

Open net manager

Add monitoring

Add monitoring location (network address)

Add database service (oracle home directory can be left blank )

2. Add service naming

3. Test

Use the server-side sqlplus tool E:\app\20483\product\11.2.0\dbhome_1\BIN\sqlplus.exe

Open cmd and enter the E:\app\20483\product\11.2.0\dbhome_1\BIN directory and enter the command sqlplus / as sysdba;

Enter startup. If it succeeds, it means that there is no problem with the configuration; if it prompts ora-01034 27101 or ora-00119 00132, you need to do as follows

1) cmd to the server Under the 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, 2010, 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) Startup

SQL>startup

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

4 )Modify pfile

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

Open init.ora.9262015114632, find local_listener, and then change it Replace the value (the original value is LISTENER_ORCL) and replace it with ADDRESS_LIST (such as orcl) in your own server-side tnsnames.ora

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, it should be OK See that the database started successfully.

4. Configure the client service name. After configuration, you can use the plsqldeveloper tool

The above is the entire content of this article. I hope it will be helpful to everyone's learning. I also hope that everyone will support the PHP Chinese website. .

For more oracle 11g configuration to solve the ora error that occurs when starting to connect to the database, please pay attention to the PHP Chinese website for related articles!