create database link oracle 11g

1. create necessary Directories D: \ app \ Administrator \ admin \ jxg12_20104350121 2. Create a database file storage directory under oradata D: \ app \ Administrator \ oradata 3. Create the initialization parameter file D: \ app \ Administrator \ admin \ jxg12_20104350121 \ scripts \ init. ora #######################

In database security configuration, security reinforcement is required. To ensure database security, however, sometimes, after improper operations or database business account password modification, the configuration of database connection for the program is encapsulated in jar, if the configuration information of the

My database (asm storage) is upgraded from 11.1 to 11.2. This function must be upgraded to 11.2 only when the delay section is created today. Check whether my instance's compatible is 11.1.0.0.0. Naturally, I think of alter systerm set compatible = '11. 2.0.0.0 'scope = spfile, but the current spfile cannot be modified, so modify pfile. SQL> create pfile = '/tmp/pfile' from memory; Then, modify the comp

Tags: link ati access Baidu log fill DBCA database ini15511477451 Original Oracle 11g The listener does not start during installation or the database service is not registered to the listener? Environment: Win7 64-bit system, oracle11g

Tags: blog http os io strong file data forNothing to do, want to re-install Oracle 11g, recorded as follows:(1) First stop all Oracle services in the service;(2) Start, oracle-oradb11g_home1, Oracle installation products, Universal Installer, click "Uninstall Product"-"Expan

1. Online segment shrink recycles idle space that uses fragments below the high water level line in the Oracle database segment. Segment shrink has the following benefits: 1. compressed data will lead to better cache utilization, resulting in better online transaction processing (OLTP) performance. 2. During full table scan, fewer blocks are required for shrinking data, which in turn leads to better perform

of the Tnsnames.ora file. For example, my machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the

example, my machine is: d:/instantclient_11_2/network/admin4. Set the Oracle language, add the environment variable Nls_lang, and the value is simplified Chinese_china. Zhs16gbkIf you do not know the Oracle language of the remote database, you can ssh or telnet to the remote machine, enter it at the command interface, and connect to the

location, overwriting the original file; (9) Execute database Restore command Sql>recover datafile ' d:\oracle\oracledata\orcl\users01.dbf '; (10) Reset data File online Sql>alter databasedatafile ' d:\oracle\oracledata\orcl\users01.dbf ' ONLINE;; (11) Query the data to see if the updated data exists. Below is the approximate process (21M drops (*^__^*) hehe ..

Tnsnames.ora this file to configure the URL path, otherwise there will be error!!! Public Connectoracle () { try{ Class.forName (ClassName); SYSTEM.OUT.PRINTLN ("Load Database driver successful!"); }catch (ClassNotFoundException e) { SYSTEM.OUT.PRINTLN ("Load Database driver failed!"); E.printstacktrace (); } } /** CREATE

In the actual work we often encounter some Oracle database performance is low, of course, the reasons for the low performance of Oracle database is various, we can through some correct design and diagnosis to try to avoid some Oracle dat