oracle 12c books

) (host=oracle12c) (port=5500)) (Security= (my_wallet_directory=/u01/app/ Oracle/admin/orcl/xdb_wallet)) (presentation=http) (Session=raw))Services Summary ...Service "7351E8AE5372218EE0539B6BA8C08D05" has 1 instance (s).Instance "ORCL", status ready, have 1 handler (s) for the This service ...Service "ORCL" has 1 instance (s).Instance "ORCL", status ready, have 1 handler (s) for the This service ...Service "Orclxdb" has 1 instance (s).Instance "ORCL"

First, the environmentService side: Oracle 12.2.0.1 RACClient: Less than Oracle 11.2.0.3Second, the phenomenonWhen using a less than Oracle 11.2.0.3 client version connection to the Oracle 12.2.0.1 RAC database "Ora-28040:no matching authentication protocol"Third, solve the problemMethod One: According to the official

The entire installation of Oracle cloud control 12c is more complex, just the choice of installation path, login password, port number and many other configurations are confusing, dizzying. This article describes how to get installed after the installation of the various types of port number, URL and how to start, close the cloud control and so on for your reference.For the installation configuration of clo

Label:Installing Oracle 12c on Windows 7 64-bit does not have a set character set, using the operating system default character set: we8mswin1252, modify the character set to: ZHS16GBK. Because the process is irreversible, you first need to back up the database. 1. Fully prepared database 2. Querying the current character set PARAMETER VALUE ---------------

Tags:control1.0targedbf table spaces archappend backup strategy home Oracle 12c Backup and recovery strategy (Rman Backup [Open Archive/control file/data File/Archive log]): Backup strategy: * Make a full backup of the database (including all data and read-only tablespace) every six months * once a week level 0 backup * One level backup per day * Pre-backup set R Man parameters: Configure Controlfile auto

Label:Before 12c, if you want to achieve the automatic growth of column, usually through the sequence, but this problem is resolved in 12c, Oracle deferred the identity column function, which solves the previous problem perfectly, here is my simple test, For reference! Sql>Alter pluggable databaseAllOpen Pluggable database altered. Sql>Select Name,open_modeFrom

Label:Set NON-CDB to read-only mode: $ sqlplus'/as sysdba'SQL>SelectName, Decode (CDB,'YES','multitenant Option enabled','Regular 12c Database:')"multitenant Option", Open_mode, con_id fromv$database; NAME multitenant Option open_mode con_id--------- -------------------------- -------------------- ----------TEST Regular 12c database:read WRITE0SQL>shutdown immediate; SQL> startup open Read only; Connect to

/asm-diskechmod 660/DEV/ASM-DISKFchmod 660/dev/asm-diskgForgot to edit the kernel parameters vi/etc/sysctl.confFs.file-max = 6815744Kernel.sem = 250 32000 100 128Kernel.shmmni = 4096Kernel.shmall = 4294967296Kernel.shmmax = 4398046511104Kernel.panic_on_oops = 1Net.core.rmem_default = 262144Net.core.rmem_max = 4194304Net.core.wmem_default = 262144Net.core.wmem_max = 1048576FS.AIO-MAX-NR = 1048576Net.ipv4.ip_local_port_range = 9000 65500This article is from the "vmware/

Required Pam_limits.so 8.2 Editing the limits.conf configurationvim /etc/security/limits.conf #在内容末尾添加以下数据#单用户可使用的进程数量Oracle Soft Nproc 2047Oracle Hard Nproc 16384#用户可打开的文件数量Oracle Soft Nofile 1024Oracle Hard Nofile 65536#堆栈设置Oracle Soft Stack 10240 9. Edit Profilevim /etc/profile #在内容末尾添加以下语句if [$USER = "

Oracle Trace File Analyzer (TFA) Collector. 2017/01/11 03:05:29 Clsrsc-363:user ignored prerequisites during installation OLR initialization-successful2017/01/11 03:06:43 clsrsc-330:adding clusterware entries to file ' oracle-ohasd.conf ' Crs-4133:oracle High Availability Services have been stopped.Crs-4123:oracle Hig

Environment: WIN7 64-bit + Oracle 12c (12.1.0.2.0)Mode: Graphical InstallationLog on to the system as an administrator:1 Double-click the setup.exe in the database directoryRemove the check for "Receive security updates" and click Next.2 Wait for some time to appearI have an error INS-30131 here:For example, after starting the Server service, normal:3. 5.6.7.8.9. Note that the password set he

Oracle If you go to a computer bookstore now, you'll find that books related to Oracle technology will occupy a lot of space in bookstores. In these books there are many fine, but certainly some dross mixed with, for fine, we might as well read, for those patchwork of books

The problem originates from a 12c database of the customer and needs to be booted to a non-real time apply mode, but the discovery is performed:ALTER DATABASE recover managed standby database cancel;ALTER DATABASE recover managed standby database disconnect from session; After that, the database is still working in the real time apply mode. Went to the alertlog for a while, found the answer: Thu June 09 12:16:03 2016Errors in FILE/CUST/MYDB/RDBMS/

Label:In previous versions, the parent table could not be truncate directly when there was a foreign key constraint. In 12C, a cascade operation attribute was added to the truncate operation. If you create a FOREIGN key constraint, use "on Delete Casacde". Test script: Sql>drop table child; SQL>drop table parent; SQL>CREATE TABLE parent (ID number primary key); SQL>CREATE TABLE Child (CID number primary key,pid number); SQL>ALTER TABLE child add cons

Oracle Soft Nproc 2047 >>/etc/security/limits.confecho Oracle hard Nproc 16384 >>/etc/security/limits.confecho Oracle Soft nofile 1024x768 >>/etc/security/limits.confecho Oracle hard Nofile 65536 >>/etc/security/limits.conf#vi/etc/pam.d/loginecho Session required/lib/security/pam_limits.so >>/etc/pam.d/loginecho Sessi

Oracle 12c agent install for windows, oracle12c There are two methods to deploy the agent in Oracle EM12c: one is to install the agent "push" directly to the managed end through the EM12c console through ssh, this method is relatively simple on the OMS and the managed end of the linux platform, because the Linux platform has its own ssh tool and does not require

Tags: des style blog http color using strong AR forArcSDE 10.2 for Oracle 12C Installation considerations1. Environmental descriptionOracle 12C is supported starting from ArcSDE10.2.1.2, Installation precautionsThe SDE space database can be installed in the PDB and created using the Create Enterprise geodatabase tool, with no difference between the installation m

Install Agent AgentIn the em11g, agent installation is through the host side of the producer to download Agent agent and installation, on the EM12C version, on the EM12C server, through the "push" way the agent agent in the remote installation to the monitored host side, You can also install agent agents for multiple hosts at the same time.Official documents:Http://www.gokhanatil.com/2011/10/how-to-deploy-oracle-management-agent.htmlInstallation metho

This article mainly introduces the basic management of CDB and PDB, data source Oracle official.Basic concepts:Multitenant Environment: Multi-tenant environmentCDB (Container database): DB containerPD (Pluggable database): pluggable databasesCDB vs. pdb diagramCOMMON users (ordinary users): often built on the CDB layer, user name in C # #或c # #开头;Local Users: Only the PDB layer is established, and container is specified when it is established.In

/dwjrdbpdb/undotbs01.dbf '2018-07-05t23:42:22.481081+08:00Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/DWJRSTDYDB/DWJRSTDYDB/TRACE/DWJRSTDYDB_M000_129832.TRC:Ora-01110:data file One: '/u01/app/oracle/oradata/dwjrstdydb/dwjrdbpdb/users01.dbf ' Refer to MOS Documentation:ORA-01110 for all Files in Standby Database (document ID 2322290.1) ChangesNew or upgraded Standby on 12.2.0.1 Cause Unpublished Bug 24844841:ph