15:39:06 SQL> select global_name from global_name;

GLOBAL_NAME
-------------------------------------------------------
SRIRAM


15:39:14 SQL> select name from v$database;

NAME
---------
SRIRAM


15:40:28 SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
sriram

15:42:33 SQL> conn scott/appowner123
Connected.
15:42:59 SQL> disconnect
Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
15:43:06 SQL> conn scott/appowner123@sriram
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process

ORA-12500: TNS:listener failed to start a dedicated server process
 *Cause:  The process of starting up a dedicated server process failed.
 The executable could not be found or the environment may be set up
 incorrectly.
 *Action: Turn on tracing at the ADMIN level and reexecute the operation.
 Verify that the ORACLE Server executable is present and has execute
 permissions enabled. Ensure that the ORACLE environment is specified
 correctly in LISTENER.ORA. The Oracle Protocol Adapter that is being
 called may not be installed on the local hard drive.  Please check that
 the correct Protocol Adapter are successfully linked.
 If error persists, contact Oracle Customer Support.