10g gbic

connected environments. select... For update [Nowait] . If Nowait is specified, if another transaction is updating or has already updated this row, an ORA-00054 error occurs. If you do not specify Nowait , it will keep waiting. II.Optimistic Locking: 1.Optimistic Locking. If you find that the data has been modified, you must take measures based on your actual business needs: A)Get new value and start again. B)Update conflicts are resolved based on business rules, and two updated va

Oracle 10g Tutorials: Oracle Net Services In this tutorial you will learn Oracle Net Services-an overview, using Oracle Net manager, creating listeners, choosing general parameters, enable the tracing and logging for the database transactions. we will also learn how to use tnsping to test Oracle Net connectivity.Document Summary This document gives the overview of the Oracle Net services. It also explains the uses of Oracle Net manager. Oracle Net Ser

As we all know, it is not easy to migrate a database from a higher version of Oracle to a lower version of oracle. If you directly use the SQL developer tool, you may not be able to complete the migration successfully (errors may occur more or less in the middle ). Exp and IMP are applicable to Oracle data copy and backup of the same version. If Oracle data copies of different versions are used, exp is used for data backup from a higher version to a lower version, IMP may not be able to complete

perform the corresponding operations until the installation is successful.Iii. Installation Problems 1 Q: After the./runInstaller is executed, the installation interface cannot be displayed, and the following error message is displayed:Bytes ---------------------------------------------------------------------------------------------Xlib: connection to ": 0.0" refused by serverXlib: No protocol specifiedError: Can t open display: 0.0A: run the following command as root on the machine where Orac

1. Create a stored procedureSQL> Create or replace function get_sal3 (name varchar2)2 return number is3 v_sal number (6, 2 );4 begin5 select Sal into v_sal from EMP where upper (ename) = upper (name );6 RETURN v_sal;7 end;8/ The function has been created. SQL> var salary numberSQL> Exec: Salary: = get_sal3 ('Scott ') The PL/SQL process is successfully completed. SQL> Print salary Salary----------3000 2. Create a stored procedure in the PL/SQL command windowConnected to Oracle Database

Summarize and organize yourself: 1. Check the registry, Oracle_Home under HKey_LocalMachineSoftwareOracle. If not, change it to correct; 2. uninstall ODP. net (or uninstall ODT. net, ODT contains ODP, ODT is. net is an integrated plug-in for connecting to and browsing oracle databases, and provides drag and drop operations on oracle databases, similar to. net for the resource manager of SQL Server ); 3. If the ODT for. Net directory still exists, delete or rename the directory; Restart the s

The official Oracle 10g documentation indicates that Red Hat Linux can only be installed in an operating system version earlier than rhel4. Of course, there is no problem when it is installed in rhel5, but it requires special authorization from oracle, otherwise, you cannot contact oracle for support in the future. If you use the traditional./runInstall. sh method to install oracle on rhel6, you will encounter an error. You need to use a special metho

Oracle 10g Lsnrctl does not reflect the inability to connect to the database, oraclelsnrctlSymptom Description: The oracle version used is 10.2.0.1.0 in linux. If lsnrctl status is entered on the command line interface, no response is returned. If lsnrctl stop is entered, no response is returned. Applications connected to the database run normally, but new applications cannot connect to the database. SQL plus is normal on the oracle database server, b

/oracle Export ORACLE_HOME = $ ORACLE_BASE/10g Export ORACLE_SID = keiichi// The SID of the database instance, which must be the same as the SID in the graphic interface Installation Process Export PATH = $ PATH: $ HOME/bin: $ ORACLE_HOME/bin Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/lib Start Installation #Su-oralce $Cd/u01/databases// The Directory generated after Oracle Decompression $Export LANG = en_US// Set temporary environment variables

Batch update Optimization for Oracle 10g large tables. In fact, 7 million of the tables are not big tables and are enough for testing. I. t table informationSQL> alter table t add is_del number (1 );SQL> alter table t modify is_del default 0; SQL> desc tName Type Nullable Default Comments--------------------------------------ID NUMBER YCODE NUMBER YIS_DEL NUMBER (1) Y 0 SQL> select count (*) from t;COUNT (*)----------7136976 2. cache t data first to c

, OCINumber, OCIRaw, OCIString, register,Short, signed, SQL _context, SQL _cursor, static, struct,Union, unsigned, utext, uvarchar, varchar, void, volatile,A typedef name, exec oracle, exec oracle begin, exec,Exec SQL, exec SQL begin, exec SQL type, exec SQL var,The symbol "enum," was substituted for "size_t" to continue. Syntax error at line 106, column 3, file/usr/include/gconv. h:Error at line 106, column 3 in file/usr/include/gconv. h_ Gconv_trans_fct _ trans_fct;... 1PCC-S-02201, Encountere

When 64-bit Oracle 10g is installed on Oracle Linux Server Release 5.7, the following problems are encountered: Error in invoking target 'install' of makefile'/u01/app/oracle/product/dbhome_1/ctx/lib/ins_ctx.mk '. See '/u01/app/oracle/oraInventory/logs/installActions2014-01-11_12-44-52PM.log' for details; As follows: Run the tail command to view the/u01/app/oracle/oraInventory/logs/installActions2014-01-11_12-44-52PM.log file and find the following i

Lab environment: One Laptop (2 GB memory, GB hard drive) Vmware Server 1.0.6 Linux Enterprise 5.1 Oracle 10g for linux (10.2.0.1) Preface: This was not the first lab environment. The virtual machine used vmware workstation. After a while, it was found that the shared disk could not be created using the vmware workstation version, so it was impossible to build the oracle rac lab environment, therefore, we changed vmware workstation to vmware server2.0.

The RedHat Enterprise Linux 5 installation was successful, but many errors occurred while installing Oracle. The official Oracle 10g version website is here. You do not need to register for downloading with thunder. You need to register for IE downloading. 1. Install related software packagesThe list is as follows:Binutils-2.15.92.0.2-13.EL4Compat-db-4.1.25-9Compat-libstdc ++-296-2.96-132.7.2Control-center-2.8.0-12Gcc-3.4.3-22.1.EL4Gcc-c ++-3.4.3-22.1

An Oracle 10g Process System Study note: Since Oracle 10 Gb is a multi-process and multi-thread database, SQL Server is a single-process and multi-thread database. Oracle instances mainly have three types of processes. 1. server process 2. background processes 3. Subordinate Process Server process: divided into VPC process and Shared Server process Background process: 1, PMON (Process Monitor) 2, SMON (System Monitor) 3. RECO (distributed da

About Oracle 10g schedule job, oracleschedule -- Job permission Grant create job to somebody;-- Job creationBeginDbms_scheduler.create_job (Job_name => 'agent _ LIQUIDATION_JOB ',Job_type => 'stored _ PROCEDURE ',Job_action => 'agent _ LIQUIDATION. LIQUIDATION ', -- stored procedure nameStart_date => sysdate,Repeat_interval => 'freq = MONTHLY; INTERVAL = 1; BYMONTHDAY = 1; BYHOUR = 1; BYMINUTE = 0; BYSECOND = 0', -- MONTHLY, INTERVAL: 1 (month ), 1st

Oracle 10g officially certified operating system version Operating system x86Red Hat Enterprise Linux AS/ES 3 (Update 4 or later)Red Hat Enterprise Linux AS/ES 4 (Update 1 or later)Oracle Enterprise Linux 4 (OEL4)Red Hat Enterprise Linux AS/ES 5Oracle Enterprise Linux 5 (OEL5)SUSE Linux Enterprise Server 9 (2.6.5-7.201 or higher)SUSE Linux Enterprise Server 10Asianux 1.0 (2.4.21-27.EL or higher)Asianux 2.0 (2.6.9-5.0.5.EL or higher) Operating systems

[Oracle 10g] sqlplus logon error resolved, oraclesqlplus I,When running sqlplus in cmd in win7, the following error is reported: SP2-1503: Unable to initialize Oracle call interface SP2-1503: Unable to initialize Oracle call SP2-0152 Solution: In the oracle \ product \ 10.2.0 \ db_2 \ BIN directory, find sqlplus.exe, right click --- properties --- compatibility --- choose to run this program in XP SP3 compatible mode --- run it as an administrato

How to disable and start Oracle 10g RAC Scenario 1: maintain the database and operating system, servers, and shut down the database (all instances), OS, and Server. A. Stop the Oracle10g environment first$ Lsnrctl stop (you can also use srvctl to stop listening on each node)$ Emctl stop dbconsole (each node stops dbconsole)$ Srvctl stop database-d RACDB (stop all database instances)$ Srvctl stop nodeapps-n node1 (stop Node 1 service)$ Srvctl stop node

Oracle's grid controller can be used to centrally manage oracle databases and middleware. It is very useful. It can also simplify the management of rac and dg on the grid controller. Tang sir has a famous saying: "rac with no grid controller is basically unavailable!" The grid controller gridcontrol (gc) of oracle is mainly composed of three parts: OMR, OMS, and OMA. OMR mainly refers to the archive store for storing gc data. OMS mainly refers to the application server. oracle uses the command l