Oracle Application DBA

sys / as sysdba should require a password Applies to:             Enterprise Linux – Version: 5 Description:             Sqlplus / as sysdba connections go through OS authentication rather than database authentication. Any user with OS access can log into database irrespective of valid account available in database. Sys / as sysdba could not login without a password. How can we control OS authentication to stop any OS user to login as SYSDBA? Solution: Set the following parameter in init.ora file: REMOTE_OS_AUTHENT = FALSE open sqlnet.ora file and set the following parameter: SQLNET.AUTHENTICATION_SERVICES=(NONE) save and exit file. now you cannot login "sys / as sysdba" without password. Your comments, especially which will help us improve the functionality, will be greatly appreciated :)

Auto Mount of Windows Shared Folder on Linux Applies to:             Enterprise Linux – Version: any             Description:             I have oracle database 11gR2 on oracle enterprise Linux 5.7. I want to mount a windows shared folder on linux. Solution:             To mount a windows shared folder on linux: ·          Login on linux by root user ·          Check the following rpm’s: o    Fuse-2.7.4-8.el5 o    Fuse-ntfs-3g-2010.5.22-1.el5.rf ·          If not, install the above rpm’s on linux ·          Now create a new folder</data> on linux to mount windows folder ·          Grant read/write permission on windows shared folder<Data_Backups> to a windows/domain user<datacell>, windows machine IP <192.168.1.1> ·          Execute the following command on linux by root user to mount it: mount   -t cifs   -o username=datacell,password=data123,ip=192.168.1.1 ‘\\192.168.1.1\Data_Backups’ /data ·          Windows shared

Applies to:             Enterprise Linux – Version: 5             Oracle Database 11gR2             Description:               I have an update statement which modifies around 30000 records. Statement executed successfully on a single record, but when I execute to update all records it is going to fail with following error message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], [] Solution:             ·          Open and view the alert log file when error occurred ·          Get the trace file name from alert log file and open it ·          Search the keyword “Plan Table” in trace file ·          Here you found details of the query causing problem ·          Identify the tables from above query and execute the following: Analyze table <tab_name> validate structure cascade; ·          Identify all the indexes on the above tables and execute the following: Analyze index <index_name>

REP-0501 ORA-01017 unable to connect to the specified database Applies to:             Enterprise Linux Version 5.7             Database 11gR2             Oracle Forms/Reports 6i Description:             We have an in-house developed application on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008 32bit. Application is working fine. I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I have done all the activities successfully. After that, Application is working fine except reports. When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. ORA-01017: invalid username/password; logon denied Solution: After some research work I have found the following solution: If you have recently created an 11g database, one behavior change that you may find confusing is that passwords are now ca