Soft Link Vs Hard Link in Solaris & AIX Unix OS – Difference and Features

Hard Links
  • Hard links have actual content
  • Hard link is the replica of the original file
  • All hard links have the same inode number

How to Find Out Last Modified Time of a Row in an Oracle 10g 11g Table Using ORA_ROWSCN and SCN_TO_TIMESTAMP Functions?

ora_rowscn pseudo column and SCN_TO_TIMESTAMP function
Oracle 11g database can link the system change number and corresponding timestamp for certain amount of time period. This short period of time depended on the auto-tuned undo retention period.

How to Get Current SCN for Oracle 10g 11g Database? DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER and V$database

There are two ways to get the current scn (System Change Number) for an oracle database.
Method 1

Get Timestamp from SCN in Oracle 10g 11g? Convert SCN to Timestamp Using scn_to_timestamp and timestamp_to_scn

There are 2 functions to perform these operations.
For converting SCN to Time Stamp you can use scn_to_timestamp function and for converting time stamp to SCN use timestamp_to_scn.

How to get Aadhaar UID application enrollment centers information for Maharashtra & Orissa


STATE NAME
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
ORISSA
Central Bank of India, Rasulgad Branch
Rasulgad Square

How to Rename an Unnamed datafile (UNNAMED00004) to Original Name in Oracle 9i 10g 11g Standby Database?

Please find the steps to rename an unnamed datafile to original name in Standby Database.
Step1. Find out the exact name for the datafile which is in unnamed format from V$DATAFILE table.

How to get Aadhaar UID application enrollment centers information for Uttrakhand, Tripura, Uttar Pradesh, West Bengal?

STATE NAME
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
TRIPURA
Bagabasa
Bagabasa Panchyat Office
TRIPURA
Chandanmura
Chandanmura Panchyat Office

How to get Aadhaar UID application enrollment centers information for Tamil Nadu, Puducherry, Rajasthan

STATE NAME
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
TAMIL NADU
EPPL_1057
-
TAMIL NADU
IOB Main Branch
#763,Annai Salai
TAMIL NADU
Chromepet
10,Bhashyam Street, Radha Nagar,Chennai

How to get Aadhaar UID application enrollment centers information for Himachal Pradesh, Madhya Pradesh, Haryana?

STATE NAME
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
HIMACHAL PRADESH
Mandi, Sadar
-
HIMACHAL PRADESH
Naggar
BDO Office Patikul

How to get Aadhaar UID application enrollment centers information for Goa & Gujarat?


STATE NAME
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
GOA
-
Curchrom
GOA
-
Margoa H O
GOA
-
Mormugoa
GOA
-
Navelim

How to get Aadhaar UID application enrollment centers information for Delhi?

ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
Society for Promotion of Youth and Masses, South
-
Community Outreach Department, St. Stephen’s Hospital, Tis Hazari, Delhi
-
-
-

How to get Aadhaar UID application enrollment centers information for Chandigarh?


These are the enrollment Aadhaar application enrollment centers for Chandigarh state.
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
-
Central Bank Of India, SCO68-69, Sec 17B, Bank Square, Chd
-
ALANKIT ASSIGNMENTS LTD, First floor, SCO 196-197, SECTOR 34A, Chd

How to get Aadhaar UID application enrollment centers information for Bihar?


These are the enrollment Aadhaar application centers for Bihar state.
ENROLLMENT CENTER NAME/LOCATION
ENROLLMENT CENTER ADDRESS
State Bank Of India
-
State Bank Of India
All Financially excluded villages and other villages in Bihar in 7 districts of Araria, Jamui, Saharsa, Kishanganj, Madhepura, Purnea, Supaul

How to get Aadhaar UID application enrollment centers information for Kerala?

These are the enrollment Aadhaar application centers for Kerala state.
ENROLLMENT CENTER NAME/LOCATIONENROLLMENT CENTER ADDRESS
Akshaya, AllapuzhaPoomkavu, Kurrisady Junction, Pathirapalli (P.O.)
Keltron House, ThiruvananthapuramVelleambalam, Thiruvananthapuram

How to Check Aadhaar UID Application Status Online?

Normally it will take 60 to 90 days to get the Aadhaar UID. You can check this link for the status of your application.

How to get Aadhaar UID Enrollment Centers Information for Karnataka Bangalore– Day Centers and night Centers

Bangalore
Day Centers Address (8AM to 8PM) 
Yavanika
Kanteerva Indoor Stadium 
Koramangala Indoor Stadium 
Hombegowda (Kho Kho) Stadium 

How to get Aadhaar UID enrollment centers information for Maharashtra and Andra Pradesh?

Residents have to go to nearest enrolment camp to register for Aadhaar. The residents have to carry the required documents to enroll for Aadhaar. After registering for Aadhaar, each resident has to go through a biometric scanning of ten fingerprints and iris.

How to move oracle datafile to different location and rename?

These are the steps to move an oracle datafile to different location. This can be applicable for the tablespaces other than system, undo, temp.

Step1. Login to Oracle as sysdba

How to rename and move a oracle system tablespace datafile?

System, temp, undo tablespaces cannot be make offline when the database is open. This can be done with following method.

Step1. Login to Oracle as sysdba
          Sqlplus “/ as sysdba”

What is the command to take Oracle Control file backup? Standby Control file, ASCII control file

  1. You can create the ASCII control file script using the following command. The output of the command will be created in the user_dump_dest directory of the database. This script can be used for the control file recreation during the database restoration.

Reason and Fix for ORA-25153: Temporary Tablespace is Empty

Normally you get this error when you create a new database and if you forget to add temporary tablespace to the database.
The second situation when you open a standby database in read-only mode and when you try to perform some sorting and ordering.

What is the significance of Oracle Parameter Global_names=TRUE?

Global_names is a Boolean parameter which means the value of the parameter can be TRUE or FALSE. By default the value of the parameter is FALSE. If you set this parameter value as TRUE, the name of the database link must be the same name of the remote database which they are connecting.

How to Signup and Install / Add Google Analytics Code to Your WordPress / Blogger Blogs?

How to Create Account with Google Analytics?
  1. Open the Google Analytics page by clicking www.google.com/analytics

Oracle Views vs Materialized Views – Difference, Advantages, Disadvantages and Features

Oracle Views
  • Does not require storage
  • Views stored in the database in the form SQL statements
  • When you query on the view the output generates on the fly from the view definition SQLs.

How to Check Whether the Oracle Database is Using Pfile or SPfile?

Please find the query to check whether the database is running from pfile or spfile.

SQL> SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Pfile or SPfile" FROM sys.v_$parameter
  2  WHERE name = 'spfile';

Oracle Views vs Tables- Advantages, Disadvantages and Features

  • Views are representation of simple or complex SQL statements
  • Views are created and stored in the database in the form of SQLs
  • View is a virtual table which provides the access to subset of columns from one or more base tables.

Oracle Private vs Public Synonyms – Advantages Difference and Features

  • A normal synonym is called private synonym whereas a public synonym is created by a keyword public.
  • A private synonym is accessible within your schema and a public synonym is accessible to any schema in the database.
  • CREATE SYNONYM system privilege is required to create a private synonym and CREATE PUBLIC SYNONYM system privilege is required to create a public synonym

dbms_system.ksdwrt Procedure to Write Custom Messages to Oracle Alert and Trace Files Manually

For some reasons Oracle DBAs needs to write custom messages to the alert log for better commenting or readability. This can be achieved by dbms_system.ksdwrt package.

Here is the syntax:

Oracle SQLPlus Copy Command Usage Syntax to Copy tables across database

SQL*Plus copy command is the easiest method to copy tables from one database to another database. You must configure the proper tns entries to the tnsnames.ora file before copying the table as it uses the tns for the data transfer.

Usage syntax for Oracle 10g REGEXP_LIKE regular expression function

Syntax :      REGEXP_LIKE(string, pattern)
                   REGEXP_LIKE(string, pattern, parameters)

Where parameter values can be
i         : is for ignore the case sensitive match
c        : is for case sensitive match

Oracle 11g ADRCI – How to Create Package for an Incident or a Problem?

Using ADRCI utility we can create package for a particular incident or problem. This package can be uploaded to oracle metalink support for further diagnosis of the problem. Here are the steps to create a package using ADRCI tool

$ adrci

ADRCI: Release 11.1.0.7.0 - Production on Wed Aug 3 04:10:14 2011

Oracle 11g ADRCI - Configure and Setup Automatic Diagnostic Repository Using Command Line Interpreter

ADRCI is the command-line tool to monitor the Automatic Diagnostic Repository in Oracle 11g. These are the features of the ADRCI.
  • You can view the diagnostic data within the Automatic Diagnostic Repository (ADR).
  • It is used to view the Health Monitor reports.

Oracle Data Pump expdp impdp Use JOB_NAME Option to Stop_job, Attach, Kill_job and Continue_client interactively

One of the main advantage of datapump is you can suspend the running export or import job and it can be resume if needed. Suppose if your server load is high when you started the export job, you can suspend the job and later you can resume the job once the server load comes down. One more feature is you can suspend the job from one client machine and can be resume from different client.

What is Oracle 11g Problems and Incidents Concept?

For better diagnosis and resolution of critical errors Oracle 11g introduced two concepts for Oracle database called Problems and Incidents. A critical error is such as Ora-00600 and other severe errors such as Ora-07445(OS Exception) or Ora-04031(Out of memory in the shared pool portion) is known as problem. Problems are tracked in the Automatic Diagnostic Repository (ADR). This repository can be accessible even the database is down as it is stored out of the database.

Oracle 11g Automatic Diagnostic Repository – ADR – Features and advantages

Automatic Diagnostic Repository is introduced in Oracle 11g as new feature. As the name represents it is common repository directory system for keeping trace, dump files etc. When critical errors are detected, Oracle automatically creates an incident and the related information automatically captured under this ADR directory.

How to Register Your Land, Vehicle, Employment exchange, Company Online?

Here are some useful links to register your property with government. Most services are available for the states Andaman Nicobar Islands, Andra Pradesh, Arunachal Pradesh, Assam, Chandigarh, Chhattisgarh, Goa, Delhi, Gujarat, Hariyana, Himachal Pradesh, Jharkhand, Karnataka, Lakshadweep, Maharashtra, Meghalaya, Mizoram, Puducherry, Sikkim, Punjab, Tamil Nadu, Tripura, Uttar Pradesh and Uttarkhand.

How to apply for Government Cards online – PAN, TAN, Ration, Passport, and Electoral

Here are some useful links to apply for different types of cards online. Most services are available for the states Andaman Nicobar Islands, Andra Pradesh, Arunachal Pradesh, Assam, Chandigarh, Chhattisgarh, Delhi, Goa, Gujarat, Hariyana, Himachal Pradesh, Jharkhand, Karnataka, Lakshadweep, Maharashtra, Meghalaya, Mizoram, Puducherry, Punjab, Sikkim, Tamil Nadu, Tripura, Uttar Pradesh and Uttarkhand.

How to Apply for Government Certificates Online – Birth, Caste, Tribe, Dominical, Driving, Marriage and Death

Here are the some links to apply for Government certificates online for different states. Most services are available for the states Andaman Nicobar Islands, Andra Pradesh, Arunachal Pradesh, Assam, Chandigarh, Chhattisgarh, Delhi, Goa, Gujarat, Hariyana, Himachal Pradesh, Jharkhand, Karnataka, Lakshadweep, Maharashtra, Meghalaya, Mizoram, Puducherry, Punjab, Sikkim, Tamil Nadu, Tripura, Uttar Pradesh and Uttarkhand.  See some useful links below.

Oracle 11g Security SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter

The value of the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter determines the number of authentication attempts can be made by a client on a connection to the server process. After the specified number of failure attempts, the connection will be automatically dropped by the server process. Advantage of this parameter is you can prevent the hackers and intruders to the database by password guessing. You can modify the parameter values as you needed and the default value of this parameter is 10. It is not a dynamic parameter.

Parameter type      : Integer
Default value        : 10
Modifiable             : No
Range of values    : 1 to unlimited
Basic                     : No

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer