Carlin Anderson wrote: > I have 2 Sun/Oracle installtions where the first installation (QA) is a > single unit system (web server, application, db server all on the same unit) > , and the second installation (Production) is a 2 unit system where the > database is separate from the web server and application code. > > On the QA system, I can connect to the database and execute queries without > problem. On the production system, however, I am receiving this error: > > Couldn't connect to database: ORA-12154 (DBD ERROR: OCIServerAttach) > > I can connect using sqlplus and the same TNS name, so I don't think the TNS > configuration is the issue. We are using Oracle 8.1.7 on both systems now > (production was just upgraded from 8.1.6). > > Ideas anyone?
are you using service names or SID? have you tried using <SID.world>? are you sure the TNS connect string is being passed correctly? do you have multiple ORACLE homes and are you sure it's accessing the correct TNSNAMES.ora? is TWO_TASK set? -- Bill "Shrek" Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] ------------------------------------------------------------------------ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ------------------------------------------------------------------------ You can't get where you want to go if you don't know where you are -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
