Oracle Database Learning Notes (i)

The following error occurred while connecting to the database (two libraries were created, one is ORCL and the other is prod):

 sql>  conn / as   sysdbaconnected  to   an idle instance. SQL  >   Startupora  - for   system parameter Local_listenerora   00132 : Syntax error or  unresolved Network name  " listener_prod   

According to the error, the general know is because prod this library monitoring out of the problem, Baidu! Online search for a lot of solutions, but the answer is mostly the same, in this simple summary: first find the database startup parameters configuration of the text file "Initprod.ora", generally in the directory "/u01/app/oracle/product/11.2.0/dbhome_1/ dbs/, and then change the parameters inside. Local_listener, after the change is as follows:

*. Local_listener='(address_list= (address= (protocol=tcp) (host=172.0.0.1) (port= 1521)))'

However, when I go to this folder, Found that there is no Initprod.ora file, but there is a file called Spfileprod.ora, here to explain the relationship between the two files, the two files contain the same meaning for the database, but the file at the beginning of init is a text file, can be edited with VI, the database management system in the creation of a library The time is not automatically generated ; sfile begins with a binary file that cannot be edited, and the system is automatically generated when the library is created . I opened the directory when I found no Initprod.ora file, so I entered Sqlplus enter the following command, generated a Initprod.ora file.

SQL>/ as to an idle instance. SQL>Create from spfile; File created.

Enter that directory again, edit the Initprod.ora, modify that parameter, and solve the problem.

Oracle Database Learning Notes (i)