Hello,
I read that I need to increase the SESSION and/or the MAX_LOGIN_SESSION parameter located on my Linux Server in the Oracle 9i init.ora file to avoid some problems.
1) Where can I find the database init.ora file ?
(under $ORACLE_HOME ??)
PT
Printable View
Hello,
I read that I need to increase the SESSION and/or the MAX_LOGIN_SESSION parameter located on my Linux Server in the Oracle 9i init.ora file to avoid some problems.
1) Where can I find the database init.ora file ?
(under $ORACLE_HOME ??)
PT
Believe me if someone here tells you you may not learn much - relax and try the Linux find cmd. for it and your knowledge will definitely increase !!
:cool:
Usually in $ORACLE_HOME/dbs, buut it may be linked elsewhere. Try:
find / -name 'init*.ora'
to find all references. We all start somewhere!
remember to create spfile to permanently modify the configuration parameter.:confused: :confused:
why do you need an spfile to store something permanently
when you start your db using nomount pfil=.... in 9i to alter your parameter file, it will only last until the db will be shutdown. In a
normal operation where in starting db with STARTUP would be fine without other parameters. SPFILE(server parameter file) needs to be updated with the new init.ora value to make that effect.
Or was my previous post was just somehow confussing? :)
i dont user an spfile, all changes I make in the init.ora are permanent.
So why do I need an spfile to make things permanent
hey ptreves, you have been installing a nd creating database for a long time now if I remember right. And usually the first thing anyone creating a database encounters is the init.ora file which you still seemed to have never seen. That's really bad froma dba point of view.
That is the file which defines most of the oracle parameters for your database.
Like Ken mentioned, you will find it in $ORACLE_HOME\dbs most probably as a link or you may find it under the \pfile directory wherever that has been created for you when you created the database using the database configuration assistant.
Hello,
Thanks for all your comments and feedback.
Yes, I have been working on this migration project for about 2-3 months now. I have made a lot of progress. I succeeded in installing Oracle 9i Database on my Linux Server and installed Forms/Reports Services 10g on the same server and migrated my Forms/Reports application from 6i to 9i and deployed my WebForms over the Web. That part is pretty much workin after much sweet and tears and long hours.
However in order to deploy my WebReports over the Web, WebReports called from WebForms using Parameter Forms, I ran in to Report Services Errors such as: REP-50125, REP-51018 and REP-51019 in a reports trace file.
I have been reading related articles on metalink, that mention that I should increase the SESSION parameter in the database init.ora file.
I found that there was no SESSION parameter in my init.ora file so it must use default values. I tried to set the SESSION parameter to 9999, and restart my Oracle 9i database. However, this has not resolved my problems with the deployment of my WebReports.
This is why I was asking this questions.
Any suggestions ???
Regards,
PT
I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.Quote:
Originally posted by davey23uk
i dont user an spfile, all changes I make in the init.ora are permanent.
So why do I need an spfile to make things permanent
Where in the hell did you come up with that?Quote:
I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.
You people really need to sit down and read the manual.
I could probably be wrong but isn't it with the case of 9i?Quote:
Originally posted by OracleDoc
Where in the hell did you come up with that?
You people really need to sit down and read the manual.
you have the option to create an spfile.ora which is basically derive from init.ora?
You guys are purposely doing this in an effort to spin me up aren't you? Come on tell me the truth.Quote:
Originally posted by reydp
I could probably be wrong but isn't it with the case of 9i?
you have the option to create an spfile.ora which is basically derive from init.ora?
no(;) ) really...Quote:
Originally posted by OracleDoc
You guys are purposely doing this in an effort to spin me up aren't you? Come on tell me the truth.
that is what as far as I can remember, my production DBs right now are 8is( boring...:o )... we're still on the stage of planning to migrate to 10g.:cool:
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.
The original poster(ptrieves) originally ask the init.ora file for his 9i db because he have something to alter one/more of the parameters. Even if he can successfully start the db with the new init.ora file, he could be wondering later-on when he stops and starts the db if the init.ora that he made take effect. That is why I did advancely inform him to create spfile.Quote:
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.
I was not talking about the dynamic parameters that could be change even the db is alive.
:D
you can only create spfile when db is up.;)Quote:
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.
At the command prompt when the database is down you type in create spfile from pfile.
Now, if you're paid by line of code . . .Quote:
Originally posted by reydp
I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.
Wanna bet?Quote:
Originally posted by reydp
you can only create spfile when db is up.;)
Though I'm only paid(monthly) probably equivalent to what you recieve daily(or maybe even less), I still made my works easy..:DQuote:
Originally posted by DaPi
Now, if you're paid by line of code . . .
you are urging me to say this Dapi aren't you? ;)
I don't wanna bet....Quote:
Originally posted by OracleDoc
Wanna bet?
but I'm going to salute you, if you can do that.:)
Damn, I was hoping you would :D
Code:$ 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
So you are the one who is trying to spin me out...:pQuote:
Originally posted by OracleDoc
Damn, I was hoping you would :D
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"
:-)
Paid by line of code?Quote:
Originally posted by julian
Why not in just one command:
I always find it funny when see people type:Quote:
Originally posted by DaPi
Paid by line of code?
1. sqlplus /nolog
2. conn / as sysdba
you can still change things dynamically with a pfile ya know.Quote:
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.
they just need to be saved in the init.ora as well
that's what I'm saying, making life easier.;)Quote:
Originally posted by julian
I always find it funny when see people type:
1. sqlplus /nolog
2. conn / as sysdba
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
why is that making life easier?Quote:
Originally posted by reydp
that's what I'm saying, making life easier.;)
This should be the one that i'm referring(from JULIAN)Quote:
Originally posted by davey23uk
why is that making life easier?
Quote:
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"
:-)
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.Quote:
Originally posted by davey23uk
because everyone has there own way of doing things - its no easier or harder either way
So I rather choose longer method to save my time. ;)
Got your point guys, but is it not what we want?Quote:
Originally posted by davey23uk
because everyone has there own way of doing things - its no easier or harder either way
To find the shortest ways.
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?
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.;)
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
did you increase the parameter, did the problem go away?
To all lazy guys....
Code:$ 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
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.....