Scribd
Upload
23 views1 page

SSAELITEDB Deployment Checklist Guide

The SSAELITEDB Deployment Checklist outlines the steps required for a successful database deployment, including pre-import, import, and post-import tasks. Key actions include ensuring database availability, running import commands, recompiling invalid objects, and verifying database integrity. The document also includes verification queries for checking invalid objects, tablespace usage, and segments.

Uploaded by

suvachatgpt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views1 page

SSAELITEDB Deployment Checklist Guide

The SSAELITEDB Deployment Checklist outlines the steps required for a successful database deployment, including pre-import, import, and post-import tasks. Key actions include ensuring database availability, running import commands, recompiling invalid objects, and verifying database integrity. The document also includes verification queries for checking invalid objects, tablespace usage, and segments.

Uploaded by

suvachatgpt
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SSAELITEDB Deployment Checklist

===============================

Pre-Import
---------
- [ ] Ensure target DB SSAELITEDB is available and listener reachable.
- [ ] Create target tablespaces (SSAELITS_*) using provided SQL.
- [ ] Ensure sufficient disk space on D:\Softwares\app\Oracle\oradata\SSAELITS\
- [ ] Place dumpfile in directory object DATA_PUMP_DIR accessible to target DB.
- [ ] Backup target DB or take snapshot if possible.

Import
------
- [ ] Run impdp with remap_schema=ACPNLBK:SSAELITEDB and remap_tablespace mappings.
- [ ] Monitor impdp log for errors and table/index creation issues.

Post-Import
-----------
- [ ] Run @?/rdbms/admin/[Link] to recompile invalid objects.
- [ ] Query DBA_OBJECTS for INVALID objects and recompile if needed.
- [ ] Verify that all segments for SSAELITEDB are in SSAELITS_% tablespaces.
- [ ] Verify synonyms referencing ACPNLBK and fix/recreate if necessary.
- [ ] Rebuild indexes if required (ALTER INDEX ... REBUILD).
- [ ] Check scheduler jobs, DB links, and privileges.
- [ ] Run sample application tests or smoke tests.

Verification Queries
--------------------
-- Invalid objects
SELECT owner, object_type, object_name FROM dba_objects WHERE owner='SSAELITEDB' AND status='INVAL

-- Tablespace usage
SELECT tablespace_name, file_name, bytes/1024/1024 size_mb, autoextensible FROM dba_data_files WHERE ta

-- Segments
SELECT owner, segment_name, segment_type, tablespace_name FROM dba_segments WHERE owner='SSAEL

Notes
-----
Add any environment-specific notes here.

You might also like