When the PL SQL is installed, the database at the following figure is empty. You need to install a 32-bit client, stating that PL SQL does not support 64-bit client connections.
Solution:
1. Download the 32-bit Oracle client and install
2, set
Isql*plus Introduction
Isql*plus is a new feature offered from Oracle 9i and is a sql*plus Web form (Oracle 11g is not supported). is based on a three-tier structure. Its client, middle, and server can be located on the same machine or on a
After configuring the shared server mode today, we found that the error ORA-12523 in the process of logging in, and found that static monitoring was the bane of the investigation.
There are two listening on the machine, a static listening 1521 port,
First, the preparation of logical standby
1, confirm the operation of the object and statement can be logically standby support
Because the logical standby is to maintain synchronization with the primary database through SQL applications. SQL
ORA-00903 Invalid table name
ORA-00903: Invalid table name
Cause A table or cluster name is invalid or does not exist. This is also issued if a invalid cluster name or no cluster name is specified in a ALTER cluster or DROP cluster Statement.
From: http://blog.csdn.net/kk185800961/article/details/86023061. Start with only Oracle and access connections2. Open Oracle SQL Developer:Tools--> Preferences--> Database--third-party JDBC driver--Add driver entries3. Automatically loaded into the
Error description
The operating system is Win7 x64,oracle server is oracle11g x64, the client is ORACLE10GR2 x86.
Connection is normal using Pl-sql developer
Using the system ODBC connection is OK. It is important to note that the 64-bit
First, Variable introductionWhen you write a PL/SQL program, you can define variables and constants, including the following in the PL/SQL program:1), scalar type (scalar)2), composite type (composite) --for manipulating individual records3),
I. Nested loop principleNested loop connection (loop nested connection) refers to a two-table connection, which is followed by a two-tier nested loop to match sequentially, and finally gets the table join method that returns the result set.If the
Oracle Wallet Preliminary study1. What isWalletA Datastructure used to store and manage security credentials for A individualentity.from Oracle10gr2 starts by using Oracle Wallet to log in to the database without using a password ( non-operating
ORA-24247: Network access is denied by Access control List (ACL)You need to use Dbms_network_acl_admin first. CREATE_ACL Create an Access control List (ACL),Then use the dbms_network_acl_admin. Assign_acl This ACL is associated with the mail
Recommended Reference Material>>The detailed screenshots about installation and upgrading Oracle Server is as the following.Checking the software requirementsVerify that the following softwares is installed on the system
OS Requirements
Create a linked server on the SQL Server database, connect to the Oracle database, and the provider needs to be set to: "Oracle Provider for OLE DB". If this driver is not available on your computer, installing a complete ORACLE11GR2 program is a
Production Application win Platform Oracle+websphere project implementation _websphere Video Training tutorialBasic part:Oracle Basic Concepts and architectureWebSphere related concepts, profiles, data sources, connection pools, consoles.Actual
[Oracle] Exadata routine inspection tool Exachk
In Exadata, it is best to run exachk for health check when there is any database-independent problem. Exachk collects a wide range of information, eliminating the hassle of manual collection. After the
Solve PL/SQL Dev connection to Oracle a blank prompt box appears, ploracle
The first time Oracle was installed, it was installed in a virtual machine. When PL/SQL Dev was used to connect to a remote database, a blank prompt box pops up. After a long
Scalable lgwr is an exciting feature introduced in 12cR1, because LGWR writes logs in the OLTP environment often become the main performance bottleneck of the system. If the LGWR process can be like DBWR (DBW0 ~ As long as multiple processes (LGNN)
If a 50 tb asm of a customer fails, it will be recovered after joint efforts. Please record it here! In fact, it was much simpler than I thought. The following is a detailed description of the fault.-Db alert log informationMon Jul 6 15:17:43
Here is a simple record of the two Oracle RAC databases of a customer who worked overtime for the National Day. During the recovery process, the two rac databases were similar, therefore, we will take the restoration process of a set of databases as
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service