Tags: srvctladdserviceSrvctl Add ServiceThe parameters are as follows:-S: Service name-R: Preferred instance Name-A: alternate instance name-p:taf policy, with none,basic,preconnect three values selectable-D-pdbSrvctl Add service-help View the meaning of each parameterIf-pdb is not specified here, it is connected to the CDB, which is required to remotely clone the PDB and set TNS.Srvctl add
portal for information;4. Flexibility to adapt to business changes;5. Monitor critical business interfaces;6. Optimize business processes and improve economic efficiency;7. Component reuse, reduce late development costs;8. Loose coupling, high cohesion can adapt to business change of the latest IT architecture;9. Service Management visualization, can be seen throughout the life cycle of services;V. Related Products
The program leverages
value that does not exceed 65536, because the upper limit for each IP packet is 65,536 bytes.The sb_max--tunable parameter sets the upper limit for the number of socket buffers queued for a single socket, which can control the total amount of buffer space used by the buffer (queued for sender or received sockets). This amount should normally be less than wall and approximately 4 times times the maximum value of TCP or UDP send and receive settings.The rfc1323--tunable parameter supports the TCP
Tags: blog io os ar using for strong SP files1. How do I know if a 12c db is a container database? (1) Container DBSql> Select CDB from V$database;CDB---YES(2) Non container DBSql> Select CDB from V$database;CDB---NO2. How do I view all the PDB? Sql> select Name, Open_mode from V$pdbs;NAME Open_mode------------------------------ ----------Pdb$seed READ only PDBORCL mounted PDB1 READ WRITE 3. How do I open a PDB? Sql> Show Con_nameCon_name-------------
configured on the database, not the size of the database. In previous releases, we were unable to run the upgrade program in parallel to quickly complete the upgrade process.In 12c R1, the original Catupgrd.sql script was replaced by the catctl.pl script (parallel upgrade feature) and now we can run the upgrade in parallel mode.The following procedure describes how to initialize the parallel upgrade feature (3 procedures); You need to run this script
With the rapid development of cloud computing, mobile and social technology, the role of enterprise data centers is constantly changing. Enterprises need stronger computing capabilities, simpler IT architecture, and more controllable O M costs. The individual software and hardware cannot meet all the requirements of enterprises. The integration system, chip and storage, and the integration of software and hardware in the IT architecture have been recognized and demanded by more and more users,
Efficient development-a unified, fully standard, metadata-based graphical development tool. Build an integrated application
High performance and scalability-performed on high-performance Oracle Weblogicserver, intact cluster and disaster recovery mechanisms
Service components-high performance, multi-protocol service
/network/admin[Email protected] ~]$ ls/opt/oracle/12c/network/admin/Listener.ora Samples Shrept.lst Sqlnet.ora22. After the installation is complete, you can see if port 1521 is up[Email protected] ~]$ NETSTAT-TULNP |grep 152123. Add a DB instance, modify the Dbca.rsp file[Email protected] ~]$ VIM/OPT/ORACLE/DATABASE/RESPONSE/DBCA.RSPResponsefile_version = "12.1.
Summary of the new features of Oracle 12c on business impact (1)
1. invisible fields
In Oracle 11g R1, Oracle introduces some good enhancement features in the form of invisible indexes and virtual fields. Inherit and develop the former, and introduce the invisible field idea in Or
Oracle cloud control 12c startup and shutdown, cloud12c
The entire installation of Oracle cloud control 12c is complicated. The installation path, logon password, port number, and many other configurations are confusing. This article describes how to obtain the various port numbers, URLs, and how to start and disable c
Install Oracle 12C and linux7centos7 on LINUX7 (CentOS7)
Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.
Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/45021171
Lab environment: Oracle VM Virtu
Linux-install Oracle (CentOS-Oracle 12c) and centos7 install oracle12c
Step 1: network connection, which is described in my previous blog.
Purpose of network connection: to use the yum command, download the file directly online.
Step 2: Go to the oracle official website to download
Tags: Click home configuration Location 12c specific EM tool basic capitalizationOracle 12c R2 for windows_x64 installation 1. Installation Preparation 1.1 Download Oracle for Windows version
Official: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
1.2 Unzip the ZIP archive package file
Unzip the download
Tags: command execution wget Restart Speed Hyper Fusion is open OGGOracle 12c was released for a long time, although several sets of single-instance Oracle 12c have been deployed in the near future, there has been no opportunity to implement 12c RAC in the production environment, of course, can not eliminate the existi
Windows: 32-bit Oracle 11g client Windows version.
NET Manager tool to add a new "service naming"
15.
At this point, we can test to see if Linux can be connected to Windows.
Open cmd, enter: tnsping [the service name just set]
If not successful, it may be a Linux firewall problem, shut down the Linux firewall
Systemctl Stop Firewalld.service #停止防火墙Systemct
/acfsstd1-node qc550707
Root @ qc550707:/ gt; srvctl start filesystem-device/dev/asm/acfsvol_std1-48-node qc550707
Root @ qc550707:/> crsctl status res ora. acfsdg. acfsvol_std1.acfs-t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
Ora. acfsdg. a
Label:Convert Oracle 12c Database from Standard Edition to Enterprise EditionFrom: How to Convert the Oracle Database 12c from standard to Enterprise Edition? (Document ID 2046103.1) Applies To:Oracle database-enterprise edition-version 12.1.0.1 and later information in this document applies to any platform.GOAL How to
First of all, basic usage:First press 11G beforeConn/as Sysdba;Create user test identifed by test;
ORA-65096: The public user name or role name is invalid.
Check the official document that "trying to create a generic user, you will need to use C # #或者c # #开头", this time there will be doubt, what is common user? No matter how successful the first build.Create C # #user test identifed by test;Create success
Sql>show Con_name;
Con_name------------------------------Cdb$root
Selectcon_id,dbid,na
1 Connecting to CDBThe same connection as the normal instance. Specify that ORACLE_SID can use OS authentication later, or you can connect using a password.[Email protected]/]$ echo $ORACLE _sidCndba[Email protected]/]$ Sqlplus/as SYSDBASql*plus:release 12.1.0.1.0 Production Onmon APR 28 11:33:43 2014Copyright (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.