connect to oracle database from excel macro

Oracle database installed on the Ali Cloud, one day received the following alerts:Name=atabasenameType=database InstanceHost=izw2519p6r9uzeeeMetric=statusTimestamp=nov, 2014 4:16:37 AM CSTSeverity=criticalmessage=failed to connect to database Instance:ora-12519:tns:no approp

During previous Oracle use, when the client was connected to the server, the Tnsnames.ora file in the client was configured as follows:= = = = = = 192.168 . 1.150 = 1521 )))) ()))) But today I accidentally learned from colleagues that a way to directly access a database without configuring this content is to use the following command when Sqlplus a connection:C:\Users\Administrator>S

Label:1. Tools: Download Oracle Client Address:Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html such asSelect the corresponding version,Http://www.oracle.com/technetwork/topics/winsoft-085727.html find the corresponding version, download.Download Plsql Developer: Just a search, you can download it.2. After installing Plsql Developer, open the Plsql, asThe configuration me

Recently I am working on a small project using spring + hibernat. I just learned how to do it.I often encounter some minor problems. This time I used DB browser in myeclipse to connect to the Oracle database. Below is the source image of my problem: 1. New connection to Oracle, 1: 2.

Recently in doing a small project using Spring+hibernat, I was just learning, while learning to do it.There are a lot of minor problems, this time using DB browser in MyEclipse to connect to the Oracle database. Here are the original artwork of my problem: 1. Create a new connection to Oracle, as shown in Figure 1:

oracle| Data | The database first finds Tnsnames.ora settings under the Oracle installation directory under the Networkadmin folder. If the configuration is as follows (service_name to be clear, 8i the following version is SID): Assume remote server IP is: 192.168.1.12 Database name is: Data To modify a configurati

This document uses Oracle8i as an example:First install an oracle client,Retain the bin, network, and ocommon directories in the oracle directory, and delete all the other directories,Export HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE in the registry.When installing the new machine, copy the oracle directory and registry fi

How to import Oracle database data to excel Author: He taoping In today's era of rapid information development, users often encounter the problem of Switching Data in Excel files to data in Oracle databases, operations on real-time data are implemented, but not many mate

If Oracle 11G reports that Enterprise Manager cannot connect to the database instance, You Can troubleshoot the problem as follows: 1. Use SQL PLUS. Run SQL PLUS in DOS mode. SQL> conn Enter the User name: sys as sysdba Enter the password: Connection successful SQL> desc dba_users Note: If this prompt shows that the view is invalid. Create user_astatus_map with D

Java usesJdbc:oracle:thin:@11.1.0.14:1521:orclConnecting to an Oracle database appears:Ora-12505,tns:listener does not currently know of SID given in Connect descriptorError.Indicates that a service with Sid ORCL on the server does not exist and can be connected to the service in a different way: replace the last colon with a slash. Successfully connected to the

/*** Separate Java Program Connect to the Oracle database * Author: javaalpha * Date: 12:02:44 */import Java. SQL. *; public class test {public static void main (string [] ARGs) {string driver = "oracle. JDBC. driver. oracledriver "; string url =" JDBC: oracle: thin: @ 192.1

[Java]/*** Separate java programs connect to the oracle database* Author: JavaAlpha* Date: 12:02:44*/Import java. SQL .*;Public class Test {Public static void main (String [] args ){String driver = "oracle. jdbc. driver. OracleDriver ";String url = "jdbc: oracle: thin: @ 192

Tags: file jsb target get Data options amp Lib expandTo bring Excel to the Oracle database, I now know that one way is to:1. Save Excel as a CSV file2. In PL/SQL developer, the contents of CSV file are directed into Oracle Expand Next Step 2:1. Open PL/SQL Developer, log in

Since oracle is not installed in windows, an oracleinstantclient is installed to configure tnsname first. ora is located in D: dev_softwareoracleproduct11.2.0client_1networkadmin. If not, copy one from the sample in the directory to add it. The following configuration is ORCL, which is followed by the database ipport. Since oracle is not installed in windows, an

Apache Service Service httpd Restart 8. Use the Phpinfo () function to view 9. Edit the PHP code connection test Oracle Database $conn = Oci_connect (' Scott ', ' Oracle ', ' 192.168.12.133/ORCL ');if (! $conn) {$e = Oci_error ();Print htmlentities ($e [' message ']);Exit}$query = ' Select Ename,sal from Scott.emp ';$stid = Oci_parse ($conn, $query);if (! $

thinkphp Connecting the Oracle Database

asp.net|object|oracle| Data | database 1. Add a reference to the Web application project first: Interop.oracleinprocserver 2, the Web.config configuration: ...... 3, Global.asax Create the Oraclesession object, the code is as follows: Using System;Using System.Collections;Using System.ComponentModel;Using System.Web;Using System.Web.SessionState; A summary description of the namespace Sparepart { /// ///

Today I learned about the latest popular Ruby on Rails, feeling like a code generator linking OracleDatabase, I searched for half a day of information. Finally found a way, ^______^. 1. Installation drive http://rubyforge.org/projects/ruby-oci8/ Download and run (double-click) Ruby-oci8-mswin inside the *.RB 2. Change Database.yml DevelopmentAdapter:ociHost:examplesidUsername:exampleuserPassword:examplepass Or DevelopmentAdapter:ociHost:192.168.0.50/examplesidUsername:exampleuserPassword:example

I thought it was simple, and I found some pits.1. Installing Cx_oraclePip Install Cx_oracle2. Download InstantclientThen unzip the oci.dll copy to the $python_home or $Python _home\lib\site-packages directory, note must be consistent version, otherwise will be reported Importerror:dll load failed: The specified module could not be found.3. Although this is possible to use cx_oracle, but the actual operation of the database may appear cx_Oracle.Interfa

Importing Excel data into an Oracle database using the Toad implementationTools: toad11.7z (Baidu search, direct download)1. Import some fields from Excel file into the corresponding table of Oracle databaseConnect to the database