init.ora file location

[reydp]

Originally posted by davey23uk
why is that making life easier?

This should be the one that i'm referring(from JULIAN)

Originally posted by Julian

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.5.0 - Production on Fri Nov 19 10:27:34 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect / as sysdba

Why not in just one command:

sqlplus "/ as sysdba"

:-)

[davey23uk]

because everyone has there own way of doing things - its no easier or harder either way

[jmodic]

Originally posted by davey23uk
because everyone has there own way of doing things - its no easier or harder either way

Exactly! I'm quite lazy in typing, but I usually connect as sysdba by using the longer method (sqlplus /nolog + connect as sysdba). The reason is very simple: over the time I've found out that the shorter method with double quotes is somewhat more cumbersome for me - I mistype more often and even if I don't then it saves no time for me. I guess the reason is the layout of my national language keyboard where the double quote character key is placed in a quite awqward position, at least for my taste and typing habits.

So I rather choose longer method to save my time.

[reydp]

Originally posted by davey23uk
because everyone has there own way of doing things - its no easier or harder either way

Got your point guys, but is it not what we want?
To find the shortest ways.

[simply_dba]

TO me the best way is the easiest way.
And easiest way is not always the shortest.

I simply use sqlplus
and give / as sysdba at the username prompt.

by the what what happend to the original post?

[Alchemy]

I simply use sqlplus
and give / as sysdba at the username prompt.

If the system is stricktly yours, and your system has the ability to be "put to sleep", set logon to be your system username/password, log on, work(all day) then, set system to sleep. After all the up front work is completed, you are home free. Sure, you will have to enter username/password to "awaken" your system, but only one time.

bada bing, your ready to be productive.

[ptreves]

Hello guys/gals,

Like I said earlier, this thread is taking a life of its own.
I am not realy inquiring about how to create an spfile from an init.ora file.

My reference to the init.ora file is in reference to the SESSION parameter. This comes down to resolving the issue I have with the REP-51018 and REP-50004 Report Services Errors when running Reports called from Forms over the Web (Oracle 9i iDS/iAS).

Any ideas/suggestions ?

Paolo

[davey23uk]

did you increase the parameter, did the problem go away?

[Thomasps]

To all lazy guys....

$ alias s='sqlplus "/ as sysdba" '
$ s

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 22 17:18:56 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

[ptreves]

Hello,

Yes, I did increase the parameter. I did an immediate shutdown of my Oracle 9i DB, added an entry for the SESSION parameter in init.ora and restarted my Oracle 9i DB. I added the following entries in my init.ora file under $ORACLE_HOME/dbs

SESSION=9999
LICENSE_MAX_SESSION=9999


However, this did not resolve the issue. I have the same problem on Oracle 9i iDS (Windows XP Pro) and on my Linux Red Hat Entreprise 3 (ES) sever running iAS.

Any ideas ?

Paolo

PS: I read postings on Oracle Metalink. Any ideas how to resolve the issue with REP-51018 and REP-50004. Regards.....