how to create database service in oracle 11g

Tags: www. ORACL book data. com github Source code download HTTP 11gBackgroundIn the search for the source of the book, the search to provide is required to download the C-currency. More stubborn (in fact, poor).In the preface to this book, it is mentioned that the source code can be downloaded from www.appress.com.The following is a link to the book on the site:https://www.apress.com/us/book/9781430229469ClickDownload Source CodeLinked to GitHub, you can download the relevant source code for th

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 #######################

Tags: database start-Stop1. Stop the databasesql> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.2. Start the databaseSql> startup;ORACLE instance started.Total System Global area 795127808 bytesFixed Size 1339456 bytesVariable Size 494931904 bytesDatabase buffers 293601280 bytesRedo buffers 5255168 bytesDatabase mounted.Database

Starting with 11.2, if the database chain is established with a username password that is incorrect, or if you need to change the database chain validation settings, and you do not need to rebuild the database chain, Oracle provides the syntax for ALTER DATABASE link. This

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 ..

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, Universa

Oracle 11g installation causes the database to fail to automatically collect statistics, oracle11g Recently, it was found that some 11 GB databases could not automatically collect statistics. Some View query results are as follows: SQL> select client_name, status from dba_autotask_client where client_name = 'Auto optimizer stats collect ';CLIENT_NAME STATUS------

Oracle 11g export database does not export empty tables, oracle11g Oracle11g may encounter such a problem. When using exp to export the entire database, this problem occurs, and empty tables in the database cannot be exported. Select * from all_all_tables aa where aa. owne

Http://www.oracle.com/technetwork/database/windows/downloads/index-093848.html http://blog.csdn.net/robin_he/article/details/7345842 Oracle 11g R2 11.2.0.3 Patch set for Winnt 32bit Do not explain the need to hurry down AH 115 closed public-sharing services This is the updated address need to register 115 users to protect their own network disk and then dow

Label:ORACLE_11G has 32-bit and 64-bit two versions, 64-bit computers can be installed in 32-bit versions, but 32-bit computers can not be 64-bit, if you are 64-bit, it is recommended that you install a 64-bit version.Install package Download 32-bitHttp://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_1of2.zip ;Http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_database_2of2.zip ;64-bit http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_database_1of2.zip

1. application scenarios:Environment:Host Name ip vip sid DiskGroupDb1 1.1.1.1 1.1.1.11 bkjia DATA1Db2 1.1.1.2 1.1.1.12 bkjiadb DATA2Expected results:Db1 and db2 can be backed up to each other. Here db1 is used as the master database, and db2 is used as the slave database to explain how to mount the disk groups DATA1, DATA2, and, all running instances bkjia and bkjiadb use virtual IP addresses as client acc

does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client.2. Install Oracle ClinetFirst download an Oracle 11g Client to the Oracle web

Label:There are 4 main architectures for Oracle databases: Physical storage structure Logical storage structure Memory structure Process structure I. Physical storage structureThe Oracle database is physically composed of system files stored on disk, which is the physical storage structure of Oracle.1.

/bp_oracle Directory=dump_dir dumpfile=bp_oracle.dmp version=10.2.0.1.0--Remove TablespaceDrop tablespace bp_oracle including CONTENTS and datafiles;--delete the user, and execute the statement carefully, the Cascade deletes all objects under that user.Drop user bp_oracle cascade;--Modify User passwordAlter user bp_oracle identified by bp_oracle; --Export database with no versionEXPDP bp_oracle/bp_oracle schemas=bp_oracle dumpfile=bp_oracle20120221

Today when configuring the Oracle Net Manager Configuration service naming is always unable to configure, the previously configured service name is not displayed, and then click the Green Add button does not respond, because I previously modified the Oracle\product\10.2.0\db_1\network\ Tnsnames.ora file under AdminLook

the web for PL/SQL Deleloper 64-bit version. However the Discovery PL/SQL Deleloper does not differentiate between 64-bit and 32-bit. It seems that we can only start with Oci.dll. According to the above error message, it appears that just install a 32-bit version of Oracle Client. 2. Install Oracle ClinetFirst download an Oracle

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

\11.2.0\dbhome_1\bin>sqlplus/as SYSDBA Sql*plus:release 11.2.0.1.0 Productionon Wednesday December 21 10:56:26 2016 Copyright (c) 1982, Oracle. All rights reserved. Connect to: Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-64bit Production With the partitioning, OLAP, Data miningand Real application tes

Create an Oracle database Create an Oracle database (taking Oracle10g as an example) There are two ways to create a database: one is to