ora 02019 connection description for remote database not found

Label:First, install PL/SQL Developer: Https://yunpan.cn/cM3njKpfK8MnT access Password 996aSecond, re-install Instantclient_11_2: Https://yunpan.cn/cM3nYJv6KJg5V access Password c864After the download is complete, unzip to any disk, as follows:Open Network-->admin to find the following file:Edit as follows:dbname = (DESCRIPTION = ( address_list = ( ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.140) (PORT = 1521 )) (Connect_data =

1. Locate the Oracle installation directory, and then locate the Tnsnames.ora fileModify the relevant file contents:XE =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.107) (PORT = 1521))(Connect_data =(SERVER = dedicated)(service_name = XE)))Extproc_connection_data =(DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1)))(Connect_data =(SID = Plsextproc)(PRESENTATION = RO)))O

Tags: one point img OCA remote nbsp Class execution Command Description rooThe first method: more detailedThe following article mainly introduces the MySQL database to open the time of the remote connection operation process, in fact, the actual operation of the

password (random) is generated automatically during the installation of MySQL 5.7, so how do I change the root user password after the installation is complete? The steps are as follows:View the default password[Email protected] mysql]# Cat/root/.mysql_secretThe random password set for the root Userat Fri Jan 20:00:34 (local time): 3A) 2DdJLkcFPChange root password: Known default passwordLog in with the default password:[[email protected] mysql]#/usr/local/mysql/bin/mysql-uroot-p ' 3A) 2DdJLkcF

Oracle Database installation process is cumbersome, and uninstall more cumbersome, if the uninstallation is not clean, the next time you install Oracle will not succeed. Here's a way to remotely connect an Oracle database using the PLSQL Developer tool without having to install an Oracle client.First you need to download this software on the Oracle official website: INSTANTCLIENT-BASIC-WIN32. Then unzip, op

Tags: PL/SQL developer do not install client connection to remote Oracle databasePL/SQL Developer is an integrated development environment designed specifically for the development of Oracle Database storage program units. Now that more and more business logic and application logic has shifted to Oracle Server, PL/SQL programming has become an important part of t

. Excerpt one or two: [Mysqld]3306 Port =Basedir =/usrDataDir =/var/lib/mysqlTmpdir =/tmp# Instead of skip-networking The default is now-listen only# on localhost which are more compatible and are not less secure.Bind-address = 127.0.0.1 Note that in the above configuration file, there is a sentence for the configuration command: Bind-address = 127.0.0.1 This command indicates that the Ubuntu host is listening locally and processing only local

Site and Ucenter is not the same server connection method ~ I toss for several days, finally found this method! You can not connect to try ~ What is the only way to know what to do!Define (' Uc_connect ', ' MySQL ');d efine (' uc_dbhost ', ' Remote IP ');d efine (' Uc_dbuser ', ' a********1 ');d efine (' uc_dbpw ', ' 1** n ');d efine (' uc_dbname ', ' a*******1 '

When debugging with VS2010, such as error occurs:VS2010 Data Compare when creating a new connection, the server name chooses to use the remote database, and after clicking Test Connection, VS2010 crashes:Try to install VS2010, can not succeed, finally find network data found

: Nls_langVariable value: Simplified Chinese_china. Zhs16gbk3, modify Plsql Connection, open tool >preferences, can set oraclehome and OCI Library4. Start PlsqlIII. Oracle Client Offload1. Start-Settings-control Panel-management tools-services, stop all Oracle services.2. Start-Setup-Control Panel, uninstall Oracle client, and delete all the Oracle installation directory files.3. Delete \program Files\oracle Directory4. Run regedit, select Hkey_local_