sys / as sysdba should require a password

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

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 folder mounted on /data on linux

·         Check mount points execute command:

df  -h

·         /data has been mounted

Now after restart linux machine mount point /data has been disappeared. To auto mount the /data mount point at startup on linux, you should enter the mount point entry in /etc/fstab as follow:

vi /etc/fstab

Go to bottom of  the file and enter the following line:

\\192.168.1.1\Data_Backups   /data     cifs      username=datacell,password=data123 0  0

Save and exit from file.

Now after restart the linux machine /data mount point automatically mount.

Your comments, especially which will help us improve the functionality, will be greatly appreciated :)

ORA-00600: internal error code arguments: [kdsgrp1]

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> validate structure;

·         Here I found an index which fail to validate and return the below error:

ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []

·         Now I drop the index and recreate it.

·         After doing all the steps I resolved the above error.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ

REP-0501 ORA-01017 unable to connect to the specified database

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 case-sensitive by default. This behavior is controlled by the SEC_CASE_SENSITIVE_LOGON parameter.

Check the current value of above parameter:

SQL> connect system/oracle
Connected.
SQL> show parameter sec_case_sensitive_logon
NAME                     TYPE    VALUE
------------------------ ------- -----
sec_case_sensitive_logon boolean TRUE

Default value of this parameter is TRUE, change it to FALSE. After restart the database reports are working fine without any error.

Your comments, especially which will help us improve the functionality, will be greatly appreciated. :)