M.N's questions

I have MySQL 5.5 Server setup on a Windows machine.

I am able to connect to the server from console / app running on the same machine but not from a remote machine. While connecting using the following command:

mysql -h xx.xx.xx.xx --port=3306 -u root -p

I get the following error:

ERROR 1042 (HY000): Can't get hostname for your address

I have tried putting the entry of client IP in server's %windir%\system32\drivers\etc\hosts file as:

<client-ip>  <client-hostname>

• Server: MySQL 5.5
• OS: Windows XP

One of my application currently uses Oracle 10gR2 as the backend, with PL/SQL Stored Procedures, Triggers, Sequences, etc.

I want to migrate to Oracle XE. Can this edition serve as the primary database for a server?

Also, i am unclear, about is there any limit on:

• Size of database, in terms of no. of records or memory size?
• no. of concurrent connections?
• CPU/other resource utilisation limits/impact?

Please guide.

I am getting this error while trying to create a connection pool, on my Oracle database, Oracle 10gR2.

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

I am able to connect to the database over sqlplus & iSQLPlus client, but when I try to connect using this Java program, I get this error just when the connection pool is to be initialised and it does not initialise the connection pool.

Can someone please help me resolving it?

DB Version: Oracle version 10.2.0.1

OS: RHEL 4.0

Here is a barebone, java code which is throwing this error, while connecting to my database.

import java.sql.*;

public class connect{
    public static void main(String[] args) {
        Connection con = null;
        CallableStatement cstmt = null;

        String url = "jdbc:oracle:thin:@hostname:1521:oracle";
        String userName = "username";
        String password = "password";

        try
        {
            System.out.println("Registering Driver ...");
            DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());

            System.out.println("Creating Connection ...");
            con = DriverManager.getConnection(url, userName, password);

            System.out.println("Success!");

        } catch(Exception ex) {
            ex.printStackTrace(System.err);
          } finally {
            if(cstmt != null) try{cstmt.close();}catch(Exception _ex){}
            if(con != null) try{con.close();}catch(Exception _ex){}
            }
    }

}

I am trying to change the port for iSQLPlus on my Oracle DB server, by making changes in the file http-web-site.xml.

When I change the port to 80, in this file, the iSqlPlus doesn't start. I can nether connect over a browser or telnet to it, even from the host machine itself. On the command line, however, it does not give any errors.

I have tried changing it to other ports that is 8080 and 5560, it is running fine with no problems there.

I am using Oracle 10.2.0_10.

I have a Laptop, on which the OS has got corrupted and gives a system32\config not found error.

To recover my data, I can boot it using Knoppix but I am not able to mount my partition.

My partition is NTFS encrypted with McAfee Endpoint encryption. is there any way I can mount this partition specifying the password?

What is the most significant server outage/downtime that occurred within the last decade due to performance issues, bottlenecks and scalability problems?

Two such examples are the constant problems Twitter has had as soon as it became popular and the Google downtime early in 2009.

What other such incidents you are aware of that you believe created a large amount of havoc affecting the largest # of users? What is there to be learned from such incidents? How have those companies publicly responded to their downtimes?

What is the query to find the no. of current open cursors in an Oracle Instance?

Also, what is the accuracy/update frequency of this data?

I am using Oracle 10gR2

I downloaded util-linux-2.12b package and and built it. I need to use the login utility in the login-utils folder.

But after running it, it gives a "Login incorrect" for every user even with correct username/password.

Now it seems the utility is not working with /etc/shadow passowrds.

if I disable the shadow passwords by

#pwunconv

Its is working fine, while after enabling it with

#pwconv

It stops working again. :(

I wish to grant Shell access over HTTP (using a web browser) to a few of my users. Is there a utility, preferably free, which I may use to enable it.

The no. of users are approx. 100 and I want separate shell sessions for each of them, and the web interface should require them to login with their user/pwd credentials.