All public logs
Jump to navigation
Jump to search
Combined display of all available logs of NazimWIKI. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
(newest | oldest) View (newer 100 | older 100) (20 | 50 | 100 | 250 | 500)- 00:44, 9 November 2019 Admin talk contribs created page Use Samba to copy file to Windows (Created page with "<blockquote><pre> smbclient //<WINDOWSSERVERNAME>/<SHAREDIRNAME> -A myauth.auth -c "put <sourcefilename> <windowspathname><destinationfilename>" </pre></blockquote> myauth.au...")
- 00:44, 9 November 2019 Admin talk contribs created page Yesterday's Date (Created page with "<blockquote><pre> date -d '1 day ago' </pre></blockquote> <blockquote><pre> date -d 'yesterday' </pre></blockquote>")
- 00:44, 9 November 2019 Admin talk contribs created page Check O/S Version (Created page with "uname -a Also ... '''Linux:''' cat/etc/issue '''AIX:''' oslevel oslevel -r (shows technology level) oslevel -s (shows service pack}")
- 00:44, 9 November 2019 Admin talk contribs created page Chmod (Created page with "Instead of having to work out the numeric settings for chmod, the following conventions can be "literally" used: <blockquote><pre> chmod u+rwx chmod g+rwx chmod o+rwx chmod...")
- 00:41, 9 November 2019 Admin talk contribs created page TSM Command Line Restore (Created page with "To restore files through TSM command line and pick what is needed. Note: destfile not required if restoring to original source directory. <blockquote><pre> dsmc restore "/pat...")
- 00:41, 9 November 2019 Admin talk contribs created page Tasks (Created page with "TSM Command Line Restore")
- 00:38, 9 November 2019 Admin talk contribs created page Random Image Generator (Created page with "On my [http://www.nazimcricket.com website] I had been using a third party Javascript random image generator which scrolled through my /images folder and displayed a random im...")
- 00:38, 9 November 2019 Admin talk contribs created page Global Parameters (Created page with "New to MySQL, but will make notes for my benefit, and for the odd person who stumbles on this post via Google. I need to write a few cron scripts for a MySQL database and I do...")
- 00:37, 9 November 2019 Admin talk contribs created page Spooling Out (Created page with "Thanks to my friend LW for helping sort this one out. You can increase the verboseness (is that a word?) of a batch output logfile in MySQL, by repeating the "-v" switch....")
- 00:36, 9 November 2019 Admin talk contribs created page Script to Backup and Restore a MySQL Database (Created page with "'''Requirements'''<br> * Obtain a simple backup of a Production MySQL database. * Send backup to TSM Tape Storage Device. * Copy the files to a Non-Production MySQL database s...")
- 00:36, 9 November 2019 Admin talk contribs created page Gen-Tasks (Created page with " Script to Backup and Restore a MySQL Database Spooling Out === MySQL and PHP (The Perfect Match) ===...")
- 00:29, 9 November 2019 Admin talk contribs created page Email Results of a Database Export (Created page with "Had to write a batch script to check on the status of a nightly database export and email out the Status. Some of what I've done may not be perfect, but it does the job nice...")
- 00:29, 9 November 2019 Admin talk contribs created page Services Manipulation (Created page with "To stop, start or check status of a Service remotely, you can use the sc utility as follows: <blockquote><pre> sc \\servername stop ServiceName sc \\servername start Service...")
- 00:29, 9 November 2019 Admin talk contribs created page Count Network Connections (Created page with "To get a count of the number of network connections on a Windows server, you can use the following batch script: <blockquote><pre> REM list network connections and write them...")
- 00:28, 9 November 2019 Admin talk contribs created page Tree Directory Listing (Created page with "A good way to list your files and folders. '''Syntax''' <blockquote><pre> Drive:\Path Drive Letter and Directory Name /f Displays File Names in each Director...")
- 00:28, 9 November 2019 Admin talk contribs created page Check Server UpTime (Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>")
- 00:28, 9 November 2019 Admin talk contribs created page General (Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con...")
- 00:25, 9 November 2019 Admin talk contribs created page Check Database Uptime (Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>")
- 00:25, 9 November 2019 Admin talk contribs created page Check Database Version (Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>")
- 00:24, 9 November 2019 Admin talk contribs created page Clone Role with Securables (Created page with "<blockquote><pre> declare @RoleName varchar(50) = '<ROLE_NAME>' declare @Script varchar(max) = 'CREATE ROLE ' + @RoleName + char(13) select @script = @script + 'GRANT ' + p.p...")
- 00:24, 9 November 2019 Admin talk contribs created page Check Mirror Status (Created page with "A handy SQL contributed by Andrew R. <blockquote><pre> SELECT left(a.name,50) 'Database' , CASE b.status WHEN 0 THEN 'Suspended' WHEN 1 THEN 'Disconnected'...")
- 00:24, 9 November 2019 Admin talk contribs created page Querying Active Directory Members for SQL Server Databases (Created page with "This is a rather convoluted way of approaching the task required, but does also provide a degree of flexibility. I needed to write a script to obtain a list of members of use...")
- 00:23, 9 November 2019 Admin talk contribs created page Various-Tasks (Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr...")
- 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss9.png
- 00:18, 9 November 2019 Admin talk contribs created page File:Ss9.png
- 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss8.png
- 00:18, 9 November 2019 Admin talk contribs created page File:Ss8.png
- 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss7.png
- 00:18, 9 November 2019 Admin talk contribs created page File:Ss7.png
- 00:18, 9 November 2019 Admin talk contribs uploaded File:Ss6.png
- 00:18, 9 November 2019 Admin talk contribs created page File:Ss6.png
- 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss5.png
- 00:17, 9 November 2019 Admin talk contribs created page File:Ss5.png
- 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss4.png
- 00:17, 9 November 2019 Admin talk contribs created page File:Ss4.png
- 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss3.png
- 00:17, 9 November 2019 Admin talk contribs created page File:Ss3.png
- 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss2.png
- 00:17, 9 November 2019 Admin talk contribs created page File:Ss2.png
- 00:17, 9 November 2019 Admin talk contribs uploaded File:Ss1.png
- 00:17, 9 November 2019 Admin talk contribs created page File:Ss1.png
- 00:16, 9 November 2019 Admin talk contribs uploaded File:Og5.png
- 00:16, 9 November 2019 Admin talk contribs created page File:Og5.png
- 00:16, 9 November 2019 Admin talk contribs uploaded File:Og4.png
- 00:16, 9 November 2019 Admin talk contribs created page File:Og4.png
- 00:16, 9 November 2019 Admin talk contribs uploaded File:Og3.png
- 00:16, 9 November 2019 Admin talk contribs created page File:Og3.png
- 00:16, 9 November 2019 Admin talk contribs uploaded File:Og2.png
- 00:16, 9 November 2019 Admin talk contribs created page File:Og2.png
- 00:15, 9 November 2019 Admin talk contribs uploaded File:Og1.png
- 00:15, 9 November 2019 Admin talk contribs created page File:Og1.png
- 23:54, 8 November 2019 Admin talk contribs created page Creating an Oracle Database with Apex on AWS RDS (Created page with "'''Steps to create an Oracle Standard Edition Two database on AWS with APEX as an option. These notes are for Apex version 5.1.2.v1''' '''PRE-REQUISITIES''' If you don't a...")
- 23:53, 8 November 2019 Admin talk contribs created page SQL Server Backup Script for AWS RDS (Created page with "<blockquote><pre> DECLARE @dbs TABLE (dbname VARCHAR(50)) DECLARE @currentDB VARCHAR(50) declare @SQL1 nvarchar(3000) declare @SQL2 nvarchar(3000) declare @BUCKET nvarchar(2...")
- 23:53, 8 November 2019 Admin talk contribs created page Auto Refresh of Oracle DB across VPCs (Created page with "<blockquote><pre> #!/bin/ksh # # Shell script for Snapshot of Databases # Nazim Merchant # 26 Jul 2018 # # Usage script.ksh instance-name source_db_name target_db_name e.g. or...")
- 23:52, 8 November 2019 Admin talk contribs created page Datapump Export to S3/Glacier (Created page with "Another script that has been documented for preservation more than anything else. '''Pre-requisites''' * ec2 Instance with Oracle XE installed * Access to the RDS Databases u...")
- 23:51, 8 November 2019 Admin talk contribs created page Dynamic Profile Creation Script (Created page with "<blockquote><pre> set serveroutput on declare cursor prof is select dbms_metadata.get_ddl('PROFILE', profile) as profile from (select distinct profile from dba_...")
- 23:51, 8 November 2019 Admin talk contribs created page Deploy Amazon Web Services Plugin to Cloud Control (Created page with "To monitor AWS RDS Database via Cloud Control (13c), a plugin needs to be deployed on OEM. Here are some rough notes, for my own reference. '''Download Plug-in''' <blockquot...")
- 23:50, 8 November 2019 Admin talk contribs created page Dynamic Tablespace Creation Script (Created page with "This script generates a dynamic Tablespace Creation (with multiple datafiles) script from my target database for my RDS instance. It deals with smallfile tablespaces. <block...")
- 23:49, 8 November 2019 Admin talk contribs created page Create a DB Link on RDS DB (Created page with "<blockquote><pre> create database link test connect to <username> identified by "<password>" using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<ip_address>)(PORT=1521))(CONNECT...")
- 23:49, 8 November 2019 Admin talk contribs created page General-Tasks (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
- 23:46, 8 November 2019 Admin talk contribs created page Disable Auto SQL Tuning Advisor (Created page with "<pre> select * from dba_autotask_operation EXEC dbms_auto_task_admin.disable( 'sql tuning advisor', NULL, NULL ); </pre>")
- 23:44, 8 November 2019 Admin talk contribs created page Check Bind Variables (Created page with "Here's a way you can check on what bind variable values have been parsed in a query. <blockquote><pre> SELECT a.sql_id , a.sql_text , b.name , b.value_string...")
- 23:44, 8 November 2019 Admin talk contribs created page Tuning-Tasks (Created page with " Check Bind Variables Disable Automatic SQL Tuning Advisor")
- 23:39, 8 November 2019 Admin talk contribs created page RMAN - Create Standby Database (Created page with "These are just rough notes for my own benefit. They are not well researched and are only posted as a reminder for myself. Had to convert a database to a physical standby usi...")
- 23:39, 8 November 2019 Admin talk contribs created page Resize Online Redo Logs (10g) - Rough Notes (Created page with "To resize redo log files, we have to drop and recreate them. The status of these files is critical. Files with a status of: * CURRENT - cannot/must not be dropped. To ch...")
- 23:39, 8 November 2019 Admin talk contribs created page READ ONLY Before RESETLOGS (11g) (Created page with "A new feature in Oracle 11g is that after incomplete recovery of a database, you can now open the database in read only mode before opening in resetlog mode. This now enables...")
- 23:38, 8 November 2019 Admin talk contribs created page Check Recovery Time (Created page with "It's quite useful sometimes to be able to see the timestamp associated with a Database Recovery. <blockquote><pre> SELECT to_char((max(TIME_DP)),'DD MON YYYY HH24:MI') FROM...")
- 23:38, 8 November 2019 Admin talk contribs created page Manually Create Standby Database from Hotbackup (9i) (Created page with "This is basically a "Note-To-Self". High Level Steps for Reference, are: * Copy Datafiles across. * On Target, set up env variables, password file, oratab entry etc. *...")
- 23:38, 8 November 2019 Admin talk contribs created page Lost spfile and pfile (Created page with "''Handy Tip'': If you have lost your spfile and pfile, you can recover the non-default values previously set from the database Alert Log, as these values are spooled to the al...")
- 23:37, 8 November 2019 Admin talk contribs created page Log Mining (10g) (Created page with "'''Please note the database parameter log_parallelism needs to be set at 1 for this to work''' In this day and age of flashback configuration, log mining almost seems like...")
- 23:37, 8 November 2019 Admin talk contribs created page Check Last Applied Archive Log (Created page with "<blockquote><pre> SELECT max(sequence#) FROM v$log_history; </pre></blockquote> OR ... <blockquote><pre> SQL> archive log list; </pre></blockquote>")
- 23:37, 8 November 2019 Admin talk contribs created page Foreign Archive Logs (11g) (Created page with "A colleague of mine recently noticed in our Fast Recovery Area (aka Flash Recovery Area) that some FOREIGN ARCHIVED LOGS were taking up space. We knew from a recent implement...")
- 23:36, 8 November 2019 Admin talk contribs created page Cloning Schema (11g) (Created page with "Found an interesting way to clone a schema '''in the same database''' using datapump with a database link. Could be considered a highly unsupported method, but it worked for...")
- 23:36, 8 November 2019 Admin talk contribs created page Available db recovery file dest (Created page with "A great script picked up somewhere along the way to check the available amount of db_recovery_file_dest space. <blockquote><pre> SELECT name , floor(space_limit/1024/102...")
- 23:35, 8 November 2019 Admin talk contribs created page Manually Create a Controlfile via SQL (Created page with "Something I no doubt cobbled together many years ago for reasons I cannot recall. Could be useful though! <pre> declare cursor log_files is select v$log.group#...")
- 23:35, 8 November 2019 Admin talk contribs created page Datapump Dynamic List of Tables (Created page with "In PeopleSoft, I needed to export out all configuration/system-owned tables as a backup each week. To achieve this, my first step was to create a view listing all these tables...")
- 23:34, 8 November 2019 Admin talk contribs created page Monitoring Import Job Progress (Created page with "<blockquote><pre> SELECT substr(sql_text, instr(sql_text,'INTO "'),30) table_name , rows_processed , round( (sysdate-to_date(first_load_time,'yyyy-mm-dd hh24:mi:ss')...")
- 23:34, 8 November 2019 Admin talk contribs created page Pipe Database Export to Zip (Created page with "Using fifo (first in first out) you can redirect your database exports through a pipe straight to zip. '''Make fifo pipe:''' mkdir fifo db.fifo '''Write the file output...")
- 23:33, 8 November 2019 Admin talk contribs created page Monitoring RMAN Job Progress (Created page with "<blockquote><pre> SELECT sid , serial# , context , sofar , totalwork , round(sofar/totalwork*100,2) "%_Complete" FROM v$session_longops WHERE opnam...")
- 23:33, 8 November 2019 Admin talk contribs created page RMAN Archivelog Deletions (Created page with "<blockquote><pre> rman nocatalog<< DATA connect target delete noprompt archivelog until time 'SYSDATE-n'; DATA </pre></blockquote> <blockquote><pre> rman nocatalog<< DATA con...")
- 23:33, 8 November 2019 Admin talk contribs created page Flashback Table (10g) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_ret...")
- 23:32, 8 November 2019 Admin talk contribs created page Flashback Schema (10g) (Created page with "Technically there is no schema level flashback feature available. However, provided your recovery period does not include any data dictionary changes DDL) then you could actua...")
- 23:32, 8 November 2019 Admin talk contribs created page Flashback Row (10g) (Created page with "The ability to flashback transactions to a point in time is quite a handy feature. Here is how it all works .... First of all, the oracle init.ora parameter db_flashback_rete...")
- 23:31, 8 November 2019 Admin talk contribs created page Check Space Fast Recovery Area (Created page with "<blockquote><pre> SELECT name , floor(space_limit/1024/1024) "Size_MB" , ceil(space_used/1024/1024) "Used_MB" , floor(space_limit/1024/1024) - ceil(space_used/1...")
- 23:30, 8 November 2019 Admin talk contribs created page RMAN - Point in Time Duplicate (11.2.0.2.0 (Created page with "I've spent weeks struggling with a point-in-time rman duplicate where for some obscure reason the duplicate would fail to apply point-in-time logs after midnight. FINALLY -...")
- 23:29, 8 November 2019 Admin talk contribs created page RMAN - Diagnosing Failures (11g) (Created page with "The commands you can use through RMAN to list, seek advice on and in some cases repair Database Failures .. <blockquote><pre> RMAN> list failure [detail]; RMAN> advise failur...")
- 23:28, 8 November 2019 Admin talk contribs created page Automatic Guaranteed Restore Point (11g) (Created page with "-- Script to schedule the creation of a guaranteed restore point on a database -- and to remove the oldest guaranteed restore point when there are more than 2 -- restore point...")
- 23:27, 8 November 2019 Admin talk contribs created page Restore in between Upgrades (Created page with "'''Requirement''' Had to restore a database to a point-in-time from a hotbackup. Followed Steps: * Copied datafiles to target * Created a New Controlfile * Recovered using...")
- 23:27, 8 November 2019 Admin talk contribs created page Snapshot Standby Database (11g) (Created page with "'''Introduction''' <br> One of the best new features of Oracle 11g is the introduction of Snapshot Standby Databases. This feature allows you to take a normal Physical Standb...")
- 23:26, 8 November 2019 Admin talk contribs created page Recovery-Tasks (Created page with "=== Database Restores/Refreshes/Recovery === Snapshot Standby Database (11g) Restore in between Upgrades | Restore in between Upgrades...")
- 23:09, 8 November 2019 Admin talk contribs created page Database Size (2) (Created page with "<blockquote><pre> SELECT TARGET_NAME , ROUND (SUM (FILE_SIZE) / 1024 / 1024 / 1024) GB FROM MGMT$db_datafiles_all GROUP BY TARGET_NAME </pre></blockquote>")
- 23:09, 8 November 2019 Admin talk contribs created page Database Size (1) (Created page with "<blockquote><pre> select a.DTTM , trim(substr(a.target_name, instr(a.target_name,'.')+1,20)) HOST_NAME , trim(substr(a.target_name, 1, instr(a.target_name,'.')-1))...")
- 23:08, 8 November 2019 Admin talk contribs created page Clearing Alerts (Created page with "<blockquote><pre> SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||''' , p_key_value...")
- 23:08, 8 November 2019 Admin talk contribs created page Datafile Size (Created page with "In my case, I used the following scripts to list the datafiles incorrectly set to unlimited, i.e. growing to 32768M. <blockquote><pre> SELECT target_name , file_name...")
- 23:07, 8 November 2019 Admin talk contribs created page Tablespace Allocated and Used (Created page with "<blockquote><pre> SELECT A.RT , A.ALLOCATED , B.USED FROM (SELECT TO_CHAR(ROLLUP_TIMESTAMP,'YYYY-MM') RT , AVG(AVERAGE) ALLOCATED FROM MGMT$...")
- 23:07, 8 November 2019 Admin talk contribs created page User Defined Metrics (Created page with "<blockquote><pre> SELECT * FROM mgmt$metric_current WHERE metric_name like '%UDM%'; </pre></blockquote> <blockquote><pre> SELECT * FROM mgmt$metric_hourly WHERE target...")
- 23:06, 8 November 2019 Admin talk contribs created page List DBs on AIX (Created page with "<blockquote><pre> select target_name , host_name from mgmt$target where target_type='oracle_database' and host_name in (select target_name...")
- 23:06, 8 November 2019 Admin talk contribs created page UDM Collection Interval (Created page with "You may have noticed that User Defined Metrics (UDM) in Oracle Enterprise Manager (OEM) have a minimum collection time of '''5''' minutes. If you wish to change this interva...")
- 23:04, 8 November 2019 Admin talk contribs created page High Level Steps to Migrate Datafiles (Disk Groups) (Created page with "Just some notes for my own reference. Had to migrate all my datafiles on a database from one Disk Group (DATA) to Another (DATAR), using RMAN to copy the datafiles. '''Pre-...")
- 23:03, 8 November 2019 Admin talk contribs created page Check Disk Groups (Created page with "<blockquote><pre> SELECT NAME, HEADER_STATUS, PATH, OS_MB FROM V$ASM_DISK ORDER BY NAME; </pre></blockquote>")