To verify that the database is in no archive log mode log into the sqlplus as sys and issue following command and u must get the following output archive log list To enable the database in archive log mode following parameters must be set in init.ora file of instance log_archive_dest_1=<path of the destination where u want the archive logs to be placed> log_archive_dest_state_1=enable log_archive_start=true(Â this parameter is deprecated in Oracle 10g) log_archive_format=arc_%t_%s_%r.dbf |
Wednesday, 15 October 2008
Is my Oracle db in archivelog mode
Posted by
Ook
at
09:42
0
comments
Labels: Oracle
Friday, 3 October 2008
RPM - Listing in date order
Useful for looking at recent changes rpm -qa --last | less rpm -qa --queryformat '%{installtime} (%{installtime:date}) %{name}\n' |
Posted by
Ook
at
06:25
0
comments
Monday, 29 September 2008
OEM Agent - Cleaning out
On the Repos Server SELECT target_name FROM sysman.MGMT_TARGETS where 1=1 and target_type = 'oracle_emd' and target_name like '%mis%' order by 1 commit execute sysman.mgmt_admin.cleanup_agent('target_name:port>'); If this hangs then kill it and run ... update sysman.MGMT_TARGETS_DELETE set delete_complete_time = sysdate where target_name like '%slofosdb01.odl.com:3872%' On the Agent Machine
|
Posted by
Ook
at
03:50
0
comments
Labels: Oracle
Tuesday, 23 September 2008
Speaking Imap (in telnet)
http://support.microsoft.com/kb/189326 Telnet IP address of Mail server (Exchange) 143 LOGIN NTDOMAIN/NTACCOUNT/ALIAS PASSWORD ? LIST "" "*" ? Select Folder (where Folder is the mailbox folder that you want, such as Inbox or Deleted Items) ? FETCH message number> All (where message number is 1, 2, 3, and so on) ? FETCH message number Body (where message number is 1, 2, 3, and so on) ? LOGOUT |
Posted by
Ook
at
07:19
0
comments
MS Server 2003 : Getting an RDP session
To use the command line hacks, you might need to run them from another server if your local operating system doesn't include the commands. You will also need to make sure that you are logged onto that server with an administrative account. The easiest way to do that is just map a drive (you don't have to use a drive letter unless you choose to) net use /user:[username] \\servername\share Here's a command line hack that you can use to figure out what Now we know that the session ID of the offending session is 2. We can use that in the next step, which is using the reset command to log off that user. reset session [ID] /server:servername |
Posted by
Ook
at
07:15
0
comments
Friday, 19 September 2008
NTLM in Firefox
|
Posted by
Ook
at
08:27
0
comments
Wednesday, 17 September 2008
Adding an 11G RAC service
alter system register |
Posted by
Ook
at
06:19
0
comments