Tags: TAF $ password 11g R2 silent disappears its chmodFirst, the installation environment based on trade secrets will not show. The basic configuration of the environment is understoodIntroduction to CENTOS7 operating system here Minimized installation, 2G memory, 20G disk space, 1-core CPU, CONFIGURED network ip:192.168.xxx.xxxSecond, the operating system before the preparation of work1. Log in to the operating system using the root user 2.yum Insta
Many DBAs are still at Oracle 9i or 10g, possibly because of the Oracle 11g price issue. This article will explain the installation of Oracle 11g under Windows 7, and I hope you can see some of the new features of 11g.
Recently un
,sysdate-1);Commit 2. Exporting and importing data Exp cannot be used because this is a new feature and EXP does not support Exp Test/[email protected] file=d:/call_log.dmp Tables=soa_call_logC:\users\administrator>exp Test/[email protected] file=d:/call_log.dmp Tables=soa_call_logExport:release 11.2.0.1.0-production on Tuesday June 16 16:49:27 2015Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.Connect to:
Solution to Oracle 11g installation in Windows 7, oracle11g
Many DBAs are still in Oracle 9i or 10g, probably because of the price of Oracle 11g. This article will explain how to install Oracle
Oracle 11g-oracle Startup and shutdownTarget:1. Understand the sequence of reading parameter files in oracle-11g startup;2. understand four states of Oracle;3. Master the method of State transformation. 1. Read the parameter file
install11. Use the Startup ScriptYou need to make some changes before using the startup script, mainly to configure the ORACLE_HOME_LISTNER variable.Vi $ ORACLE_HOME/bin/dbstartPut 79 rowsORACLE_HOME_LISTNER =/ade/vikrkuma_new/oracleModifyORACLE_HOME_LISTNER = $ ORACLE_HOMEOtherwise, an error is returned:[Oracle @ gtlions bin] $./dbstartFailed to auto-start Oracle Net Listene using/ade/vikrkuma_new/
Tags: Linux oracle System install Oracle 11g required installation package and related dependency package no softwareCat >>/tmp/rpm.txt Consolekit.x86_64Consolekit-libs.x86_64Consolekit-x11.x86_64Gconf2.x86_64Orbit2.x86_64Atk.x86_64audit-libs.i686Avahi-glib.x86_64Avahi-libs.x86_64Bc.x86_64Bind-libs.x86_64Bind-utils.x86_64Cairo.x86_64Cloog-ppl.x86_64Compat-db42.x8
, there is an error saying/etc/oratab read errors, can ignore. after waiting for 55 minutes, the database is created and then clicked, as shown in 3.1png below : 4, verify 2 Oracle Instances[Email protected] admin]$ sqlplus/as sysdba sql*plus:Release 11.2. 0. 1. 0Production onFri May A -: Geneva: - -Copyright (c)1982, the, Oracle. AllRights reserved. Connected to: Ora
/PROD1_db01/diag/rdbms/prod/PROD1/trace/PROD1_diag_26656.trc. There is no detailed information.
Later, we used the 10046 event to track the mount process and then saw a detailed prompt,
Alter session set events = '10046 trace name context forever, level 12 ';Trace file/d01/oracle/11.2.0/admin/PROD1_db01/diag/rdbms/prod/PROD1/trace/PROD1_ora_7764.trcOracle Database 11g Enterprise Edition Release 11.2.0.2.0-6
Many DBAs are still in Oracle 9i or 10g, probably because of the price of Oracle 11g. This article will explain how to install Oracle 11g in Windows 7, and hope you can see some new features of the 11g.
Not long ago, I uninstalled
Many DBAs are still at Oracle 9i or 10g, due to the possibility of Oracle 11g price issues. This article will explain the installation of Oracle 11g under Windows 7, but also hope that you can see some of the new features of 11g.Recently uninstalled its own Windows Vista sys
Failure Phenomenon
Oracle 11g Database Common user logon prompt ora-28002:the password'll expire within 7 days
[11:01:00oracle@dvd db_1] $sqlplus wang/oracle
Sql*plus:release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ora-28002:the password would exp
-Firewall-1-INPUT -m state –state NEW -m udp -p udp –dport 177 -j ACCEPT
:wq! #Save exit
Service iptables restart #restart
Gdm-restart #restart
Shutdown -r now #restart the system
Second, install Xmanager on the Windows client system
1. Download and install Xmanager Enterprise 3
Http://www.onlinedown.net/soft/32684.htm #英语原版
Http://www.downxia.com/downinfo/19164.html #汉化包
2. After downloading the installation software, open Xmanager Enterprise
3, then open Xbrowser, as shown below:
I
Http://blog.sina.com.cn/s/blog_7c855cf70100shrv.html
Oracle 11g and EM cannot be started. It may be because the IP address has changed. So I used the emca command to reconfigure Oracle em. The specific process is as follows:I: \ Documents ents and Settings \ geshaoqing> emca-config dbcontrol DB-repos recreateEmca started at 11:16:40Em configuration assistant 10.2
Oracle 11g has added a lot of functionality to backup and recovery, with varying degrees of performance, functionality, security, and operability.
This article describes the validation when Rman deletes an archive log.
In the previous version of 11g, Oracle's Rman was not tightly integrated with other log applications, so when Rman deletes the archive log, it d
This paper is compiled from Oracle documentation
Warehouse Builder 11g Architecture and components
Oracle Warehouse Builder is an information integration tool that can transform data into high-quality information using an Oracle database. The Oracle database is the central
?url= 43vmbt9oxnjylzky7j9n0orte6-erakxe-sqvj3r57lwpoiuas1gppbapxp2casp4b-ttxgi3f3fg63zcfxvvnipji5zaj8kncz1up4e4tu qq-pf-to=pcqq.c2chttp://blog.csdn.net/gaofeng2009123/article/details/8021150Http://www.linuxidc.com/Linux/2015-02/113222p8.htmLoginSimple inspection[Email protected] ~]$ sqlplus "/As SYSDBA"Sql*plus:release 11.2.0.1.0 Production on Sat Jan 24 14:51:10 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to:Oracle Database
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.