how to create database service in oracle 11g

, and ORACLE_SID is an environment variable for the operating system. In the database connection process, ORACLE_SID must be consistent with the value of instance_name, otherwise error: Under UNIX: Oracle not available Win under: TNS: Protocol Adapter error The database instance name is also the Oracle server identity

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 uses parameter db_name to indicate that if a machine is loaded with multiple databases, then each database has a

Create an Oracle database (taking Oracle10g as an example)There are two ways to create a database: one is to create a database manually using a command line script; the other is to

. Execute the corresponding script for testing # Su-oracle $ Cd $ ORACLE_HOME/bin $./Dbstart (. /Dbshut) $ Ps-efw | grep ora _ $ Lsnrctl status $ Ps-efw | grep LISTEN | grep-v grep 4. Create a service $ Su-root # Cd/etc/rc. d/init. d/ # Vi oradbstart Copy the following Script 1 or script 2 to the oradbstart file: Note: (1) # The number of rows to start cannot be

OracleHow to Create a databaseDATABASE LINKWhat about it? In this article, we will use an instance to introduce the creation process. Next, let's take a look at this process. Multiple ORACLE databases physically stored in the network can be logically considered as a single large database. Users can access the data in the remote

Today, Oracle is automatically started and added to my machine. The process is as follows:1. Use the root user to modify the/etc/oratab file:$ Vi/etc/oratabOrcl:/oracle/app/product/10.2.0/db_1: NChanged:Orcl:/oracle/app/product/10.2.0/db_1: YThat is, change the last N to Y.2. Use the Oracle user to modify the $ ORACLE_

On the Linux platform, there are several steps to manually create a database: 1. Confirm the unique instance and database name; 2. Select the character set of the database; 3. Set the OS environment variables; 4. Create the initialization parameter file; 5. Start the instanc

successful.Step 2: creating new CSS ServiceSuccessfully created local CSS ServiceSuccessfully added CSS to home After the configuration is complete, the following entry appears in Windows Services: -- Check the status of the CSS daemon. D: Oracle10g> crsctl check cssdCSS appears healthyD: Oracle10g> Note: If you want to delete the CSS service later, you only need to execute the following command in Windows command: Localconfig Delete 3.

. -------------------------------------cut---------------line---------------------------------- Oracle Listener PROBLEM: First error: Registry uses optimized software to delete related items;For each system service is actually saved in the registry;Correlation item name in the registry: Hkey_local_machine\system\controlset001\services\oracleoradb11g_home1tnslistener;There is a imagepath:e:\oracleinstall

First, Background introductionAn enterprise production environment uses a WINDOWS2008R2 physical server to install Vcenter Server 5.5 and Oracle 11g databases, and the VC uses the system account to connect to the Oracle database. At the beginning of the installation of the password compliance is not clearly defined, ar

If you deploy an Oracle database system on a Windows operating system, the startup process is written to the service list of the operating system. And some major services will be set to auto start. In this case, the database is automatically started when the operating system is started. These services are also automati

In real-world development applications, about Oracle databases, it is often heard that a database is created, a instance is created, and a instance is started.Actually ask them what is the database, what is instance, most likely they give the answer is the database is instance,instance is the

System Environment: 1. Operating System: Windows 2000 Server 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition/Oracle 9i for NT Enterprise Edition3. installation path: D: \ oracleSteps:1. manually create related directories2. manually create an ini

Step 1: create a directory for storing database files and log files in the $ ORACLE_BASEoradata and $ ORACLE_BAS Step 1: create a directory for storing database files and log-related directories in $ ORACLE_BASE \ oradata and $ ORACLE_BAS Complete steps to manually create