Davis Apps DBA

login as: root Access denied root@172.19.0.26's password: Last login: Wed Jul 24 11:23:17 2013 from 172.19.0.77 1) Make the directory structure for your custom application files. [root@server2 ~]# su - applvr12 [applvr12@server2 ~]$ mkdir XXUL [applvr12@server2 ~]$ cd $APPL_TOP [applvr12@server2 appl]$ mkdir xxul [applvr12@server2 appl]$ mkdir xxul/12.0.0 [applvr12@server2 appl]$ mkdir xxul/12.0.0/admin [applvr12@server2 appl]$ mkdir xxul/12.0.0/admin/sql [applvr12@server2 appl]$ mkdir xxul/12.0.0/admin/odf [applvr12@server2 appl]$ mkdir xxul/12.0.0/sql [applvr12@server2 appl]$ mkdir xxul/12.0.0/bin [applvr12@server2 appl]$ mkdir xxul/12.0.0/reports [applvr12@server2 appl]$ mkdir xxul/12.0.0/reports/US [applvr12@server2 appl]$ mkdir xxul/12.0.0/forms [applvr12@server2 appl]$ mkdir xxul/12.0.0/forms/US [applvr12@server2 appl]$ mkdir xxul/12.0.0/lib [applvr12@server2 appl]$ mkdir xxul/12.0.0/out [applvr12@server2 appl]$ mkdir xxul/12....

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: data file 1: '/PRIM/u02/oradata/orcl/users01.dbf' SQL> startup ORACLE instance started. Total System Global Area 1286066176 bytes Fixed Size                                2287960 bytes Variable Size                        452986536 bytes Database Buffers               822083584 bytes Redo Buffers                         8708096 bytes Database mounted. ORA-01157: cannot identify/lock data file 6 - see DBWR trace file ORA-01110: data file 1: '/PRIM/u02...

ORA-01113: file 1 needs media recovery ORA-01110: data file 1: '/oradata/orcl/system01.dbf' cause : An attempt was made to online or open a database with a file that is in need of media recovery. Solution : First apply media recovery to the file and then open the database. Resolution: 1) Start the DB with mount option. SQL> startup mount ORACLE instance started. Total System Global Area 1603411968 bytes Fixed Size                                2288872 bytes Variable Size                      1040188184 bytes Database Buffers               553648128 bytes Redo Buffers          ...

After we've Installed a new database, we need to add entries in .bash_profile and listener.ora files as per our requirements. So here in this post I've shared the generally used entries. Add the below entries apart from already existing entries of your database. .bash_profile entry LD_LIBRABRY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRABRY_PATH CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH                                    listener.ora file entry SID_LIST_ocl =  (SID_LIST =   (SID_DESC =    (ORACLE_HOME=/u01/app/oraprim/product/12.1.0/dbhome_1)    (SID_NAME=orcl)   )  )

Most of the users have been getting Could not execute auto check for display colors using command /usr/bin/xdpyinfo. Check if the DISPLAY variable is set in Linux environment while checking requirement the oracle installations on  Linux 5.2 or later versions. Below is the screenshot of the issue I have tried plenty of options, even ignoring the pre-requisites. Finally, i have fixed this issue through one Linux command Steps to resolve this issue: 1) login into root user( su -l root) 2) execute this command xhost +SI:localuser:oracle 3) login to the oracle user 4) execute ./runInstaller Now, it'll work fine.