New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 00:44, 9 November 2019 Use Samba to copy file to Windows (hist) [314 bytes] Admin (talk | contribs) (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 Yesterday's Date (hist) [116 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> date -d '1 day ago' </pre></blockquote> <blockquote><pre> date -d 'yesterday' </pre></blockquote>")
- 00:44, 9 November 2019 Check O/S Version (hist) [138 bytes] Admin (talk | contribs) (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 Chmod (hist) [225 bytes] Admin (talk | contribs) (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 TSM Command Line Restore (hist) [368 bytes] Admin (talk | contribs) (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 Tasks (hist) [227 bytes] Admin (talk | contribs) (Created page with "TSM Command Line Restore")
- 00:38, 9 November 2019 Random Image Generator (hist) [1,187 bytes] Admin (talk | contribs) (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 Global Parameters (hist) [813 bytes] Admin (talk | contribs) (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 Spooling Out (hist) [442 bytes] Admin (talk | contribs) (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 Script to Backup and Restore a MySQL Database (hist) [5,611 bytes] Admin (talk | contribs) (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 Gen-Tasks (hist) [270 bytes] Admin (talk | contribs) (Created page with " Script to Backup and Restore a MySQL Database Spooling Out === MySQL and PHP (The Perfect Match) ===...")
- 00:29, 9 November 2019 Email Results of a Database Export (hist) [2,598 bytes] Admin (talk | contribs) (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 Services Manipulation (hist) [1,371 bytes] Admin (talk | contribs) (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 Count Network Connections (hist) [412 bytes] Admin (talk | contribs) (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 Tree Directory Listing (hist) [786 bytes] Admin (talk | contribs) (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 Check Server UpTime (hist) [62 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>")
- 00:28, 9 November 2019 General (hist) [285 bytes] Admin (talk | contribs) (Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con...")
- 00:25, 9 November 2019 Check Database Uptime (hist) [93 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>")
- 00:25, 9 November 2019 Check Database Version (hist) [55 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>")
- 00:24, 9 November 2019 Clone Role with Securables (hist) [451 bytes] Admin (talk | contribs) (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 Check Mirror Status (hist) [791 bytes] Admin (talk | contribs) (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 Querying Active Directory Members for SQL Server Databases (hist) [1,016 bytes] Admin (talk | contribs) (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 Various-Tasks (hist) [332 bytes] Admin (talk | contribs) (Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr...")
- 23:54, 8 November 2019 Creating an Oracle Database with Apex on AWS RDS (hist) [5,512 bytes] Admin (talk | contribs) (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 SQL Server Backup Script for AWS RDS (hist) [1,157 bytes] Admin (talk | contribs) (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 Auto Refresh of Oracle DB across VPCs (hist) [7,346 bytes] Admin (talk | contribs) (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 Datapump Export to S3/Glacier (hist) [5,218 bytes] Admin (talk | contribs) (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 Dynamic Profile Creation Script (hist) [390 bytes] Admin (talk | contribs) (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 Deploy Amazon Web Services Plugin to Cloud Control (hist) [1,135 bytes] Admin (talk | contribs) (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 Dynamic Tablespace Creation Script (hist) [1,606 bytes] Admin (talk | contribs) (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 Create a DB Link on RDS DB (hist) [234 bytes] Admin (talk | contribs) (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 General-Tasks (hist) [648 bytes] Admin (talk | contribs) (Created page with " Creating an Oracle Database with Apex on AWS RDS Dynamic Profile Creation Script [...")
- 23:46, 8 November 2019 Disable Auto SQL Tuning Advisor (hist) [121 bytes] Admin (talk | contribs) (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 Check Bind Variables (hist) [289 bytes] Admin (talk | contribs) (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 Tuning-Tasks (hist) [123 bytes] Admin (talk | contribs) (Created page with " Check Bind Variables Disable Automatic SQL Tuning Advisor")
- 23:39, 8 November 2019 RMAN - Create Standby Database (hist) [1,218 bytes] Admin (talk | contribs) (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 Resize Online Redo Logs (10g) - Rough Notes (hist) [1,822 bytes] Admin (talk | contribs) (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 READ ONLY Before RESETLOGS (11g) (hist) [427 bytes] Admin (talk | contribs) (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 Check Recovery Time (hist) [209 bytes] Admin (talk | contribs) (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 Manually Create Standby Database from Hotbackup (9i) (hist) [490 bytes] Admin (talk | contribs) (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 Lost spfile and pfile (hist) [199 bytes] Admin (talk | contribs) (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 Log Mining (10g) (hist) [1,675 bytes] Admin (talk | contribs) (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 Check Last Applied Archive Log (hist) [153 bytes] Admin (talk | contribs) (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 Foreign Archive Logs (11g) (hist) [747 bytes] Admin (talk | contribs) (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 Cloning Schema (11g) (hist) [4,585 bytes] Admin (talk | contribs) (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 Available db recovery file dest (hist) [475 bytes] Admin (talk | contribs) (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 Manually Create a Controlfile via SQL (hist) [2,887 bytes] Admin (talk | contribs) (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 Datapump Dynamic List of Tables (hist) [832 bytes] Admin (talk | contribs) (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 Monitoring Import Job Progress (hist) [436 bytes] Admin (talk | contribs) (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 Pipe Database Export to Zip (hist) [335 bytes] Admin (talk | contribs) (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...")