If Shutdown normal or shutdown immediate hangs and you try to connect as sys, it would get you connected either as idle instance or simply connected which is in reality a fake connection. In a particular scenario, I changed ORACLE_HOME from EM and then issued simple “SHUTDOWN” command which took a long time to complete. [...]
Tech Blog
Blog Stats
- 56,060 hits
Tea Break
Blog Post History
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Apr | ||||||
| 1 | 2 | 3 | ||||
| 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| 11 | 12 | 13 | 14 | 15 | 16 | 17 |
| 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| 25 | 26 | 27 | 28 | 29 | 30 | |
Oracle Blogs
Oracle Documentation
UNIX/LINUX
Categories
- Backup and Recovery (11)
- Business Intelligence (1)
- Data Dictionary (7)
- Dictionary Tables (2)
- Performance Views (1)
- Data Storage (1)
- DBA Tasks and Interview Stuff (1)
- Hardware (1)
- oracle (1)
- Oracle Architecture (23)
- Initialization parameters (5)
- Memory Architecture (4)
- Oracle Memory (3)
- Process Architecture (3)
- SGA (2)
- Storage Architecture (11)
- Tablespaces (3)
- Oracle Concepts (2)
- Oracle DBA (2)
- Oracle Installation Creation Configuration (2)
- Oracle Issues (3)
- Oracle Network (4)
- Listener (2)
- Oracle TNS (2)
- Oracle SQL (9)
- Dynamic SQL (1)
- SQL Functions (1)
- String Functions (1)
- SQL Hints (1)
- Table SQL (2)
- Oracle Tools (1)
- Oracle Utilities (6)
- Performance Monitoring and Maintenance (1)
- Performance Tuning (14)
- SQL Optimization (5)
- SQL Joins (1)
- STATISTICS (1)
- SQL Optimization (5)
- PL SQL (6)
- Functions (1)
- Packages (2)
- Procedures (2)
- Portals (1)
- Schema Objects (10)
- Security (4)
- Privileges (1)
- Table (1)
- Users (2)
- SQL Server (3)
- Streams (1)
- Uncategorized (5)
- UNIX (7)
- AWK and SED (2)
- Utilities (3)
- Windows Utilities (1)
Category Cloud
Backup and Recovery Data Dictionary Indexes Initialization parameters Listener Logical Backup Export Import Memory Architecture Oracle Architecture Oracle DBA Oracle Issues Oracle Memory Oracle Network Oracle SQL Oracle TNS Oracle Utilities Performance Tuning PL SQL Process Architecture RMAN backup and recovery Schema Objects SGA SQL Optimization SQL Server Storage Architecture Tables Tablespaces Table SQL Uncategorized UNIX Utilities
Blog at WordPress.com. Theme: Spring Loaded by the449.
