oracle 11g end of life

Oracle 11g backup-based rman duplicate, rmanduplicateBackup-based rman duplicate command to create standby databasePrerequisites: ensure the backup of the original database and archive is completely visible to the standby end,It is assumed that the storage structure of all files, such as the source database and the target database, and log files, are identical;Co

different using this parameter to convert#SET Log_file_name_convert ', '----if the log file path is different using this parameter to convert#SET sga_max_size 200M----Set the SGA size#SET Sga_target 125MSET "Db_unique_name" = "Foou" COMMENT "is a duplicate"SET log_archive_dest_2= "Service=inst3 ASYNC REGISTERValid_for= (Online_logfile,primary_role) "SET fal_server= "Inst1" COMMENT "is primary"Nofilenamecheck;Keyword Explanation:Dorecover: Automatic recover operation after restore is completeNof

said my statement has a problem, use-help checked again, did not feel any problem ah. Is there any problem?When using DBCA to open the configuration database products, the original EM option becomes optional, then no problem, since the command line said I have errors, I use the graphical interface head, all the way to fill the past, static structure!But the results again told me not to think too much, at the end of the creation of the database, the e

Today, I heard colleagues talk about the Oracle password expiration, only to remember that the Oracle 11g Default user password is valid for 180 days, Oracle 10g Default User password is life. Oracle

OriginRecent 10g and 11g physical standby configuration experiments found that Data Guard is actually easy, but lacks good documentation. I was experimenting with the official documentation and thought it wasn't very clear.Google out of two PDF documents, read it feel much stronger than official documents. It may be useful for some friends to translate. I am also better acquainted with these two documents while translating. I have not translated Engli

installationOracle under Linux is in a running state after installation is complete. After restarting the machine, Oracle does not add Oracle to the Windows service as it did under Windows, and the Orcle service needs to be started manually under LinuxUnder Oracle User, execute the following commandEnter Sqlplus$ sqlplus/nologConnect to the database as SYSDBA an

pam_limits.so at the end Adding profile environment Profiles #vim/etc/profile at the end of the add if [$USER = "Oracle"] | |[$USER = "Grid"];thenif [$SHELL = "/bin/ksh"]; Thenulimit-p 16384ulimit-n 65536elseulimit-u 16384-n 65536fiumask 022fi Create users and groups and create the appropriate passwords #/usr/sbin/groupadd-g 501 OINST

Tags: strong software proc Elf terminal. So data BMS kernelSUSE11 virtual machine installation with Oracle 11g installation All the parameters required in this article are in the appendix to the end of this document.Create a new virtual machine, select SUSE11 After you start the virtual machine, select the second installationSelect languageSkip a CD CheckChoose a

Nls_lang=american_america. ZHS16GBK #设置Oracle客户端字符集 must be consistent with the CharSet set at Oracle installation, such as: ZHS16GBK, otherwise the data import and export Chinese garbled problemRunSOURCE ~/.ZSHRC(Bash User: source ~/.BASHRC)Make settings effective immediately4. Create the Oracle 11g Software Installa

crash, see how small y to simplify, help customers solve the truth of the problem together.After the truth is uncovered, you may not be hard to find, this is a common problem!So small y dare not neglect, hurriedly take out to share with you, sounded the red alarm!Phase 16, little Y will take you through a data center Oracle database outage Analysis journey.At the end of the article, provide specific alerts

* ERROR in line 1:ora-03113: End-of-file on communication channel--trying to manipulate the main library throw error Process id:4810 session id:28 Serial: Not connected to Oracle Sys@priocm> exit disconnected from Oracle Database 11g Enterprise Edition release 11.2.0.3.0 -Production with the partitioning, OLAP, Data M

Learning Oracle is a complex and tedious process. In the face of a vast array of Oracle official materials, new features, MOS materials and a variety of internal knowledge, we always feel overwhelmed. However, this is often the fun we keep, accumulate and pursue.In Oracle 11g, a third connection method that breaks trad

The complete uninstall of Oracle 11g servers and clients has changed with previous versions: first, prepare before unloading: Start-> setup-> Control Panel-> admin Tools-> Service Stop all Oracle Services. second, batch processing uninstall: Run H:\app\Administrator\product\11.2.0\dbhome_1\deinstall deinstall.bat batch file Uninstall, the whole code is as f

also very important, you do not directly point out that the first point password management, So I'm going to give you a hint here! Otherwise, you will die a terrible death if you do not point to password management. ) Password management (you're not directly sure?) Congratulations, the first point password management is the right! ） By the time we've finished installing Oracle 11g, we've found the "Pas

/packages/4. Install with RPM-IVHPS: Increase virtual memoryDD If=/dev/zero of=/swapadd bs=1024 count=4524288 create partition fileMkdir/mnt/swapCD/MV Swapadd/mnt/swapMkswap/mnt/swap/swapadd setting up swap filesSwapon/mnt/swap/swapadd Enabling virtual memoryFree-mSwapoff-v/mnt/swap/swapadd When you do not need to use the new virtual memory############################################Write/etc/fstab so that it is enabled at boot time:/mnt/swap/swapadd swap swap defaults 0 02. Create users and Gro

"Sqlplus" and the Sqlplus prompt in the console does not have such a command because the environment variable path is not joined to the Sqlplus path. Add it this way: right-click on "Run SQL command line" and view the properties as follows Copy the paths in the target, and then open the environment variablesSelect the path of the user variable, click Edit, and then at the end of the copy of the path to paste in, paste before you remember to ente

,USERNAME user name of the login system,SCHEMANAME,B.cpu_time spends Cpu time,STATUS,SQL executed by B.sql_textFrom V$session ALeft JOIN v$sql B on a.sql_address = b.addressand A.sql_hash_value = B.hash_valueORDER by B.cpu_time DESC--Identify Oracle's current locked objectSELECT l.session_id SID,s.serial#,L.locked_mode lock mode,L.oracle_username logged in user,L.os_user_name Login Machine User name,S.machine machine Name,S.terminal End user Name,O.ob

can start by using the "Oracle 11g", "Application Development", "SQL Developer or SQL Plus" connection in the application. note for the first time, when you use SQL Developer, you are prompted to specify the path to Java.exe, so don't specify your own java_home here (I just don't know, specify a JDK6, end up saying incompatible.) The following JDK paths can be

created, the default is to lock all the accounts are unavailable (except SYS and the SYSTEM account is available), it is recommended to point to the right of password management, the common Scott account to unlock and enter the password. 14. Unlock the Scott account, remove the green tick from the front, and enter the password. You can also enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle

management, the common Scott account to unlock and enter the password. 14. Unlock the Scott account, remove the green tick from the front, and enter the password. You can also enter a short password that you normally use, and you don't have to add numbers to the 8-bit size that Oracle recommends. Oh. 15. Similarly, passwords that do not conform to the rules are prompted. Don't worry about it, continue Y. 16. The installation is successful and com