A solution to a whole bunch of trouble problems with MySQL and Oracle

[INS-20802] Oracle Net Configuration Assistant failed

Baidu on the search for a half-day and did not find a reliable solution, finally can be installed to complete, after I



This error is reported through the SQL plus connection.
I found a solution on the internet again.
Use PL/SQL to connect and report this error

And then I tried to make a change to the Listener.ora file.


Test or not, and then I deleted the first line of code (program = Extproc) This line
Finally, I will report this mistake.
Restart the listening service every time you modify it.
And then use this solution: {
Username: Scott, the password is: Tiger, the host string is: TMT. But it always fails to log on, the report prompts Ora-12154tns Unable to resolve the specified connection identifier. Baidu, the original is my Tnsnames.ora file does not have the relevant configuration of TMT. Then add the following configuration to the Tnsnames.ora file:

TMT =

(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = ysgh6h9w2bxhoil) (PORT = 1521))
)
(Connect_data =
(service_name = TMT)
)
)
}

The specified SID already exists on this computer. Please specify a different SID

1, Start-> Settings-> Control Panel-> Administrative Tools-> Service stop all Oracle services.  
2, Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer Uninstall all Oracle products, but Universal Installer itself cannot be deleted  
5, run regedit, select Hkey_local_machine\software\oracle, and press Del to delete the entry.  
6, run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete all Oracle portals.  
7, run refedit,hkey_local_machine\system\currentcontrolset\services\eventlog\application, delete all Oracle portals.  
8, Start-> Settings-> Control Panel-> System-> Advanced-> Environment Variables Delete environment variables classpath and path in the settings for Oracle  
9, from the desktop, the Startup group, the Programs menu, Remove all group and icon   for Oracle,
10, delete \program Files\oracle directory  ,
11, restart the computer, and then completely remove the Oracle directory  
12. Delete the files associated with Oracle, select the default directory where Oracle is located C:\Oracle, delete the entry directory and all subdirectories, and remove the following files Oracle.ini, oradim73 from the C:\WINDOWS. INI, Oradim80. INI, Oraodbc.ini, and so on. 13, WIN. INI file if there is a [Oracle] Mark segment, delete the segment  
14, remove all Oracle-related ODBC dsn , if necessary,
15, to Event Viewer, delete the Oracle-related log Description: If there are individual DLL files can not be deleted, then ignore, restart, start a new installation, install, select a new directory, then, after installation and restart, the old directory and files can be deleted.

This article from Csdn Blog, reproduced please indicate the source: http://blog.csdn.net/quyanli123_126_com/archive/2009/02/27/3942917.aspx

Did you complete the uninstall process as follows??
1. Start-> Settings-> Control Panel-> Management Tool-> Service stop all Oracle services.
2. Start-> Program->oracle-orahome81->oracle installation products-> Universal Installer Uninstall all Oracle products, but Universal Installer itself cannot be deleted
5. Run regedit, select Hkey_local_machine\software\oracle, and press Del to delete this entry.
6. Run regedit, select HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services, scroll through this list, and delete all Oracle portals.
7. Run RefEdit, hkey_local_machine\system\currentcontrolset\services\eventlog\application, delete all Oracle portals.
8. Start-> Settings-> Control Panel-> System-> Advanced-> Environment Variables Delete environment variables classpath and path for Oracle settings
9. Remove all Oracle-related groups and icons from the desktop, Startup group, program menu
10. Delete \program Files\oracle Directory
11. Restart the computer to completely remove the Oracle Directory 12, delete the Oracle-related files, select the default directory where Oracle is located C:\Oracle, delete this entry directory and all subdirectories, and from the Windows 2000 directory (typically C:\WINNT), delete the following files Oracle.ini, Oradim73. INI, Oradim80.   INI, Oraodbc.ini, and so on. 13, WIN. INI file if there is a [ORACLE] tag segment, delete the segment
14. If necessary, delete all Oracle-related ODBC DSN
15, to the Event Viewer, delete the Oracle related log description: If there are individual DLL files can not be deleted, then ignore, restart, start a new installation, install, select a new directory, then, after installation and restart, the old directory and files can be deleted.

Oracle shutdown, start, and exit commands

Shutdown normal
Do not allow new connections, wait for the session to end, wait for the transaction to end, make a checkpoint, and close the data file. No instance recovery is required at startup.

Shutdown transactional
Do not allow new connections, do not wait for the session to end, wait for the transaction to end, make a checkpoint, and close the data file. No instance recovery is required at startup.

Shutdown immediate
Do not allow new connections, do not wait for the session to end, do not wait for the transaction to end, make a checkpoint, and close the data file. Transactions that do not end are automatically rollback. No instance recovery is required at startup.

Shutdown abort
Do not allow new connections, do not wait for the session to end, do not wait for the transaction to end, do not checkpoint, and do not close the data file. Automatic instance recovery on startup. Shutdown abort closes immediately. But the next time it starts, it's probably going to be a problem. Use with caution.

Summary

Login Database sqlplus/as sysbda
Close database shutdown immediate
Open Database startup
Exit the database exit

Mysql

2. An easy problem: when MySQL installs to the last step, the start service is in a failed state.

4. Workaround:

   Mode 1 MySQL installation is appearing could not start the service MySQL error:0 Prompt error, workaround: First, in the management tools--services to stop MySQL service, and then open cmd into your MySQL bin directory, such as C:\Program files\mysql\mysql Server 5.0\bin Then use the following command Mysqld-nt-remove and then it will show ... success! OK below go to add remove program, find MySQL Select Uninstall, remember to select Remove. Finally, the MySQL directory is deleted, and the database directory is also deleted

6. 17

   Mode 2

   Check the service for any MySQL, if any, to stop the service; Installation of MySQL 5.1.33, the third entry in the Execute Configurattion step when running the Server Instance Configuration Wizard error, error prompt is could not Start the service MySQL (this situation is usually caused by the installation of MySQL, the uninstallation is not clean.) Restart and reload after uninstalling. Note the service, if not uninstall, you can use Mysqld-nt-remove uninstall)

   Run add Remove Program in Control Panel to uninstall MySQL; After uninstalling, open the registry to view

   HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services under the key value, if there is the relevant MySQL key value (MySQL, mysqladmin) is deleted, you can;

   Restart, delete the MySQL installation remnants directory (view service, there is no MySQL in the service at this time); Reinstall MySQL. Do not run the Server Instance Configuration Wizard after installation, and then run the wizard in the Start menu after the reboot to

A solution to a whole bunch of trouble problems with MySQL and Oracle