| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: "/ as sysdba" Failes But "sys/password@service_name" Works ???
sorry guys i *thought* i figured out and i removed my post but
couldn't catch up with you..
now i got new question:
Actually tThe issue was originated form the task of accessing mix of 8i/9i databases from a central host which has sqplus 8.1.7 version.
Suppose we have remote Unix boxes like 8i_host1, 9i_host1 and 9i_host2 hosting 8i_db1, 9i_db1 and 9i_db2 respectively.
an I'm trying to connect to these databases from a host called center_host.
Below is the list of cases i tried:
CASE-1 (FAILED)
$> sqlplus "sys/mypass_at_9i_db1 as sysdba" ORA-01017: invalid username/password; logon denied
CASE-2 (OK)
$> sqlplus "sys/mypass_at_9i_db1 as sysdba" Connected.
CASE-3 (OK)
$> sqlplus "system/mypass_at_9i_db1"
Connected.
CASE-4 (OK)
$> sqlplus "sys/mypass_at_8i_db1 as sysdba" Connected.
CASE-5 (FAILED)
$> sqlplus "sys/mypass_at_9i_db1 as sysdba" ORA-01017: invalid username/password; logon denied
CONCLUSION
seems sqlplus(9i) allows "as sysdba" option only for local databases. I can not connect to remote 9i database as "sys as sysdba". but this is doable for 8i remote databases as shown above...
i'd greatly appreciate if anybody could explain the logic behin sqlplus behaviour regarding "as sysdba" for remote database acceses and how can I connect to 9i remote db as sysdba ???
Thanks
i.d.
richard.a.elliott_at_williams.com (Richard Elliott) wrote in message news:<8c132b3c.0402260729.1f1d9abd_at_posting.google.com>...
> hjr_at_dizwell.com (Howard J. Rogers) wrote in message news:<14a1f766.0402251539.25024b1_at_posting.google.com>...
> > idogan_tech_at_yahoo.com (Ibrahim DOGAN) wrote in message news:<6bf58828.0402251154.bfd587b_at_posting.google.com>...
> > > I'm trying to connect to a remote Oracle database from a Unix box.
> > >
> > > Unix : AIX 4.3.3.
> > > Oracle: 8.1.7
> > >
> > > $> sqlplus sys/syspassword_at_my_db_name
> > > Connected.
> > >
> > > perfectly works
> > >
> > > but, the following commands generate ORA-12545: error, any idea why ? :
> > >
> > > $> export ORACLE_SID=my_db_name
> > > $> sqlplus "/ as sysdba"
> > > ERROR:
> > > ORA-12545: Connect failed because target host or object does not exist
> > >
> > > i.d.
> >
> >
> > Because when you are connecting from a remote machine, you have to do
> > so via the Listener, which means use a tnsnames alias (or its
> > centralised names resolution equivalent) which is what your first
> > example does. When you fail to suppl an alias, Oracle expects to find
> > an instance named the same as your ORACLE_SID *running on that
> > machine*, not on a remote one.
> >
> > Your second example's error message, when roughly translated into
> > ordinary English, actually reads "'Ere mate: there's no instance
> > called "my_db_name" running on your PC".
> >
> > Regards
> > HJR
>
> FYI, the error msg is actualy documented under TNS-12545. You can get
> the same error if your DNS configuration is not correct, or the
> tnsnames.ora file is missing, or missing the entry for your instance.
Received on Fri Feb 27 2004 - 11:04:28 CST
 |
 |