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
.16. We create and configure the database.17. Then select the server class to install the most powerful features.18. We select the Single instance database installation.19. We choose a typical installation.20. We choose to use the Windows built-in account.21. Next we click Yes.22. We configure the following, install the Enterprise version, in addition we based on learning, password does not need to be too complex.23. Next we click Yes. Skip password detection.24. We check the environment to see
. Enable administrative share for C $ (please check with your System Admin to do this or see Microsoft document Http://suppor t.microsoft.com/kb/314984) 2. Check that it was OK: -net use \\-the current user (i.e. user in Administrator Gr OUP) should has all privileges on the default share 3. Retry the installation 4. Remove the administrative share again B) Check if Windows services "Oracleremexecservice" is running Check if Windows services "Oracleremexecservice" is running,
) (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 inst
nomodify notrap This sentence is added manually, meaning that the server from 10.62.1.1-10.62.1.254 can use our NTP server to synchronize time. The server 192.168.146.225 is also manually added, indicating the IP on the local area network as the NTP server; the last two lines of the configuration file serve to provide time service to the client in local time when the server loses contact with the public time server. #chkconfig ntpd on /Configure N
1. View host and database information [[emailprotected] ~]$ sqlplus/as sysdbasql*plus:release 12.2.0.1.0 Production on Tue May 01:19:35 2018copyright (c) 1982, Oracle. All rights reserved.connected to:oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit production nbsp Sql> set linesize 300set pagesize 999select * from V$version;bannercon_ ID-------------------------------------------------------
Oracle 12C joins a very innovative feature, pluggable database, that enables database (PDB) pull-out capabilities on the "container" (CDB) to improve system resource utilization and simplify the management and migration of large-area databases.now let's tryThe operations of the CDB and PDB for pluggable databases are:Basic information:Root container (CDB): CUPPluggable Database (PDB): TEATo start the root c
with your System Admin to do this or See Microsoft document http://support.microsoft.com/kb/314984)2.Check that it is OK:-Net use \\-The current user (I. e. user in administrator group) shocould have all privileges on the default share3.Retry the installation4.Remove the administrative share againB) Check if Windows services "OracleRemExecService" is runningCheck if Windows services "OracleRemExecService" is running, this service gets created during
physical host.4, choose three virtual machines, these virtual machine on different physical host server. Of these, two are used to install Oracle software, and the remaining virtual machine installs Openfiler as an iSCSI service. Ceph can be used directly for Oracle, but it is also cumbersome to configure.Assuming any physical server fails, the virtual machine o
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.
sentence is manually added, This means that the server from 10.62.1.1-10.62.1.254 can use our ntpserver to synchronize time.The server 192.168.146.225 is also manually added, indicating the IP on the LAN as the NtpServer, and the last two lines of the configuration file serve to provide time services to the client in local time when the server loses contact with the public time server. #chkconfig ntpd on/configure NTPD service boot itself boot #
] databasename>-servicename> Also add Tnsname.ora records: = = = = = Scan-= 1521
) )
= = dedicated)
=
Das)
)) Start Service: [[email protected] bin] - -Service Das To test the connection: SQL> connect sys/oracle@das as SYSDBA
Connected.
SQL> SHOW con_id;
con_id
3
SQL> SHOW con_name;
Con_name
PDB01 3. Switch using the comm
Tags: oracle 12C RAC cluster log ([Email protected] ~]$ AdrciAdrci:release 12.2.0.1.0-production on Thu Mar 1 09:25:45 2018Copyright (c) 1982, Oracle and/or its affiliates. All rights reserved.ADR base = "/u01/u01/grid"Adrci> Show HomesADR Homes:diag/asm/user_root/host_3751460993_107diag/asm/user_grid/host_3751460993_107Diag/asm/+asm/+asmDiag/crs/shurkcs/crsdiag/
Many times, we do a small batch of data migration will use the data pump, but 12C we want to configure TNS to specify the PDB import, but the public service we are through the cluster using SRVCTL to create. At this time preferred instances may have multiple values. If your DMP file is not mounted through shared storage, then DMP must be uploaded to a node to store it for the corresponding directory creatio
. Executes the root.sh script after the installation is complete.3.1. Run the installation script$Grid _home/gridsetup. SH3.2. Select Configure Grid Infrastructure for a New Cluster and click Next3.3. Select Configure an Oracle Standalone Cluster, then click Next3.4.scan-name to be the same as Scan-ip in/etc/hosts, cancel the GNS and click Next3.5. Choose Add node, fill in Public-ip and virtual-ip hostname, then select all nodes, click SSH connectivit
Newly installed oracle12c, the new CDB and PDB users how to log on has been confused, after a night of search, finally resolved.
Sqlplus/nolog-conn/as SYSDBA Login to Oracle
Switch session to PDB under ALTER session set CONTAINER=PDBORCL
CREATE table space Create tablespace tablespace_name datafile '/home/oracle/var/data/tablespace_name.dbf ' size 500m autoextend on;
View table Spaces Selec
In an Oracle 12C database, if the PDBORCL service is not turned on, WebLogic is reported with the initialization or shutdown in progress of the PDB service when it is turned on. Therefore, it is necessary to use the SYS user to turn on the PDB server in Oracle.650) this.widt
To start the root container:[Oracle@eric ~]$ Export Oracle_sid=cup[Oracle@eric ~]$ Sqlplus/as SYSDBASql*plus:release 12.1.0.2.0 Production on Wed Jan 21 16:00:06 2015Copyright (c) 1982, Oracle. All rights reserved.Connected to an idle instance.Sql> Startup-----will not start all pluggable databases directly, if you want to start all pluggable databases, execute t
Use Toad for remote Oracle 12C data connection
1. Install Oracle12c on the local machine. If you want to install a database on the local machine, select to install data. If you only need to connect remotely, skip this step without installing a database,
2. Configure TNSNAMES)
1) Open the network configuration Assistant Under the oracle program
As shown in figure
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.