init.ora file location

[reydp]

Originally posted by OracleDoc
Wanna bet?

I don't wanna bet....
but I'm going to salute you, if you can do that.

[OracleDoc]

Damn, I was hoping you would

$ 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
Connected.
SQL> select * from V$thread;

   THREAD# STATUS ENABLED      GROUPS INSTANCE         OPEN_TIME CURRENT_GROUP#
---------- ------ -------- ---------- ---------------- --------- --------------
 SEQUENCE# CHECKPOINT_CHANGE# CHECKPOIN ENABLE_CHANGE# ENABLE_TI DISABLE_CHANGE#
---------- ------------------ --------- -------------- --------- ---------------
DISABLE_T
---------
         1 OPEN   PUBLIC            4 gitv             17-NOV-04              2
       622           21610539 17-NOV-04              1 17-AUG-04               0



SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-32002: cannot create SPFILE already being used by the instance

[reydp]

Originally posted by OracleDoc
Damn, I was hoping you would

So you are the one who is trying to spin me out...

[julian]

Why:

$ 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"

:-)

[DaPi]

Originally posted by julian
Why not in just one command:

Paid by line of code?

[julian]

Originally posted by DaPi
Paid by line of code?

I always find it funny when see people type:

1. sqlplus /nolog
2. conn / as sysdba

[davey23uk]

Originally posted by OracleDoc
You know this is pretty good comedy between this thread and that Ora-600 thread, the office is getting a pretty good chuckle out of this.

Ok look (Reydp) there is no spfile in 8i only in 9i and above. At the command prompt when the database is down you type in create spfile from pfile. Once that spfile is created Oracle will automatically use that instead of the init.ora. Therefore making it possible to change things dynamically.

you can still change things dynamically with a pfile ya know.

they just need to be saved in the init.ora as well

[reydp]

Originally posted by julian
I always find it funny when see people type:

1. sqlplus /nolog
2. conn / as sysdba

that's what I'm saying, making life easier.

[ptreves]

Hello everyone,

I see that this thread is taking a life of its own.
The original reason for this posting was that an metalink article that I read indicated that I should try to increase the SESSION parameter in the init.ora file for my Oracle 9i database.

When deploying my Forms/Reports 9i application over the Web with my Linux server, I get REP-51018 and REP-50004 errors when I try to call WebReports from WebForms.

1) Any anyone ran into this problem before ?

2) Would reinstalling Forms/Reports 10g without any SSO (Single Sign ON) feature resolve this matter ?

I have read that I should use the SYNCHRONIZE keyword before the call to Web.Show_document + make changes to my (report server).conf file + make changes to my rwservlet.properties file.

3) Any insight into this issue ?

Regards,

PT

[davey23uk]

Originally posted by reydp
that's what I'm saying, making life easier.

why is that making life easier?