Oracle 18C database creation prompt ORA-12754 error Solution
In order to experience Oracle 18C, early in the morning on the https://edelivery.oracle.com/osdc/faces/SoftwareDelivery to install the media down.
First test the database
Tags: Oracle 18C new featuresThe Oracle 18c was released in 2018-02-16 or with Oracle's cloud first concept, and 18c is now available on cloud and engineered Systems. Oracle 18c claims
chronydmv /etc/chrony.conf /etc/chrony.conf_bakHere, the lab environment chooses not to use NTP and chrony, so that Oracle automatically uses its own CTSS service.2.2 Each node shuts down the firewall and selinux each node shuts down the firewall:systemctl list-unit-files|grep firewalldsystemctl status firewalldsystemctl disable firewalldsystemctl stop firewalldEach node shuts down SELinux:getenforcecat /etc/selinux/config手工修改/etc/selinux/config SELI
Oracle's home pathSu- oraclecd $ORACLE _home/bin3. Edit Dbstart and Dbshut files in the Oracle home directoryMain modification points:Modify multiple to $ORACLE _homeand modify the oraclebasehome_exec to the following.orabasehome_exec= $ORACLE _home/binPerform operational tests in the bin directory./dbshut and./dbstar
Tags: ges top nbsp Install share comment tab title OraclSet up software only the following comments are strange, and the previous software only different, for RAC install and to upgrade a Oracle Database; previously loaded once set up software only, Next time, post it.Only Oracle base, no Oracle Home,/
IP Planning and setting node name IP Configuration Table
Node name
P Ublicip
Vip
P rivate IP
Scanip
18cdbrac1
128.0.5.101
128.0.5.103
10.10.10.1
128.0.5.105
10.10.10.2
128.0.5.106
128.0.5.107
18cdbrac2
128.0.5.102
128.0.5.104
10.10.10.5
10.10.10.6
Dns
128.0.5.253
Storage Planning
Environment Introduction:Vmware12+redhat linux7.5 x86_64+oracle 18CSystem InstallationCreate a virtual hostSystem partitionSelect a desktop environmentPerform the installation processDescription1, the system installation, grid installation directory space requirements greater than 100G (before the installation of 12c requirements)2, after the installation of a database server, directly with the full cloning
Tags: default win klist ctime F11 ffffff Restart environment createFor environments that do not have shared storage, you can use the NFS-based ASM to configure the RAC. Here is a brief description of how to configure an NFS-based ASM service in an Oracle 18c RAC environment.1. Introduction to the EnvironmentAs shown in the host information used:2. NFS Server Configuration[[emailprotected] ~]# vi /etc/export
Question 2 SQL * Plus Copy commandProblem descriptionIn SQL * Plus, how does one implement data replication between different tables, whether local or remote?Problem AnalysisThe Copy command in SQL * Plus allows you to copy data between a remote database, a local database, or an Oracle database and a non-
What is a relational database? Oracle database architecture, Oracle cluster introduction, and oracle Architecture
What is a relational database?
Databases based on Relational Models.
What is a relational model?
Use rows and c
Disclaimer: This article transfers from the network article, reproduced this article only for the personal collection, shares the knowledge, if has the infringement, please contact the blogger to delete.Original LeshamiOriginal address: http://blog.csdn.net/leshami/article/details/5529239--========================================== --oracle Instances and Oracle Databases (
Oracle Cluster Concepts and principles (ii)
Overview: write down the original intent and motivation of this document, derived from the Oracle Basic operating Manual of the previous article. The Oracle Basic Operations Manual is a summary of the author's vacation on Oracle's foundational knowledge learning. Then form a summary of the system, a review rev
Oracle Database migration-basic and oracle database migrationOracle Database migration-Basics
As a developer, We must master database knowledge. However, the company's database is maint
How to permanently delete an Oracle database to create a database with the same instance name and an oracle instance
I chose the OMF method when creating the database today. The result file name is automatically named in Oracle. I
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.