|
||||||
|
To install Oracle 11g DB, just install the following packages at the startup and continue # yum install binutils gcc glibc glibc-devel cpp make setarch pdksh libaio libaio-devel compat-gcc-34 compat-gcc-34-c compat-libstdc-296 compat-libstdc-33 sysstat -y Creating groups and user for Oracle Installation: # groupadd oinstall # groupadd dba # useradd -m -g oinstall -G dba -d […] Oracle Startup script used for Automatic start up of oracle db after rebooting the machine. I have already explained how to install oracle 11g in previous posts and just note how to add a startup script with respect to that settings For automatically restart the oracle after system reboot create a file called oracle ( […] Installing Oracle database Client to access DB Either you can use sqldeveloper as oracle client or you can execute it from the command line using # sqlplus We can access oracle server graphically by using a package called sqldeveloper. sqldeveloper-2.1.1.64.45-1.noarch.rpm # rpm -ivh sqldeveloper-2.1.1.64.45-1.noarch.rpm if the front end not getting install the jdk package and […] Starting oracle listener $ lsnrctl start Start the database $ dbstart Starting oracle Enterprise manager $ emctl start dbconsole Shutting down the database $ dbshut Stopping the listener $ lsnrctl stop Stopping oracle Enterprise manager $ emctl stop dbconsole Starts sqlplus without logging in to a database # su oracle $ sqlplus /nolog Logging […] A schema is a collection of database objects. A schema is owned by a database user and has the same name as that user. Schema objects are logical structures created by users to contain, or reference, their data. Schema objects include structures like tables, views, and indexes. $ sqlplus /nolog SQL> connect / as sysdba […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments