Solutions for ora-00119 and ora-00132 problems _oracle

Source: Internet
Author: User
Tags sqlplus

oracle11g after installation, cannot log on locally!
Prerequisite: The service all opens, the monitoring also configures well!

Win7 64-bit Oracle 11g

Simple SQL command:

log in to Sqlplus first: Sqlplus/nolog;

Login database:connsystem/managerassysdba;

then start the database:startup;

Found ora-00119 "ora-00119 Invalid specification for system parameter"

ora-00132 "syntax error or unresolved network name ' LISTENER_ORCL '":

Now, it seems perfectly understandable that 00119 of Oracle did not start!

Now here's a simpler one:

"Solution"

method ①: This way every time the computer restarts, you need to use the identity of SYSDBA to start the database;

Advantages: The ability to deepen the impression of the basic SQL of the key; disadvantages: trouble;

1. Find a folder: Pfile; Although each person installs Oracle's path is not the same, but in the installed directory will certainly find this folder!

Like my folder: D:\app\jamb008\admin\orcl\pfile

There is a file under this file: init.ora.1132014143422 He is actually pfile, used to launch Oracle's files!

2. Open it with WordPad, find Local_listener, then replace its value (the original value is called LISTENER_ORCL), replace it with the address_list in your Tnsnames.ora:

Then go back to cmd, execute: startuppfile= ' D:\app\jamb008\admin\orcl\pfile\init.ora.1132014143422 '

Log on again with Plsql: System Manager succeeded!!!

"Solution"

method ②: (online say what copy pfile to SPFile, etc., weak burst!!!!! Still use this "weak explosion" approach.

SYSDBA identity Log In

Sqlplus/nolog

Conn/assysdba

Create SPFile

Createspfilefrompfile= ' D:\app\jamb008\admin\orcl\pfile\init.ora.1132014143422 '

File is created

Here's a little note: oracle11g this file in: D:\app\jamb008\product\11.2.0\dbhome_1\database

Under 10g:d:\app\jamb008\product\11.2.0\dbhome_1\dbs;

Start again:

Startup

In this, we found that Oracle has successfully started, and then restart the computer, again with Plsql login, found directly into the database.

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.

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.