Re: Connect to Oracle 11g using PL-SQL developer and SQL PLus
Date: Tue, 15 Oct 2013 07:47:00 -0700 (PDT)
Message-ID: <900e23d7-a247-44e0-b2ec-5f0765ad0f93_at_googlegroups.com>
On Tuesday, October 15, 2013 2:25:58 AM UTC-6, Amir Diwan wrote:
> _at_jg: I mean where is the snapshot attachment option in this group?
>
>
>
> Your posts are helpful. All the .ora files are in the dbhome_2\network\admin\ folders.
>
>
>
> Thanks.
Have you set the ORACLE_SID environment variable to the name of your local database? You need to:
C:\>set ORACLE_SID=
C:\>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 15 08:45:04 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
C:\>set ORACLE_SID=smedley
C:\>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 15 08:45:57 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> David Fitzjarrell Received on Tue Oct 15 2013 - 16:47:00 CEST