Solve several Oracle errors under the XP Virtual Machine

1. When the virtual machine installed, and then in the Virtual Machine Installed Oracle, when the next restart, encounter Oracle reported ora-12514 error, there are a lot of online solutions, this place to write a solution:

Open the file: % oracle_hoem %/Network/admin/listener. ora in
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(Program = EXTPROC)
)
Add:
(Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(Sid_name = Oracle)
)

Finally changed:
Sid_list_listener =
(Sid_list =
(Sid_desc =
(Sid_name = plsextproc)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(Program = EXTPROC)
) (Sid_desc =
(Global_dbname = Oracle)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(Sid_name = Oracle)
)
)

 

Idea: sid_name is the service name, and the idea is to modify its Oracle installation path

 

2. After this error, and then reported: ora-0134 error, the solution is as follows:

Enter the command line of the VM and start the database instance.

For example:

For example, CMD-> sqlplus/nolog
Conn sys/admin @ orcl as sysdba;
After login:
SQL> startup

After the instance is started, everything is normal. There are many reasons for such errors. If this is the case.