Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ORA-02248
- Thread starter arup61
- Start date
Knowing your OS and Database version would really help.
How are you attempting to start the database?
The error you reported is not related to startup usually:
--------------------------------------------------------
ORA-02248
ORA-02248invalid option for ALTER SESSION
Cause:An option other than SET EVENTS was found following the ALTER SESSION command.
Action:Specify the SET EVENTS option after the ALTER SESSION command, and try again.
-----------------------------------------------------------
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
How are you attempting to start the database?
The error you reported is not related to startup usually:
--------------------------------------------------------
ORA-02248
ORA-02248invalid option for ALTER SESSION
Cause:An option other than SET EVENTS was found following the ALTER SESSION command.
Action:Specify the SET EVENTS option after the ALTER SESSION command, and try again.
-----------------------------------------------------------
- Thread starter
- #3
hello turkbear
my OS is win. 2000 professional and i'm using oracle 9i
version. i am connecting as :
SQL>conn sys as sysdba
SQL> startup
now before allocating the SGA(in the nomount stage), this error message is coming.
i have already checked the action for this error but how
can i give that command as my database is not starting.
i hope i have cleared my problem.
thanks for ur help
arup61
my OS is win. 2000 professional and i'm using oracle 9i
version. i am connecting as :
SQL>conn sys as sysdba
SQL> startup
now before allocating the SGA(in the nomount stage), this error message is coming.
i have already checked the action for this error but how
can i give that command as my database is not starting.
i hope i have cleared my problem.
thanks for ur help
arup61
hi arup61
i have got ur problem, if u r using oracle 9.0.1 version then this problem is coming due to a bug, which is in this version. now if u have specified any operating system environment variable for 'nls'(national language set), then remove that variable from the operating system. after this ur database will run properly.
hope this will solve ur problem
monujain
i have got ur problem, if u r using oracle 9.0.1 version then this problem is coming due to a bug, which is in this version. now if u have specified any operating system environment variable for 'nls'(national language set), then remove that variable from the operating system. after this ur database will run properly.
hope this will solve ur problem
monujain
- Status
