Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr / as sysdba
On 20 Apr 2005 12:11:01 -0700, bbulsara23_at_hotmail.com (barry) wrote:
>Hi, bit of a mind block :(
>
>Why am I seeing prod3 as the database name when ORACLE_SID=prod3 or prod4 ?
>
>Thank you in advance
>Barry
>
>
>(oracle_at_svr12UK)$
>(oracle_at_svr12UK)$ set ORACLE_SID=prod3
>(oracle_at_svr12UK)$ sqlplus / AS SYSDBA
>
>SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 20 17:20:42 2005
>
>Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
>Connected to:
>Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
>With the Partitioning and Data Mining options
>
>SQL> SELECT NAME FROM V$DATABASE;
>
>NAME
>---------
>prod3
>
>SQL> QUIT
>Disconnected from Oracle Database 10g Enterprise Edition Release
>10.1.0.3.0 - 64bit ProductionWith the Partitioning and Data Mining options
>(oracle_at_svr12UK)$ set ORACLE_SID=prod4
>(oracle_at_svr12UK)$ sqlplus / AS SYSDBA
>
>SQL*Plus: Release 10.1.0.3.0 - Production on Wed Apr 20 17:21:08 2005
>
>Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
>
>Connected to:
>Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
>With the Partitioning and Data Mining options
>
>SQL> SELECT NAME FROM V$DATABASE;
>
>NAME
>---------
>prod3
>
>SQL> SELECT * FROM V$VERSION;
>
>BANNER
>----------------------------------------------------------------
>Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi
>PL/SQL Release 10.1.0.3.0 - Production
>CORE 10.1.0.3.0 Production
>TNS for Solaris: Version 10.1.0.3.0 - Production
>NLSRTL Version 10.1.0.3.0 - Production
>
>SQL> QUIT
>Disconnected from Oracle Database 10g Enterprise Edition Release
>10.1.0.3.0 - 64bit ProductionWith the Partitioning and Data Mining options
>(oracle_at_svr12UK)$
>(oracle_at_svr12UK)$
Maybe TWO_TASK is set also?
Jaap. Received on Fri Apr 22 2005 - 14:41:53 CDT