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.