Oracle

Oracle Express Edition 11g was installed today, but after the installation is complete, unable to open the database home page is: 127.0.0.1:8080,baidu,google on the internet for how long, various methods used, such as modifying the port number, etc.,

Recently encountered a case:Status: HP-UX operating system, Oracle 10.2.0.4 RAC, MCSG mode, 2 OCR and 3 voting disk each correspond to one LV in the same concurrent volume groupPurpose: To mirror shared storage, the technology used is HP's own HP

--Create Target library dblinkcreate database link target library connect to account identified by "password" using ' IP Address: port/target library '; --Query created Dblinkselect owner,object_name from dba_objects where object_type= ' DATABASE

Working with Oracle database the same way you do other databases in the front edge example is also very easy, slightly different from the small differences in SQL syntaxInquireCustomizing display field names@{datas:@{for:getsuffix}}Customizing the

Yesterday in the middle of the night to install a rh5+oracle version, during the encounter a few things, stated as follows, as the basis. 1. Before installation, you need to configure the kernel parameters, can refer to the Oracle Official document

1. Hardware environmentIBM X3850 X5 Server 4 CPU 10 cores2 Software EnvironmentWindows R2 Enterprise Edition, Oracle 11.2.0.1Today in the customer site to install the Oracle process is smooth, software, monitoring are installed, and finally in the

Original address: http://yanwushu.sinaapp.com/oracle_extract_year_month_day_valu/Previously, the To_char (Timefield, ' YYYY ') method was used to get the year field value in the date. The efficiency of this method is certainly not high, in order to

Crontab-eNo crontab for root-using an empty oneCrontab:installing New Crontab"/tmp/crontab. Jkmaak ": 1:bad minuteErrors in crontab file, can ' t install.Want to retry the same edit?Enter Y or NWant to retry the same edit? YCrontab:installing New

Add Standby LogMain Library parameter file:crm.__db_cache_size=8254390272crm.__java_pool_size=33554432crm.__large_pool_size=33554432Crm.__oracle_base= '/u01/app/oracle ' #ORACLE_BASE set from environmentcrm.__pga_aggregate_target=3288334336crm.__sga_

This afternoon encountered a very strange problem, under the Windows platform Sqlplus/as SYSDBA log in the database, prompting insufficient permissions,At that time, I was wondering, sys user Login database can also insufficient authority, the

Plsql connecting Oracle requires local installation of Oracle client (download in the attachment): After downloading the file, put it in any directory, for example D:\instantclient_10_2 Modify the Tnsnames.ora file, the first line to fill

Copy the statistics from the production library to the development library for tuningBefore confirming the execution plan1. Import the optimization statistics of the production environment into the development environmentdo not collect optimization

The method of launching Scott users in Oracle, in Oracle11gr2, (g for ' network ') in the database Scott this user is locked during installation, when you install Oracle, you can directly choose to unlock the user, if you forget to understand the

Oracle Study Note: Tablespace and Data Files, oracletablespace 1. how to create a tablespace that employs the most common features 1 create tablespace tb_name #create bigfile tablespace tb_name2 datafile ‘/u01/dbfile/orcl/tb_name.dbf’3

Automatic backup script for Oracle databases in Windows @ Echo off echo ============================================ ================= echo in Windows environment, the Oracle database's automatic backup script echo 1. use the current date to name

Log File mode in oracle There are two log modes in oracle Database: Non-archive log mode and archive log mode. In the oracle database system, to prevent the contents of log files from being overwritten during cyclic use, the oracle System Copy and

An error occurred while uninstalling oracle11g. the file cannot be deleted. The file is in use.When you uninstall oracle11g After the service is stopped, run C: \ myoracle \ think \ product \ 11.2.0 \ dbhome_2 \ deinstall Deinstall. bat in You

Oracle uses triggers to implement auto-increment Columns Oracle uses triggers to implement auto-increment Columns Oracle does not have the auto-increment function. mysql and sqlserver use auto_increment and identity () to implement auto-increment

Set up VNC Remote Desktop Connection in Linux to install Oracle11GPreface:在linux下面进行oracle安装，需要启动java的swing界面，所以需要x-window窗口，那么就需要直接去服务器机房去现场操作挺麻烦，远程xshell无法视窗，这种情况下可以采用vnc的模式远程连接linux系统的视窗来进行远程安装oracle。1. Check whether the VNC service has been

[ORACLE] processing of oracle string objects 2.1 char field, varchar2 Field (1) Defining the field length char (10) indicates that the field can contain 10 English characters (regardless of the encoding method, do English characters occupy 10 bytes ?