https://www.smithnet.org.uk/wiki/index.php?action=history&feed=atom&title=Oracle 2026-04-07T08:59:58Z Revision history for this page on the wiki MediaWiki 1.43.1 https://www.smithnet.org.uk/wiki/index.php?title=Oracle&diff=478&oldid=prev 2024-05-08T04:53:41Z

<p>2 revisions imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en-GB"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 04:53, 8 May 2024</td> </tr><tr><td colspan="2" class="diff-notice" lang="en-GB"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

NickPGSmith https://www.smithnet.org.uk/wiki/index.php?title=Oracle&diff=477&oldid=prev 2023-02-17T21:02:12Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en-GB"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:02, 17 February 2023</td> </tr><tr><td colspan="2" class="diff-notice" lang="en-GB"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

NickPGSmith https://www.smithnet.org.uk/wiki/index.php?title=Oracle&diff=476&oldid=prev 2021-05-23T14:56:44Z

<p>Created page with &quot;== Installation == * [https://docs.oracle.com/database/121/SXDQI/toc.htm#BGBEAGAJ 12c Installation] == Database Configuration == Example configuration: ORACLE_BASE=/opt/or...&quot;</p> <p><b>New page</b></p><div>== Installation ==<br /> <br /> * [https://docs.oracle.com/database/121/SXDQI/toc.htm#BGBEAGAJ 12c Installation]<br /> <br /> == Database Configuration ==<br /> <br /> Example configuration:<br /> ORACLE_BASE=/opt/oracle/app/oracle<br /> ORACLE_HOME=/opt/oracle/app/oracle/product/12.2.0/dbhome_1<br /> PATH=$PATH:$ORACLE_HOME/bin<br /> <br /> Define which databases should be started with dbstart:<br /> /etc/oratab<br /> <br /> Listener config $ORACLE_HOME/network/admin/listener.ora:<br /> SID_LIST_LISTENER =<br /> (SID_LIST =<br /> (SID_DESC =<br /> (GLOBAL_DBNAME=ORCL)<br /> (ORACLE_HOME=/opt/oracle/app/oracle/product/12.2.0/dbhome_1)<br /> (SID_NAME=ORCL)<br /> )<br /> )<br /> LISTENER =<br /> (DESCRIPTION_LIST =<br /> (DESCRIPTION =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = dbhostname)(PORT = 1521))<br /> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<br /> )<br /> )<br /> <br /> TNS Names config $ORACLE_HOME/network/admin/tnsnames.ora:<br /> LISTENER_ORCL =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))<br /> ORCL =<br /> (DESCRIPTION =<br /> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))<br /> (CONNECT_DATA =<br /> (SERVER = DEDICATED)<br /> (SERVICE_NAME = orcl)<br /> )<br /> )<br /> <br /> Start/Stop databases:<br /> dbstart<br /> dbshut <br /> <br /> Start/Stop TNS lisenter:<br /> lsnrctl start<br /> lsnrctl stop<br /> <br /> == SQL Plus ==<br /> <br /> Login:<br /> sqplus username/password@servicename<br /> <br /> == Common Operations ==<br /> <br /> Change the system password, and make it unlimited time:<br /> <br /> alter user system identified by manager;<br /> alter profile default limit password_life_time unlimited;<br /> <br /> == Useful Queries ==</div>

NickPGSmith