SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error ORA-02248 invalid option for ALTER SESSION

msOct 19 2008 — edited Jun 19 2009

Hi All,

I'm using windows vista.I have installed oracle database 11g.Now, SQL Developer is working fine in this.I gave the sid as orcl and gave my username and password in sqldeveloper and it works.
But the host string is not working in forms and sql plus.How do i know which host string i should give??I came to know that the tnsnames.ora which is present in the oracle home directory should be copied to forms directory also.I did that too but still forms,reprorts and sql plus are not working.I get two errors namely ORA-02248 invalid option for ALTER SESSION and TNS could not resolve service name .Pls suggest how to proceed.Thanks in advance....

Regards,
Gowtham

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2009

Added on Oct 19 2008

2 comments

1,847 views