how to create database service in oracle 11g

How to create a local database, create a new user, and assign permissions to an Oracle database 1. oracle can create a local database: Prer

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

Label:Reference: http://blog.csdn.net/huzia/article/details/7616717 Create environment variables, determine SID $ vim Rman. Env export Oracle_sid=rman export oracle_base=/opt/ORACLE export Oracle_home= /opt/oracle/11g Load Environment variables $ source Rman. Env Creating an initialization file CP/opt/

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

Directory Introduction to Directory Software Environment install Oracle Listener start stop listener CREATE database database name db_name database instance name instance_name database name and instance name the relational operat

Label:First, the database nameWhat is a database name?The database name is the identity of a database, just like a person's ID number. He used parameters Db_name says that if a machine is loaded with multiple databases, every database has a

Tags: silent installation of Oracle 11g database under LiunxSed-i ' $a fs.aio-max-nr = 1048576 '/etc/sysctl.confSed-i ' $a fs.file-max = 6815744 '/etc/sysctl.confSed-i ' $a kernel.shmall = 2097152 '/etc/sysctl.confSed-i ' $a kernel.shmmax = 536870912 '/etc/sysctl.confSed-i ' $a kernel.shmmni = 4096 '/etc/sysctl.confSed-i ' $a kernel.sem = 32000 '/etc/sysctl.confS

to manually delete the instance configurations:1. Delete all directories of $ ORACLE_BASE/admin/$ ORACLE_SID.2. Delete SID-related files and parameter files under $ ORACLE_HOME/dbs, including hc_bisal.dat, init. ora, lkBISAL, and orapwbisal.3. Delete the instances in/etc/oratab.4. You can run find.-name bisal in $ ORACLE_HOME to delete all instance-related files.Run dbca again to create a database with the

Label:Directory Directory Software Environment Objective Installing the Oracle Listener Start Stop Listener Create a database Database name Db_name DB Instance Name instance_name The relationship between the database