ORA-00257: archiver is stuck. CONNECT INTERNAL only, until freed
The Problem Your database is in archive log mode and archiving works fine until suddenly connecting via SQLPLUS generates the following error:
Latest Articles
Assigning Positional Parameter Values Using the Set Statement in Shell Scripts
Although you cannot use any positional parameter name on the left side of an assignment statement, you can still assign …
Beginners Guide to Creating User-Defined Functions in a Shell Script
Functions in the Shell A function is a set of one or more statements that act as a complete routine. Each function must …
Understanding "$@" and "$*" Positional Parameters in Shell Script
Understanding “$@” and “$*” Positional Parameters in Shell Script The Values of the …
Understanding Korn Shell Arrays
Korn Shell Arrays Arrays are variables that contain more than one value. Don’t declare arrays explicitly or explicitly …
What Is Getopts Statement in Shell Scripts
Processing Script Options With the getopts Statement Options or switches are single-letter characters preceded by a + …
What Is Korn Shell Typeset Statement
Variable Types In the Bourne shell, there are two variable types: strings and constants. In the Korn shell, there are …
What Is "Here" Document in Shell Scripts
The “here” Document Frequently, a script might call on another script or utility that requires input. To run a script …
How to Use File Descriptors to Read From and Write to Multiple Files in Linux
File Input and Output A script can receive input from a file and send output to a file so that the script can run …
How to Write Interactive Shell Scripts
Input and Output in a Script While some scripts run without any interaction with the user, many scripts require input …
The Korn Shell Print Statement Examples
Use the print statement to provide output. Use it wherever you would use the echo statement. It is more versatile than …