-
Originally posted by OracleDoc
Wanna bet?
I don't wanna bet....
but I'm going to salute you, if you can do that.
-
Damn, I was hoping you would
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
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Originally posted by OracleDoc
Damn, I was hoping you would
So you are the one who is trying to spin me out...
-
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"
:-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Originally posted by julian
Why not in just one command:
Paid by line of code?
-
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
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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.
-
Comments
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
-
Originally posted by reydp
that's what I'm saying, making life easier.
why is that making life easier?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|