tns
The new on-line database Oracle10gR2 warning log file (alert.log) continued the following error: Tue Jul 18 23:09:22 2006 WARNING: inbound connection timed out (ORA-3136) Tue Jul 18 23:09:23 2006 WARNING: inbound connection timed out (ORA-3136) Tue J ...
When calculating the Cardinality, ORACLE will first use the DENSITY. If you manually modify the NUM_DISTINCT DENSITY then change will follow. However, in turn, if modified DENSITY, NUM_DISTINCT will not change. SQL> SELECT * FROM V $ VERSION; BANN ...
Environment RAC and single instance of the establishment of the materialized views can be updated SQL> select * from gv $ version; INST_ID BANNER ---------- ---------------------------------------- ------------------------ 2 Oracle Database 10g En ...
Basic Configuration Environment RAC and single instance of two-way synchronization, synchronous and asynchronous mode SQL> select * from gv $ version; INST_ID BANNER ---------- ---------------------------------------- ------------------------ 2 Or ...
Wait for the event originated The concept of waiting for the event is probably introduced from the ORACLE 7.0.12, roughly 100 to wait for the event. In the ORACLE 8.0 increase in the number to about 150, in the ORACLE 8I Approximately 220 events, in the O
Wait for the event originated The concept of waiting for the event is probably introduced from the ORACLE 7.0.12, roughly 100 to wait for the event. In the ORACLE 8.0 increase in the number to about 150, in the ORACLE 8I Approximately 220 events in the OR
Today a friend asked MGMT_VIEW users do use, we look at the database this user: SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Pr ...
1: First of all, switch to the system administrator sqlplus 2: query the database name, creation date and other information NOARCHIVELOG that the database is running in non archive mode, the status is read-write (normal state). ARCHIVELOG and non-arc ...
Oracle's a bug need to modify the hidden parameter ALTER SYSTEM SET "_cursor_features_enabled" = 10 scope = spfile; In this machine (version 10.2.0.1 of the) test, the prompt * Error Line 1: ORA-02065: illegal ALTER SYSTEM option In a 1 ...
iSQL * PLUS is the Oracle9i Release2 (9.2) offers new features, through the WEB browser login. HTML can display the results in tabular form, with the history command tool. HTTPD password file can be SYSDBA or SYSOPER logged iSQL * PLUS. In addition, ...
Question 1: ORA-19527: physical standby redo log must be renamed PRIMARY: Error 12514 received logging on to the standby Sun Mar 28 23:37:44 2010 Errors in file / opt/oracle/admin/ATYU30/bdump/ATYU30_arc4_5364.trc: ORA-12514: TNS: listener does not c ...
* P6810189_10204_Linux-x86-64.zip $ Uname-a Linux convert 2.6.18-128.el5 # 1 SMP Wed Jan 21 10:41:14 EST 2009 x86_64 x86_64 x86_64 GNU / Linux SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- ...
SQL> SELECT * FROM V $ VERSION; BANNER -------------------------------------------------- -------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL / SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 3 ...
The following content to the Internet, do not know which of the original author is very grateful to the author's summary. Belongs to original author. ==================== Have recently seen a lot of people say that the tns or the database can not ...
ORACLE_ backup and recovery _RMAN relevant content 2 1. Configuration control file is automatically backed up Starting from 9i, you can use rman to configure the automatic backup control file, the default backup to $ ORACLE_HOME / dbs directory, if i ...
Encounter this problem long ago, always thought that because there was no set FORCE_LOGGING problem only today found not to this problem. The problem is the 10g version of the origin of the use of LOGMNR can not find just the implementation of the DM ...
(The following only in the "=" was the case of the entry into force, LIKE not work.) Sometimes we do not want to check the time and other functions through the lower or upper case and put out the contents of all queries, such as from sqlser ...
The client version is 10.2.0.1.0 32-bit, the server is 9.2.0.4.0 64-bit. Clients connect to the server reported that ORA-28547: connect to server fails, Oracle Net administration may be wrong. Situation is as follows: C: \> sqlplus "sys / ora ...
Description: Application development may be the establishment of a number of indexes, but these indexes used in the end how kind, is there an index has not been used, which requires us to monitor these indexes in order to determine their usage, and a ...
rn Question: The database character set has been modified, by the zhs16gbk been modified US7ASCII, so can not correctly display Chinese, the following procedure is to modify the character set to come back. select 'hello' from dual; '?? ...
Problem Description: Inspection of a customer's rac database and found that there are a large number of Baocuo alert log as follows: Tue Dec 29 10:33:17 2009 Errors in file / oracle/app/admin/BILL/udump/bill2_ora_12230.trc: ORA-00221: error on wr ...
Test Objective: Does it include a query string in the non-numeric characters other than the Characters in a string of a query the frequency of Test environment: SQL> select * from v $ version; BANNER ----------------------------------------------- ...
Before a brief introduction to 10g's new features, RMAN's CONVERT command, but for lack of space, did not give a specific example, this use of CONVERT in the SOLARIS platform and LINUX platforms, 10.2.0.3 version of the database, table space achie
Waiting for the origins of the event The concept of waiting for the event is probably introduced from the ORACLE 7.0.12, there are roughly 100 to wait for the event. In the ORACLE 8.0 increase in that number to about 150, in the ORACLE 8I approximate ...
Note: only reproduced the experiment, the principle has not been reproduced, if the principle of click to see the original author of the link. ================================================== =================== From the 10g start, oracle began off ...
Oracle10g an increase of PCT fast refresh materialized view support for the use of PCT fast refresh materialized view log is no longer needed. In 9i, the materialized view fast refresh materialized view logs must be established, or else can not fast ...
Apply -------- Oracle Net Services This information applies to all platforms practical examination on 8-OCT-2009 rn rn Target ----- How to set the 10g and the new listener password, by default OS storage mechanism. In Oracle 10g and the new monitor, ...
Oracle ASM Instance in a database using the SYSDBA connections on $ ORACLE_HOME / rdbms / audit / the following produce a ora_ *. aud files, as follows: [oracle @ asm audit] $ cat ora_10523.aud Audit file / u01/app/oracle/10.2.0/rdbms/audit/ora_10523 ...
Method 1: Method 2: SQL> select * from product_component_version; PRODUCT VERSION STATUS ------------------------------------------- ------- --------- ---------------- NLSRTL 10.2.0.1.0 Production Oracle Database 10g Enterprise Edition 10.2.0.1.0 ...
1, listening to start Baocuo TNS-12555: TNS: permission denied TNS-12560: TNS: protocol adapter error TNS-00525: Insufficient privilege for operation Linux Error: 1: Operation not permitted rn Listener failed to start. See the error message (s) above ...
Here the point of listening, this is done before the experiment was Carmen when the longest, and is "talking big ORACLE RAC" writers do not give a clear explanation of the place. Many documents are referred to the experiment to achieve a ce ...
Next step is based on the modified parameter file to start the database and generate the server parameter file, let the database to the way the server parameter file to start the database: 1, using the modified parameter file to start the database to ...
$ Sqlplus '/ AS SYSDBA' SQL * Plus: Release 9.0.1.0.0 - Production on Mon Jul 14 17:01:09 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Parti ...
ORACLE used a fool question 1000 asked by: CCBZZP 1. Oracle installation is complete the initial password? internal / oracle sys / change_on_install system / manager scott / tiger sysman / oem_temp 2. ORACLE9IAS WEB CACHE initial default user and pas ...
echo "$ PROGNAME - tns <Oracle Sid or Hostname/IP address>" echo "$ PROGNAME - db <ORACLE_SID>" echo "$ PROGNAME - login <ORACLE_SID>" echo "$ PROGNAME - cache <ORACLE_SID> <USER> <PASS&g
oracle10g new features: flash recovery area (Flash recovery area) Flashback to provide information, so that they can be found in the past, when necessary, the consistency of data at some point, this is achieved through the Undo. That there are substa ...
When I use the lsnrctl status query db port status, it was found that: [Oracle @ test admin] $ lsnrctl status testdb LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-AUG-2009 01:27:27 Copyright (c) 1991, 2005, Oracle. All rights reserved. Con ...
Today do code review, found a rather interesting bug. For the following code, Oracle can enforce it: BEGIN FOR i IN 1 .. 4 LOOP dbms_output.put_line (i); END LOOP - There is no semicolon! COMMIT; END; Less a semicolon here, but the implementation of ...
Stupid questions asked ORACLE 1000
PL / SQL Developer Oracle Developer I do the most commonly used tool, just find a low-level bug. Now I describe it: Testing Oracle version: SQL> select * from v $ version; BANNER -------------------------------------------------- -------------- Or ...
Source: Net sea cockle-pickers Let us reveal the mystery of 10g database, say come on building a database, 10g of dbca or a bigger change than 9i. 1, dbca Welcome screen: 2 Options Tip: 3, by major end use of different database templates: 4, input da ...
Nid is the Oracle from the 9iR2 started to provide the tools that can be used to change the database name without the need to rebuild control files before the adoption of methods such as tedious. Be noted that, although this tool from the 9iR2, but s ...
rn In Oracle10g, before any operation table for the dual need to perform a full table scan, even if we just want to get some return value. The full table scan operation is required a certain price. rn rn In Oracle9i the rn SYS @ gdc> select * from ...
Special Note: This article from eygle master's BLOG Oracle8.1.5 can connect Oracle10g Oracle8.1.7 can also connect Oracle10g Oracle10gR2 can connect Oracle8.1.7, but can not connect Oracle8.1.5 Oracle10g, and Oracle9i versions can be interconnect ...
This is reproduced in his charly link on the BLOG http://tiaolao.loveunix.cn/index.php/action/viewspace/itemid/93.html ==================== Have recently seen a lot of people say that the tns or the database can not log and other issues, we simply su ...
1000 issue of Oracle common idiot asked ORACLE in the application when you may encounter a lot of problems seem difficult, especially for novice, and today I simply put it to sum up, release to you, hope you help! And everyone to explore and seek com ...
SGA Adjustment rn -------------------------------------------------- ------------------------------ SGA Adjustment rn An environment: A platform: IBM AX360, 4G memory rn windows 2k advServer sp3 + oracle 816 Exclusive Mode rn 2 memory allocation para ...
Business this test storage procedures are slow, check the database found in the relevant session in the library cache lock wait state, usually due to changes in the data dictionary, caused the problems. Treatment methods are as follows: Command selec ...
rn ORA-12500 error to solve one case rn Introduction: rn 10 pm last Sunday, my colleagues call home, and reflect the database's TNS time when the pass off, seriously affecting production. Should be used to judge the memory causing the user to con ...
File: Li Shouliang order: Oracle text index setting step. Rar Size: 7KB Download: Download Oracle text index setting step Founder Li Shouliang order slli@founder.com.cn Last version :2003-2-24 Several project teams have started using oracle of the fu ...
