how to create database service in oracle 11g

access/etc/x11/xinit/xinitrc:no such file or Directory[[emailprote CTED] ~]# Find/-name xinitrc[[emailprotected] ~]# adopted the scheme is to comment out/root/.vnc/xstartup inside the EXEC/ETC/X11/XINIT/XINITRC , let Vncserver choose the default, let VNC load the default graphical interface program It's OK.--------------------------------------------------------------------change the permissions of Xstartup This is a problem that many people tend to overlook, is also the cause of the black scre

The name of the database to be created is dbshop 1: create the required directory export oracle_sid = dbshopmkdir-p $ oracle_base/oradata/$ export-p $ oracle_base/admin/$ oracle_sid/adumpmkdir-p $ oracle_base/admin/$ oracle_sid/bdumpmkdir- p $ oracle_base/admin/$ oracle_sid/cdumpmkdir-p $ oracle_base/admin/$ oracle_sid/udumpmkdir-p $ oracle_base/admin/$ oracle_sid/pfile created in the $ ORACLE_HOME/DBS dire

oracle user, and create a file named enterprisejy in the/home/oracle directory. rsp file. The specific content is as follows (see the db_install.rsp file under the/oracle/database/response directory.[Oracle @ jyrac1 ~] $ Vi enter

Today, a friend asked me why 11g exp files cannot be imported into 9I? Due to the incompatibility of exp/imp tools, when importing a database of a higher version to a lower version, you need to use the exp/imp tool of a lower version for import and export. A friend used 9i exp to export 11G data and then import imp to 9i. The import is normal. However, I reported

ORACLE 11G Official documentation Demonstration: Search for manual database creation statements, oracle11g Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright. Deep Blue blog: http://blog.csdn.net/huangyanlong/articl

Tags: python oracle cx-oraclePreparation: 1, download the corresponding version of Oracle-instantclient (I here is 11.2.0.1.0)http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html2. Installation-ivh oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm3. Configure Environment variablesLD

Applies To:Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterInformation in this document applies to any platform.CauseA hang is possible in earlier versions of RDBMS as a result of an unpublished bug fixed in the following versions: 12.1.0.1 (Base Release) 11.2.0.2 (Server Patch Set) 11.1.0.7 Patch 42 on Windows PlatformsDocument 9776608.8 Bug 9776608 - Hang from concurrent login to same account with a wrong passwordEven with

instance started.Total System Global Area 835104768 bytesFixed Size 2257840 bytesVariable Size 536874064 bytesDatabase Buffers 289406976 bytesRedo Buffers Copy hot-prepared data files to the original data file directory[[emailprotected] PROD]$ cp /home/oracle/bak/*.dbf ./ ——拷贝数据文件到以前的数据文件目录[[emailprotected] PROD]$ exitexit[emailprotected]> select open_mode from v$database;

Replace (char, str1, str2)Replaces every occurrence of str1 in char with str2. Length (char)Returns the length of the char. Initcap (char)Changes the first character of each element in Char to uppercase. Power (m, n)Multiplies m to the power N. SQRT (N)Returns the square root of N. Current_timestampReturns the current timestamp along with the time zone offset. YearYear spelled out. For example:Select to_char (sysdate, 'Year') from dual ;------- Twenty eleven WWWeek of year. For example:Select to

First select your system version, 32-bit system Select 32-bit, 64-bit system can use 32-bit can also use 64-bit, recommended 64 bits! Oracle Database 11g 2nd edition (11.2.0.1.0) for Microsoft Windows (32-bit)Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zipHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2

As a corporate network manager, I know that website security and access efficiency are important elements related to whether an enterprise can do well. The most important thing is the security of customer data. As a corporate network manager, I know that website security and access efficiency are important elements related to whether an enterprise can do well. The most important thing is the security of customer data. As a corporate network manager, I know that website security and access e

As a corporate network manager, I know that website security and access efficiency are important elements related to whether an enterprise can do well. The most important thing is the security of customer data, of course, a good database is indispensable. I have tried many databases, such as Access, mysql, and Oracle. However, it is safer to analyze the security of jsp sites. Why, because there are not many

Oracle RAC Listener configuration is the same as the single-instance configuration11g after installing the RAC process, do not need to execute NETCA to manually create the monitoring, when installing the cluster software, will automatically create a listener;The Tnsname.ora file is created automatically when the DBCA is built.Strongly recommend this article:Http:

1. installation environment: Fedora 10 (kernel version: 2.6.27.5-117. fc10.i686) Oracle Database 11g Release 2 (11.2.0.1.0) (Register and download the corresponding Linux x86 version on the Oracle website) 2. References: Oracle Database