When Oracle is not installed on the computer, C # Calls oracle database and Oracle customer tools,
The installation packages of Oracle are usually relatively large and time-consuming. If errors occur during the installation process, the installation may be quite annoying. At work,
Based on Metalink 362496.1
From the document, the XML Publisher version is not directly available.
The most useful is to query its version from the generated report.The details are as follows,PDF output: open the file in Adobe Acrobat-> Menu file-> Document Properties-> Tab description-> Property 'pdf producer 'will show e.g. Oracle XML Publisher 5.6.2RTF output: open the file in MS word-> Menu file-> Properties-> Tab Summary-> Property 'comments' wi
Oracle Silent Installation tutorial, oracle Silent Installation
In this article
>
Content
>
Indicates that the content is appended to the input file, which is part of the parameter required in the file.
Content
This means that the content is all in the current file. You can delete the file, create the file, and enter the content.
Installation environment, CentOS 6.8, VMware workstation PRO 12
Hardware en
Tags: style class blog HTTP tar extOracle Easy Interface ToolBackground: I work on a remote machine, I need to call the Oracle 11gserver data, the remote machine has the Oracle client installed, but the SQL Plus and SQL developer and PL SQL developer are not available (DBA toss for a few days no solution of the decision). I have the IP of the server, Oracleusername and password, and know some table names an
Oracle
Oracle DAB two day crash course
The purpose of this course is to supplement the DBA's two-day quick (2 days dba) manual. In this course, you will learn more about the tasks outlined in the DBA's two-day quick (2 days dba) manual, and include step-by-step instructions. To view the information for this course, click the following Chapter title: Course List 1 What are the elements of the Management
Summary
Oracle Database is a well-known leading database system on Unix hardware platforms. Oracle users and administrators are therefore familiar with the Oracle architecture on the UNIX platform and the tools and skills above it, and get the greatest benefit from their databases. On the contrary, Oracle architecture
[Oracle Notes] 2. Oracle Server entry and Oracle management routine
[Oracle Notes] 2. Oracle Server entry and Oracle management routine
Oracle Server entry and
Today, with the NAVICAT for Oracle connection Oracle because it used to be connected with pl/sql, since the use of a period of time navicat for MySQL found good, the whole software is very small.
When you can connect, the username, password, and address are all correct, just can't connect. The following error occurred:
It means: You cannot create a OCI environment;
The problem is that we need to co
Method 1: As you all know, to connect to Oracle using PL/SQL, you need to install the Oracle client software. Have you ever wondered whether to directly connect to Oracle without installing the Oracle client? In fact, I always wanted to do this, because this client is so annoying !!! Not only will JDK be installed, but
Oracle how to ensure the ACID principle of transactions -- oracle Core Technology Reading Note 2, acid -- oracle
There are four general principles in the transaction that all databases must comply with, referred to as the ACID principle. The following briefly describes how oracle implements these four principles.
1. A
1.oracle InstallationRefer to http://wenku.baidu.com/view/d01ffd43336c1eb91a375d68.html, no longer repeat here2. Command line sqlplus Connect Oracle(1) Check the monitoring statusc:\>lsnrctl StatusLsnrctl for 32-bit windows:version 9.2.0.1.0-production on 2 August-June-2005 11:01:01Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (D
How to view and modify the oracle Character Set and view the oracle version ?, Oracle Character Set1. view the database Character Set
Database Server Character Set select * from nls_database_parameters, which is derived from props $ and represents the character set of the database.
Client Character Set environment select * from nls_instance_parameters, which is f
Oracle (zero) --> pseudo-column and group aggregation (starting from Oracle, relatively beginner ~), OracleIn the beginning ~It's time to start school .. What does it have to do with me ..), After all, I took up my job even though I didn't know what it was during the summer vacation. I watched my classmates show around me. = It's too much. Just try again .. I learned Or
ORACLE-013: kill deadlock process in oracle, oracle-013oracle
In oracle, stored procedures or functions that frequently access packets may cause deadlocks. Scripts of deadlocked objects cannot be run, causing freezing or an exception: too many connections are opened.
In this case, you need to use the dba account to k
ORACLE-018: ORACLE tip 001 string processing, oracle-018oracle
1. truncate a string
Oracle uses a function substr to intercept a string. The parameter is substr (string, start position, and truncation length ),
For example, if the string 123,112 needs to be removed by a comma, the truncation function is as follows:
Method One: Use the Pl/sql Developer tool to export:Menu bar---->tools---->export Tables, the following figure, set the relevant parameters can be:
Method Two: Use CMD's Operation command to export, the details are as follows:The 1:g:\oracle\product\10.1.0\client_1\network\admin directory has a Tnsname.ora file that reads as follows:
Copy Code code as follows:
Cmstar =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (H
Oracle User Management
First, the concept of the user
Users, or user, is a popular way to access Oracle database "people." In Oracle, the user's various security parameters can be controlled to maintain the security of the database, these concepts include schemas, permissions, roles, storage settings, space quotas, access resource constraints, database auditing
EXP Export Oracle database table: (as native administrator), refer tohttp://jiqinlin.iteye.com/blog/758469 Export TABLE: Exp username/password @localhost (IP address): Port number/Database instance name file= local address \ Want to generate an indication. DMP owner= (username, Password) eg:exp C # #tjuser/TJUSER@LOCALHOST:1521/ORCL file=c:\adc160624.dmp owner= (C # #tjuser, Tjuser)//tables under the current user
database name, instance Name query: (A
Tags: process build rail info from BSP content lag stop For non-Oracle DB, SQL Server is a sample description: My train of thought A:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destination a-> b->c Note: B on both the rep process also has the EXT process, at this time. There is also a need to establish a rep process for B.A->b can complete the online initialization synchronization (EXPDP based on SCN number)After the initializ
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.