how to create database service in oracle 11g

Preface Aside from a few questions, I am a little satisfied with all the series of blog posts. For my own monograph, I will post an Oracle blog every day, and other blog posts will be posted in my spare time. Click Database Configuration Assistant to enter the Database Configuration. Of course, you can also enter the dbca Startup Program on the console! Th

This article describes in detail the Oracle 11G failure to connect to the database instance troubleshooting ORACLE 11G If the report--enterprise Manager is unable to connect to the database instance, you can troubleshoot the prob

Startup Alter system register; Then run the lsnrctl status Command to display the following information: LSNRCTL for Linux: Version 11.2.0.1.0-Production on 27-JUL-2012 14:53:28 Copyright (c) 1991,200 9, Oracle. All rights reserved. Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = drum) (PORT = 1521 ))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.1.0-Production

The simple reason: When the diagram is convenient to not enter the database, directly in the datafile directory to delete the table space corresponding data fileresult in subsequent database error and cannot delete table spaceerrors are as follows;Ora-01116:error in Opening database * * * *Ora-01110:data file: '/home3/datafile/arrange/newarrange.dbf 'Ora-27041:un

\ORADATA\AGRISK\REDO01. LOG ' to ' F:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO01. LOG '; the database has changed. sql>alterdatabaserenamefile ' D:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO02. LOG ' to ' F:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO02. LOG '; the database has changed. sql>alterdatabaserenamefile ' D:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO03. LOG ' to ' F:\APP\ADMINISTRATOR\ORADATA\AGRISK\REDO03. LOG ';

1. View database Information Show parameter instance_name Show parameter Db_name Show Parameter Service_Name Select dbid from V$database; 2. Normal Shutdown database Sqlplus/as SYSDBA Sql>shutdown Immediate 3. Start database to mount mode Sql>startup Mount 4. Confirm that the listener is activated. Lsnrctl s

the dialog box, select the Oci.dll file in the instantclient-basic-windows.x64-11.2.0.4.0 folder in the OCI library, and in the SQL *plus "Select the instantclient-sqlplus-windows.x64-11.2.0.4.0 folder in the SQL PLUS file as shown in. Click "OK"; 4. Restart the NAVICAT program, select "Connect", in the pop-up drop-down menu select the type of database that needs to connect, the author uses the Oracle

Tags: message size span decompression condition Password Direct operation electronic1. After extracting the Oracle compressed files, open the directory and double click "Setup.exe" to start the installation. 2. "Oracle Universal Installer" window pops up 3, e-mail prompts, follow the default next action 4, the second step directly according to the system default, click ' Next ' 5. Install desktop class by d

Oracle Database 11g For Windows 7 flagship version installation, 11gwindows7 System Environment: win7 32-bit System Installation steps: 1, Oracle (Oracle) official website download suitable for their own database installation pac

In Oracle 11 g2, duplicating a database has two methods: 1. Active database duplication2. Backup-based duplication The advantages of using duplicate for a database are:Test backup and recovery proceduresTest an upgrade to a new release of Oracle DatabaseTest the effect of ap