Category: DataBase

[root@ProdDB01 ~]# lsnrctl help LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:21:53 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. The following operations are available An asterisk (*) denotes a modifier or extended command: start               stop                status services            version             reload save_config         trace               spawn dbsnmp_start        dbsnmp_stop         dbsnmp_status change_password     quit                exit set*                show* [root@ProdDB01 ~]#   [root@ProdDB01 ~]# lsnrctl help show LSNRCTL for Linux: Version 8.1.6.0.0 – Production on 21-MAR-2014 07:22:54 (c) Copyright 1998, 1999, Oracle Corporation.  All rights reserved. The following operations are available after show An asterisk (*) denotes a modifier or extended command: rawmode                 displaymode             trc_file […]

Using  SQL Interface: There are 2 main dynamic performance views to see your database’s current redo log structure. 1. v$logfile => Shows redo log groups, group members and member status. 1 sql> select group#,status,member from v$logfile; GROUP# STATUS MEMBER 1 /oradata/mydb/redo_log_files/redo01.log 2 /oradata/mydb/redo_log_files/redo02.log 3 /oradata/mydb/redo_log_files/redo03.log Here, this database has 3 redo log groups with 3 members. You can see the path of redo log files and see which group they belong to. If status is null then it means that the file is in use. 2. v$log => This view provides information about your redo log groups. This information is […]

In order to start Oracle service in a UNIX or Linux based system you need to login as a Oracle user. 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’ […]