ORA-00257: archiver error

ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

Recently, there's an issue at the development database saying, user cannot connect although sysdba is able to connect. The following error is logged in the alert log file.

When the archiver state is queried from v$database, it says - stopped.

The reason for the error is that the mountpoint of the archived logs is 100%. So we need to backup the archive logs to a different location and free-up the disk usage.

With this the archiver starts to run.

XServer - XTerm

Xterm:

In case, if you need a gui based tool (unlike putty) for any installation in solaris/aix servers, the software mobaxterm can be used.

It’s similar to putty (a portable executable file) but with x11 server.
While using it, just need to make sure the display is set to the locahost server (i.e. the windows server on which you’re running the mobaxterm), with that you’re all set to go with gui based installation.

Below outlines the purpose of MobaXterm:

MobaXterm is an enhanced terminal for Windows with an X11 server, several network tools for remote computing and all the essential Unix commands packaged into a single portable exe file. MobaXterm has been designed to suit the needs of computer users, sysadmins, developers and webmasters by providing:
- a multitab terminal with embedded Unix commands (ls, cd, cat, sed, grep, awk, rsync, wget, ...)
- an embedded X11 server for easily exporting your Unix/Linux display
- a session manager with several network utilities: SSH, RDP, VNC, SFTP, FTP, Telnet, Rlogin, FTP, SFTP and XDMCP

The downloads,documentation can be found at: http://mobaxterm.mobatek.net/

Check DB Size - Oracle

select (select sum(bytes)/1024/1024 from dba_data_files)+
(select sum(bytes)/1024/1024 from dba_temp_files) "Size in MB" from dual;

MS SQL Memory Setting

To set the memory of MS SQL Server, use the following formula.The default is unlimited in the SQL server during installation.

2GB-Base memory requirement for Enterprise version + (Total Server memory / 2)
 *Example 2GB + (16 / 2) = 10 GB.

This is to prevent other services and process such as backup, antivirus and OS operations from reaching a memory limit when the SQL server attempts to use the maximum memory for optimal performance.
Thank you.

More information at this link.
http://msdn.microsoft.com/en-us/library/ms143506(v=SQL.100).aspx