2018.5.13 issues encountered by Oracle

Source: Internet
Author: User

There is not enough swap space to install Oracle 11g

Right-click on the computer to open the properties to advanced system settings and then find the first setting to find advanced and then change the custom scope (cloud server is 16-10000) and then make sure it's done.

Show error after quick installation The Enterprise Manager configuration succeeds with the following warning, setting the environment variable oracle_unqname to the unique name of the database C:\app\Administrator\product\11.2.0\ Dbhome_1\bin\emctl.bat Start Dbconsole

The solution is
Into DOS

(1) View dbconsole status: Emctl status Dbconsole

Display: Environment variable ORACLE_SID not defined. Please define it.

(2) Reset environment variable: set oracle_sid = SID of Database

(3) Reconfigure Em:emca-config Dbcontrol db

The following is the display in the DOS window:
Microsoft Windows [version 6.1.7601]
Copyright (c) Microsoft Corporation. All rights reserved.

C:\users\administrator>emctl Status Dbconsole
environment variable oracle_unqname not defined. Please set Oracle_unqname to Da
Tabase unique name.

C:\users\administrator>emctl Status Dbconsole
environment variable oracle_unqname not defined. Please set Oracle_unqname to Da
Tabase unique name.

C:\users\administrator>set ORACLE_SID=ORCL

C:\users\administrator>emca-config Dbcontrol DB

EMCA started on 2018-5-13 8:50:50
EM Configuration Assistant, 11.2.0.0.2 official version
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID:ORCL
Database Control has been configured for ORCL
You have chosen to configure database control to manage databases ORCL
This action removes the existing configuration and default settings and re-executes the configuration
Do you want to continue? [Yes (Y)/No (N)]: Y
Listener Oracle_home [E:\app\Administrator\product\11.2.0\dbhome_1]:
SYS User's password:
DBSNMP User's password:
Sysman User's password:
Sysman User's password: e-mail address of the notification (optional):
Outgoing (SMTP) server for notifications (optional):
-----------------------------------------------------------------

The following settings have been specified

The database is oracle_home ..... ..... C:\app\Administrator\product\11.2.0\dbhome_1

The local hostname ....... Qichunlin .....
The listener is oracle_home ...... ..... C:\app\Administrator\product\11.2.0\dbhome_1
_1
Listener port number ...... ....... 1521
Database SID ..... ORCL-----
The e-mail address of the notification .....
Notification of the outgoing (SMTP) server ..... .....

Do you want to continue? [Yes (Y)/No (N)]: Y
2018-5-13 8:58:50 Oracle.sysman.emcp.EMConfig Perform
Info: Logging This action to C:\app\Administrator\cfgtoollogs\emca\orcl\emca_2018_05

2018.5.13 problems encountered by Oracle

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.