From: Robert Klemme Date: 2009-02-18T15:59:56+09:00 Subject: Re: ORA-12546: TNS:permission denied On 18.02.2009 02:05, Kyung won Cheon wrote: > OS: CentOs4.7 > Oracle: 9.2.0.4.0 > ruby: ruby 1.8.7 > > I'm trying install ruby & dbi & oci8 > > root have to connect sqlplus for oci8 > > oracle user connect sqlplus but root not > > [root]# sqlplus user/pass > > SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 18 10:03:22 2009 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > ERROR: > ORA-12546: TNS:permission denied First, this is totally off topic here. Second, you're most likely not connecting to the DB you think you are. Third, root's ORACLE_HOME and ORACLE_SID are probably differently set than those of user oracle. Btw, root is not intended to do regular work. Cheers robert -- remember.guy do |as, often| as.you_can - without end