Oracle11g create database error, please address ORA - 00119, ORA - 00132 error, as shown in figure-CodePudding

I also used the method of online or not,

1, I found my database without initSID. Ora file

CodePudding user response:

The

refer to the original poster czplplp_900725 response:

Actually I also don't know way, but you can have a try,

Modify/... Oracle/product/10.2.0/network/admin/tnsnames. Ora file, add the following statement:

LISTENER_CZPTEST=

(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC0))

CodePudding user response:

1, I found my database without initSID. Ora file

Explain: Windows in the system database startup parameter file under the ORACLE_HOME \ database,
Will according to the priority for the following files: spfile {SID}. Ora & gt; Spfile. Ora & gt; Init {SID}. Ora,

11 g is created by default spfile {SID}. Ora, but can't manually change this file, but you can consider to open this file, paste the inside can identify parts, save for the init {SID}. Ora, then put the spfile *. Ora, delete the init this is can manually change,

If it is a Linux or Unix systems, parameter files are located in $ORACLE_HOME/DBS,

CodePudding user response:

reference 1st floor zlloct response:

Quote: refer to the original poster czplplp_900725 response:

Actually I also don't know way, but you can have a try,

Modify/... Oracle/product/10.2.0/network/admin/tnsnames. Ora file, add the following statement:

LISTENER_CZPTEST=

(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC0))

I'm afraid this should be added in the listener. Ora,

CodePudding user response:

Before building the listener,

CodePudding user response:

Is not as clean as the other versions of the oracle data files to delete

CodePudding user response:

You can ignore the installation is complete, and then view the local_listener parameter in the database, if this parameter is not, you need to ', if you are the expected parameters, it is need to modify the tnsnames. Ora file configuration, specific please refer to: https://blog.csdn.net/tianlesoftware/article/details/6087045