Apps Media

Stop Oracle service in UNIX Linux How To Startup Oracle Database on a Unix/Linux Use the  su - username  command to login as oracle user. Open the Terminal or login using ssh and type the following command to login $ su - oracle Start Oracle server in UNIX/Linux Now, use the lsnrctl command to start service (usually located at /home/oracle/oracle/product/10.2.0/db_1/bin directory): $ lsnrctl start Next start database: $ dbstart If above is not working try to login as sysdba: $ sqlplus / as sysdba At  SQL>  type startup command: SQL> startup Stop Oracle service in UNIX/Linux To stop Oracle service type following two commands: $ lsnrctl stop $ dbshut If above failed login as sysdba user: $ sqlplus / as sysdba At  SQL>  type shutdown command: SQL> shutdown download  file  now

Steps to create open and close an Oracle Wallet using Oracle Wallet Manager Its possible to create the Oracle Wallet using the owm gui utility or from sqlplus with a new set of key management statements (ADMINISTER KEY MANAGEMENT). Lets see first in this post how to proceed using the owm gui utility. Using the Oracle Wallet Manager its possible to create standard wallets (PKCS #12, Public-Key Cryptography Standards) on file system or wallets (PKCS #11) used in conjunction of hardware security modules (HSM), tokens or smart cards. From the command line type: [oracle@vsi08devpom ~]$ owm & The following screenshot appears: To create a new wallet from the Wallet menu select New . If the Oracle software detects you dont have a default directory for the wallet it will ask you to create one: you can always choose a custom directory. The default path of the wallet directory is: $ORACLE_HOME/owm/wallets/user_name (/app/oracle/product/12.1.0/dbhome_1/owm/wallets/oracle in my case).   ...

Software only installation of Oracle Database 12c release 1 In this post Im going to install only the software of the Oracle Database 12c release 1. Download from Oracle website and extract it into the home directory of the oracle user. [oracle@localhost ~]$ pwd /home/oracle [oracle@localhost ~]$ cd database/ [oracle@localhost database]$ ./runInstaller & The GUI of the installer is similar to the previous version. On the first step "Configure Security Update" you have to specify your email to be informed on security issue; on next step "Software Updates" it asks to download any PSU available; on next step "Installation Option" it asks what kind of installation you want to perform. Im going to choose "Install database software only"; on next step "Grid Installation Options" it asks if you want to install a single instance, a RAC or a RAC One Node database installation. Im selecting "Single instance database installation"; o...