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

Datapump

DataPump:

If you need to export the dump using sys account, then the following is the command:

$ expdp 'userid="/ as sysdba"' full=y directory=dpump_dir dumpfile=datapump.dmp

where the directory is an oracle virtual directory pointing to the physical file location.

Directory needs to be created first using the below command using sysdba account:

$ create directory dpump_dir as '/u01/oracle10g/datapump/export/';

After creating the directory, necessary access needs to be given, if the import/export is going to be done using a different account:

$ grant read,write on directory dpump_dir to appuser;

Datapump export/import using different versions:

If the datapump needs to be exported from say Oracle 11g version to Oracle 10g version, then the version parameter can be used to do the data export.
i.e. In oracle 11g database, the following command can be used to export the dump:

$ expdp 'userid="/ as sysdba"' full=y directory=dpump_dir dumpfile=datapump.dmp version=10.2

In oracle 10g database, the import can be done without any errors:

$ impdp 'userid="/ as sysdba"' full=y directory=dpump_dir dumpfile=datapump.dmp

Change Schema -SQL Server 2005

ALTER SCHEMA NewSchema TRANSFER OldSchema.Table1