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.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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.
Sigh.....those were the days my friend, I thought they'd never end.
I too remember when this place was coo.
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).
$ alias s='sqlplus "/ as sysdba" '
SQL*Plus: Release 126.96.36.199.0 - Production on Mon Nov 22 17:18:56 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Oracle9i Enterprise Edition Release 188.8.131.52.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 184.108.40.206.0 - Production
Technical Lead (Databases)
Thomson Reuters (Markets)
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
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 ?
PS: I read postings on Oracle Metalink. Any ideas how to resolve the issue with REP-51018 and REP-50004. Regards.....