oracle olap 11g

, Oracle. All rights reserved.Connect:Oracle Database 11g Enterprise Edition Release 11.1.0.6.0-64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data MiningAnd Real Application Testing optionsSQL> shutdown the immediate database has been disabled. The database has been detached.The ORACLE routine

/ listener.oralistenerlogfile/u01/app/oracle/ diag/tnslsnr/rh64/listener/alert/log.xmllisteningendpointssummary... (DESCRIPTION= ( Address= (PROTOCOL=TCP) (host=rh64.cuug.cn) (port=1521)) (description= (address= (PROTOCOL=IPC) (KEY= EXTPROC1521)) Servicessummary ... service "Test1" has1instance (s) .instance "Test1",status Ready,has1handler (s) forthisservice ... ThecommandcompletedsuccessfullyTo test your network connection:[Email protected] admin]$

. Typical Installation6, the related configuration path, here need to pay attention to carefully check, management password is password, need at least one uppercase, a lowercase, a number, at least 8 bits7, the Inventory directory needs to be specified in the following Oracle, easy to find8, the detection through, the package is there, you can find, the upper right corner ignore can, and then click Finish9, long-time installation~]#/opt/

Oracle 11g Silent Installation Software + manual database creation Because it is a secondary jump + remote operation, the GUI cannot be used and cannot be directly installed on the GUI. Use silent software installation + manual database creation to complete the requirement. 1. Install the Oracle software in silent mode and configure the listener 2. manual databas

) RAC special problems and combat experience (V) ORACLE one-to-G Version 2 RAC ready for use with NFS on Linux (vi) ORACLE ENTERPRISE LINUX 5.7 under Database 11G RAC cluster installation (vii) ORACLE ENTERPRISE LINUX 5.7 Databases 11G RAC database installati

Oracle learning Data Warehouse (I) Import Oracle 11g Global samples schemaOracle 11g provides an example schema for the Data Warehouse. You can download the sample installation file through the following link. The http://www.oracle.com/technology/products/bi/olap/doc_sample_

1 start-> All Programs->oracle products->warehouse builder->administration->repository Assistant 2 in the Pop-up Repository assistant-welcome window click Next, and enter the following image page: 　 3 fill in the host name, Port number, and Oracle Services name (database service names), which we take ORCL for example, and click Next to go to the page shown below: 4 because we are using OWB

Oracle provides the scott user's re-creation script, and the 11G uses the script to create scott. The simple operation is as follows: SQL> select * from dba_users where username = 'Scott '; ------ SCOTT has been manually deleted. No rows selectedSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release

CentOS6.5x64 install 64-bit Oracle 11g in silent mode 1. Download the 64-bit Oracle11g source file and upload it to the Linux server. 2. Package installation check and installation: Install the tool using yum: Yum-y install binutils compat-libstdc ++-33 elfutils-libelf-devel glibc-common glibc-devel gcc-c ++ libaio-devel libaliblibgcc gcc stdc + + libstdc ++-devel make sysstat unixODBC-devel pdksh numactl-d

: Connected to: Oracle Database 11g Enterprise Edition release 11.2.0.3.0-64bit Production With the partitioning, OLAP, Data Mining and real application testing options Sql> third, the database builds the storehouse Enter the command DBCA in the current terminal window and eject the library interface. [Oracle@local

1. automatic Installation selected during installation. Because the user name and password have been forgotten for a long time, I have tried several default user names and passwords (The table contains the default user name and password ), the user name and password are all invalid. Finally, you have tried dbsnmp/dbsnmp, prompting you to be locked;2. Log On With sqlplus/as sysdba. The prompt is displayed.3.SQL> alter user dbsnmp account unlock;User altered.SQL> alter user dbsnmp identified by db

Label:Oracle 11G RAC cluster installation (vii) Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review

Oracle 10g and Oracle 11g hand-built case--oracle 10gSystem environment:Operating system: RedHat EL6Oracle:oracle 10g and Oracle 11gThe Manual construction of the library is relatively easy to implement, this case is from 10g and 11g