PL/SQL Developer log on to Oracle 12c
After Oracle 12c is installed, PL/SQL Developer cannot connect to Oracle 12c. Search online and follow the instructions in fcflying, so take a note:
1) install
SQL Server played for some years and recently wanted to play Oracle, so I thought of playing with an Oracle server. The first time you install Oracle under Linux, the entire process references an article: http://blog.csdn.net/huangyanlong/article/details/45021171Environment: VMWare workstatrion 8.0.3Operating system: CentOS 7 x64Database:
Tags: img Install Oracle Advanced database Mode Gen Tag alias MCTHere, I am introducing the installation of the cloud Control 12c. The previous version is called Grid Control, which is also known as 11g. When I write this blog, the Cloud Control 13c has come out, this version follow me to introduce. Before installing, let's take a look at the overall architecture. First, it needs a database (that is, repo
Complete uninstall of Oracle 12c operation steps on Windows7
1. Turn off all Oracle Services and press "Win+r" to Run "services.msc" to find all services that begin with Oracle (oraclevsswriterorcl+oracleserviceorcl+ ORACLEORADB12HOME1TNSLISTENER+ORACLEORADB12HOME1MTSRECOVERYSERVICE+ORACLEJOBSCHEDULERORCL), click S
On April 9, June 2013, Oracle officially released Oracle Database 12C release 1. It is as follows: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
According to Sina Weibo, a well-known Chinese DBA, guobiao, Oracle 12c has new features su
The obsolete maintenance command crs _ *, 12ccrs _ in Oracle 12c RAC _
Crs_stat is commonly used in Oracle 10g and 11g RAC to monitor the running status of RAC. However, the crs_stat display is incomplete, so we will perform a secondary encapsulation of crs_stat to make the results look more fresh. For example:
In the
Tags: Oracle 12c change archive mode1.shutdown Normal or shutdown immediate close the databaseSql*plus:release 12.1.0.1.0 Production on Monday December 15 15:49:47 2014Copyright (c) 1982, Oracle. All rights reserved.Connect to:Oracle Database 12c Enterprise Edition Release 12.1.0.1.0-64bit Productionwith the partitioni
Tags: style blog color io data art arAn Oracle 12c database was installed today for testing, and an error occurred while running a very simple command:SQL> Show Con_nameconcat "." (Hex 2e) SP2-0158option "_name"Internet search for a long time also did not search, in Google incredibly only found a record, is a French blog, but it seems that he did not write the reason for the mistake. Finally looked at the
Label:12c has launched a pluggable database with multiple database PDB in the form of multiple tenants in a single container cdb. The data pump import and export for the PDB is slightly different from the traditional database. 1, need to add tansnames for PDB 2, import and export need to specify its tansnames value within the UserID parameter, such as Userid=user/[email protected] Data Pump Import and export example1. View the current SID, view the P
)Installation success again!!!650) this.width=650; "title=" 3.png "alt=" Wkiom1z-sckr21asaabkth_6vk8303.png "src=" http://s2.51cto.com/wyfs02/M01/ 78/7f/wkiom1z-sckr21asaabkth_6vk8303.png "/>Here are the followingWhat the Oracle-rdbms-server bag did.(1) Automatic installation of the RPM package required by Oracle(2) Automatically create Oracle users and group gro
Note: This article declined to reprint.1 MGMTDB InstructionsIn the installation of the Oracle 12.1.0.1 grid Infrastructure, you can choose whether to install the grid Infrastructure Management Repository (GIMR) database: Mgmtdb. Such as:In the grid Infrastructure 12.1.0.2, no options have been changed, and the MIMR database has become a mandatory option.In Oracle 12c
Tags: images virtual is the database management TOC various Sysstat graphical interface homeOracle database is a leading product in the field of database. It can be said that Oracle database system is currently the world's popular relational database management system, System portability, easy to use, strong function, applicable to all kinds of large, medium, small, microcomputer environment. It is a highly efficient and reliable database solution tha
Tags: vertical details system performance which fast SAP database combined bottleneck This article comes from reading notes on which is Faster HANA or Oracle 12C, and outlines the key points. Does not represent my point of view.Brief introductionSAP claims that Hana is the fastest database, so SAP's new ERP system S4 no longer supports Oracle A new feature of
Previously wrote an article by modifying the control file to modify the path of the problem, now use method two through rename to modify the path of the problemExperimental object: Two Linux stand-alone Oracle 12C databases (both large and small versions are consistent), data migration takes a cold backup way.Migration stepsFirst turn off monitoring, and kill the connected appPs-ef | grep Local=no | awk ' {
When installing ORACLE 12c on solaris10, the following error occurs: Soft limit: maxmum open file descriptors, filedescriptors.
-- Configure the maximum number of opened oracle files
The Solaris operating system has a limit on the number of opened files. The db_files parameter settings of the database are limited by the operating system parameters.
An environmen
How to automatically start PDB Pluggable Database in Oracle 12c
PDB Pluggable Database is an important new feature of 12c, but for PDB in CDB, all PDB is not brought when CDB is started by default, in this way, we need to manually alter pluggable database all open;
[Oracle @ clouds ~] $ Sqlplus "/as sysdba"
SQL * Plus:
1. OverviewThe Oracle EM11g database needs to be migrated. The main steps are as follows:
1. Disable OMS
2. Back up the current database and restore it to the new server.
3. Update OracleEM OMS database connection Configuration
4. Start OMS
This operation method is also valid in Oracle EM 12c.
2. ProcedureStep 1: Disable OMS
Find the emctl tool in the bin where O
Oracle Enterprise Manager Cloud Control 12c R4 installation ConfigurationPrepare Software
Em12.1.0.4_linux64_V45344-01.zip
Em12.1.0.4_linux64_V45345-01.zip
Em12.1.0.4_linux64_V45346-01.zip
Install the Operating System (OEL6.5)
After loading OS and CC for a space of more than 50 gb for the OS, 30 GB space is required. We recommend that you use at least 4 GB memory for 6 GB.
[
area storage, default path, then click Next23 Here I choose to use the same password for all accounts Wangfeiyu123, can also be for different usersSet a different password, then click Next24. Set DBA, Database Operations Group Oinstall, then click Next25, if the error is prompted, because the version of the installation package is different or the kernel parameters have a problem or less dependentSoftware, you need to resolve the error, and then click Next (if it does not match the next two fig
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.