Oracle

3. C:\users\xiaofeng>emctl Start Dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, Oracle Corporation. All rights reserved. Http://192.168.0.106:1158/em/console/aboutApplication Error opening logfile for

First, diagnostic tools 1. Warning Log file Warning log files contain system information and error logs that contain important errors (such as: ORA-600) and block checksum error messages (ora-1578,ora-1498). Monitor database operations such as

Core|oracle Morning spent a little time to complete the first Linux platform installation (:P, a bit embarrassing to say, only the first time), mainly refer to the Http://www.oracle.com/technology/global/cn/pub/articles/smiley_ Installation

Oracle Recommend some classic Oracle books to everyone: Http://www.eygle.com/index-book.htm Oracle8i Internal Services by Steve Adams The classic of Steve Adams ... An in-depth discussion of Oracle's internal mechanisms and principles is an in-

Generally speaking, we do this through ODBC to access the remote backend database. However, ODBC has a fatal drawback--slow speed. In fact, for Oracle databases, in addition to ODBC, we can use the OLE object (Oracle Objects for OLE) provided by

There is a problem in the field, after Oracle has been running for a while, the number of process overflows and the new connection fails. Through analysis, the ARCSOC process of ArcGIS Server is found to grow in no segment. ARCSOC is a container

Here, I am introducing the installation of the cloud Control 12c. The previous version is called Grid Control, which is also known as 11g. When I write this blog, the Cloud Control 13c has come out, this version follow me to introduce.  Before

NFS mount points that are disconnected on AIX cause Oracle instance HangTranslated from MoS article: Disconnected NFS Mount point causes Instance to hang on AIX (document ID 1445600.1)Suitable for:Oracle server-enterprise edition-version:10.2.0.1

1 Background notesNormally, when we install an Oracle database, we create an Oracle user. Its root directory is/home/oracle. and according to Oracle's OFA architecture, it is also recommended to use directories such as/U01 to install Oracle software

Logical backup (Data migration):Backup in Logical StructureMove data across usersMoving databases across databasesSave the original data state for the testVersion upgrade of a databaseConsiderations for Logical Export:EXP program in the directory

Original: http://blog.csdn.net/kimsoft/article/details/8751267Operating system: Windows 7 64-bit flagshiprequirements, install PL/SQL developer for developmentFirst, download the official Oracle Lite Green

Production-based duplicate replication, if there is no manual configuration of Pfile (set memory, process, DG-related configuration parameters, database-related path parameters), there will be a variety of parameters can not be converted;Because

The new cloud host environment, the system is CentOS 7 x86_64, needs to be installed on the installation of oracle11.2g. Groping for a long time, finally toss the fix.Download Oracle : Oracle 11.2.0.2 (only download 11.2.0.2 because it is

The remote connection of Oracle database can be implemented in a variety of ways, this article mainly introduces four methods and considerations of remote connection, and through the examples to illustrate, then we begin to introduce.First case:If

some summary of DRM1. What is DRMDRM (Dynamic Resource Management) is a new feature of Oracle 10g, where Oracle uses GRD (Global Resource Service) to record resource information for individual nodes in an Oracle RAC environment. This is specifically

1. View the database version SQL>Select from v$instance; VERSION-----------------12.1. 0.2. 02, SYSDBA user login Sqlplus Sql>show PDBs con_id con_nameOPENMODE RESTRICTED---------- ------------------------------ ---------- ----------

In short, generally set shmmax> = SGA (32-bit system supports SGA up to 1.7 GB). The default value is 32 MB,For 64-bit Linux operating systems, set shmmax to be greater than sga_max_size. The size of the Linux Shared Memory Page is 4 kb. The size of

Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?, I. Error description When you

Oracle Database-practical operations (3) PL/SQL Oracle ---- PL/SQL PL/SQL is a programming Language that combines Procedural Language and Structured Query Language (SQL ). PL/SQL is unique to Oracle and is an extension of SQL. Different database

How to query Apache server logs using MySQL statements: mysqlapache Linux has a notable feature. Under normal circumstances, you can analyze system logs to understand what is happening in your system or what is happening. Indeed, system logs are the