10g transceiver

Oracle 10g quick manual database creation steps, oracle10 g manual database creation steps0. Modify Environment Variables[Oracle @ ocm1 ~] $ Vi. bash_profileAdd the following content: export ORACLE_SID = PRODExport ORACLE_BASE =/u01/app/oracleexport ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1export PATH = $ ORACLE_HOME/bin: $ ORACLE_HOME/jdk/bin: $ PATH1. Modify the logon identifier and Default Editor (optional)Modify $ ORACLE_HOME/sqlplus/admin/g

Install Oracle 10g client for Linux under fedora6 1. Ignore system check./Runinstaller-ignoresysprereqs 2. The error message "libxp. so.6" is missing.Yum-y install libxp. so.6 Run again. OK. The installation page is displayed. 3. Oracle 10g does not support Chinese characters by defaultChange Lang in/etc/sysconfig/i18n to EN during installation. 4. Oracle client does not support UTF-8 EncodingAfter i

After the computer name is changed, all Oracle services cannot be started.We recommend that you do not modify the computer name at will, because it is troublesome to modify many Oracle configurations after you modify the computer name. My original computer name is 53m6df34f7.The modified computer name is sgliuya2. First, solve the oracledbconsole * service.Run the command emctl start dbconsole In the CMD window and the following information is displayed: C:/Documents and Settings/LiuYa> emctl st

Originally, I only wanted to install an Oracle client with the imp/exp command. However, instantclient does not have these two commands and does not want to download 10 Gb client software of over 600 mb, which is also troublesome to install. The 10g express edition is found, and the Deb installation package for Debian is also available. I am from Hangzhou. Because it is necessary to support Chinese characters, it is natural to use the universal versio

to modify the Oracle 10g RAC Listener Port number 1523OneModify the Listener.ora to change the 1521 to 1523. Make a backup of the file in advance for quick recoveryTwoModify the Tnsnames.ora, change the remote_listener corresponding value in the Tnsnames.ora parameter to 1523, make a backup of the file in advance for quick recoveryThreemodifying Local_listener database initialization parameters alter system set Local_listener = ' (ADDRESS = (PROTOCOL

common maintenance commands for Oracle 10g Dataguard. Basic common 1. Stop standbySelect process, status from V$managed_standby; --See if the standby is restored in the application logALTER DATABASE recover managed standby database cancel;Shutdown immediate;2. Switch to read-only mode-----switched from Shutdown mode to read-only mode-------Startup Nomount;ALTER DATABASE mount standby database;ALTER DATABASE open read only;-----switched from Applica

An error occurred while installing the Oracle 10g database, previously installed on the Windows7, and now share the solutions and reasons for the problem. Installation behavior: 1. Install the default path that is different from before. Formerly: d:oracleproduct10.2.0 or f:oracleproduct10.2.0 Now: c:userscynthiaoracleproduct10.2.0 2. After entering the password next time, install oracle10g "program abnormally terminated." An internal error has oc

Free 10g/150g/php Tutorials/mysql Tutorials/ftp/personal home page space disk space: 10GB ofBandwidth: 150GBParking Domain name: 5Domain pointer: 5Sub-domain name: 5Multi-point virtual hostUnited Kingdom, Europe XNetherlands, Europe XGermany, Europe √Lithuania, Europe xSingapore, Asia XDatabase Tutorial/codingMySQL Database 2mysqli Extension √PostgreSQL Database XPostgreSQL's Admin xPHP Support √Zend Optimizer √Guangdong Processor √Perl supports XCGI

Purpose: The client's server is Windows Server 2008 R2, which installs Oracle 10g 10.2.0.1. Reasons and Solutions: It was later found that the installation file is 32 bits, the operating system is 64 bits, the version does not match, and Oracle requires at least 10.2.0.5. Nor does Oracle officially have an Oracle version of the operating system support. Http://forums.oracle.com/forums/thread.jspa?threadID=960211tstart=0 (While there is no 10.2.0.5 da

Download 102010_win64_x64_database installation Error ... Checking operating system version:must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1Failed Check it out. The version of Windows 2008 R2 is 6.1, and Oracle 10g supports only 6.0, so the following error is prompted when installing client: Checking Installer Requirements ... Checking operating system version:must be 5.0, 5.1, 5.2 or 6.0. Actual 6.1Failed Exiting Oracle Universal Installer, log for this s

Oracle different versions of Official documents online reference and packaging Download The address summary, listed here, for your reference.1.9iOracle Official Document1) Online BrowsingHttp://www.oracle.com/pls/db92/homepage2 download in hand, reference worry-freeOracle9i Database Release 1 (9.0.1) documentationHttp://www.oracle.com/technology/documentation/Oracle9i_arch_901.htmlOracle9i Database Release 2 (9.2) DocumentationHttp://www.oracle.com/technology/documentation/oracle9i.html2.10g Ora

Oracle 10g new features-code obfuscation Author: Fuyuncat Source: www.HelloDBA.com Oracle 9i Previously, a command ' warp ' was provided to encrypt the code. But it's command-line, it's script-oriented. In 10g, Oracle Package DBMS_DDL provides a new function create_wrapped to confuse the code. Example:Sql> Declare2 V_protex varchar2 (2000): = '3 CREATE OR REPLACE PROCEDURE p_wraptest4 is5 V_cou

Oracle Introduction to the new features of Oracle 10G I release (next) by Fenng 2003-07-10 NOTE: Recently Oracle has officially announced that this version of Oracle named 10G, where G is the meaning of the grid. hereby correct. The strengthening of high availability 1. Reduce downtime for application and database upgrades By using the standby database. Allows switching between different versions of t

Last_ddl_time ------------------------------ ------------------- Pining 2007-03-31 17:54:35 In oracle10g, this last_ddl_time no longer changes, which means that in 10g, when we execute the Create or replace PROCEDURE, Oracle now tries the process check, and if the content doesn't change, You do not need to recompile the process, which reduces the invalidation in the cache, which can reduce competition: $ sqlplus Eygle/eygle More Wonderful conten

/zhejiang directory=d_test DUMPFILE=ZHEJIANG.DP Export:release 10.2.0.3.0-64bit Production on Wednesday, 16 January, 2008 22:51:43 Copyright (c) 2003, +, Oracle. All rights reserved. Connect to: Oracle Database 10g Enterprise Edition release 10.2.0.3.0-64bit Production With the partitioning, real application clusters, OLAP and Data Mining options Start "Zhejiang". Sys_export_schema_01 ": zhejiang/******** directory=d_test DUMPFILE=ZHEJIANG.DP is u

One of the best features of Racle 10g is the consultant Framework (Advisory framework), a collection of tuning consultants that can help you make the most of your database. One of the consultants,--sql Access Advisor (Access Advisor), recommends changing indexes and materialized views in the schema to improve performance. However, because the consultant Framework (Advisory framework) is generalized to support a wide variety of consultants, it is cumb

Oracle 10g Instant Client is the easiest way to connect PHP to a remote Oracle database, and it only needs to install three libraries. The Instant Client library used by PHP to access the current API for Oracle is called OCI8. (the name of this C interface was first introduced in Oracle8.) The PHP Oracle 8 function can call Oracle 8.1.7, 9.x, or 10.x directly, or you can use optional abstract classes such as PEAR MDB2 and ADOdb for convenience. Inst

From 10g, Oracle can recover the wrong statistics. This article briefly describes the statistical information recovery feature. Inaccurate statistical information may lead to the inability to produce optimal execution plans, and for the most part, the latest statistics reflect the current system data distribution, resulting in optimal execution plans. But sometimes a change in the execution plan that results from collecting statistics does not neces

Tags: Ops directory sed nal RTM user its source users Oracle HR Example User's build 10g,11g can be Put the 10. sql files on the attachment (see the end of the article) in this path first: $ORACLE _home/demo/schema/human_resources Script Name Description Hr_analz.sql Collects statistics on the tables in the schema. Hr_code.sql Creates procedural objects in the schema.

At first glance, this hint of ORA-00979 not a GROUP by expression is expected to quickly locate it as a SQL statement with a problem, in fact, you may encounter an Oracle bug, which is common in 10.2.0.4 version (10g The last patch version is 10.2.0.5).A few days ago and colleagues to do an application system upgrade encountered this problem, first of all, a view can not be created, carefully analyze the composition of the view of the query did not fi