Fulltext results:
- Oracle: SPFile and PFiles @info:oracle
- ====== Oracle: SPFile and PFiles ====== Oracle reads its parameters from a file called "SPFile". You can't change it directly as it's a binary file. Additionally, Oracle can read the parameters from "PFiles", which are ... FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora''. ===== Import
- Oracle @info:oracle
- ====== Oracle ====== ===== Pages ===== {{indexmenu>.}} ===== Bookmarks ===== * [[http://www.oracle.com/pls/db102/homepage|Oracle Database Online Documentation 10g Release 2 (10.2)]] * [[http://www.oracle.com/pls/db112/homepage|Oracle Database Online Doc
- Oracle Errors @info:oracle
- ====== Oracle Errors ====== ===== ORA-00257: archiver error. Connect internal only, until freed. ===== ... area]]. * **Documentation**: [[http://download.oracle.com/docs/cd/B19306_01/server.102/b14219/e0.htm#sthref181|10.2]] [[http://download.oracle.com/docs/cd/E11882_01/server.112/e10880/e0.htm#sthref197|11.2]] {{tag>database documentation error oracle reference}}
- Memory Usage of a Solaris Container (Zone) @blog:2010
- e bash> prstat -Z </code> From the [[http://docs.oracle.com/cd/E19082-01/819-2240/prstat-1m/index.html|pr... t -z zone -s size </code> From the [[http://docs.oracle.com/cd/E19082-01/819-2240/prstat-1m/index.html|pr... ne name or a numerical zone ID. See [[http://docs.oracle.com/cd/E19253-01/816-5175/zones-5/index.html|zone... on about ''prstat'', see the manual [[http://docs.oracle.com/cd/E19082-01/819-2240/prstat-1m/index.html|pr
- oracle @tag
- ====== oracle ====== ===== Pages ===== {{topic>oracle&nouser&tags}} ===== Bookmarks ===== {{rss>http://www.andunix.net/link/rss/all/oracle}}
- Oracle: List Accounts with Objects @info:oracle
- ====== Oracle: List Accounts with Objects ====== To list all accounts (users) the objects (like tables), ... DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME; </code> {{tag>admin oracle sqlplus}}
- Oracle: Resize Instance @info:oracle
- ====== Oracle: Resize Instance ====== In this example, the SGA will be resized to 6GB and the PGA to 2GB.... he instance to activate the change: <code sql> SHUTDOWN IMMEDIATE; STARTUP; </code> {{tag>admin oracle}}
- Oracle: EXP @info:oracle
- ====== Oracle: EXP ====== ===== Export all Objects from an Account ===== Enter the account name insteand... ode bash> exp USERID=\'/ as sysdba\' FILE={user}.dmp FULL=N OWNER={user} </code> {{tag>admin exp oracle}}
- Oracle: SQLplus Scripting @info:oracle
- ====== Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, enter ... OFF SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF </code> {{tag>oracle scripting sqlplus}}
- Oracle: Recovery Manager @info:oracle
- ====== Oracle: Recovery Manager ====== ===== Start Recovery Manager ===== <code bash> rman target / </co... G ALL COMPLETED BEFORE 'SYSDATE -3'; EXIT __EOF__ </code> {{tag>admin database dba oracle rman sysadmin}}
- VBoxManage (The VirtualBox CLI) @info:virtualbox
- output of ''VBoxManage'' without options. <code> Oracle VM VirtualBox Command Line Management Interface Version 4.2.16 (C) 2005-2013 Oracle Corporation All rights reserved. </code> ===== U
- IPS Repository Appliance @blog:2010
- wrote a good guide how to setup a [[https://blogs.oracle.com/observatory/entry/local_repository_mirror|Loc
- localeadm @info:solaris
- mand line interface. * man page: [[http://docs.oracle.com/cd/E18752_01/html/816-5166/localeadm-1m.html#