I am getting the error frm-92150 when I try and access the oracle 9i application.
Setup is as follows oracle 9i database
3 applications servers
load balanced via dynamic wrapper file.
java version 1.4.2
jinitiator version 1.3.1.13
forms applet is 60825
I have tried to clear jar cache from p.c...
I am looking for a way to identify a apps server process to the oracle database and then eventually to the username.
I have a process id from a solaris apps server, the process id relates to a f60webmx process.
I want to be able to identify which user this process belongs to.
Any ideas how I...
This is a more reasonable explanation ken thanks.
But how do i fix this, any scripts available to anlayze what is fragmenting this area.
We have had a few performance issues and this is why i am trying to rebuild and re-create certain indexes.
thanks
As i said in the original message the index_ts tablesapce has plenty of free space to accomodate the size of the new index.
Why does it still error with space allocation problem?
I am creating file not rebuilding index therefore the space required in tablesapce datafile should only equal the...
Trying to create a index in the INDEX tablespace and receiving ora-1652 error.
index initial size 103m next extent 5m.
plenty of space in datafiles to create this index.
default temp tablespace size 1024m 50% free.
sort_area_size = 10240000
any ideas why i cannot create index and keep receiving...
I have created a database and gone through the motion of creating a repostitory but then it hangs on the create repository user after i have entered the new passwords for sys and system.
Do I have to configure tnsnames manually to my PC on the network before attempting this or how does it work...
The secure menu access and script from the unix side is not a problem its the permissions of the oracle user i want to use to reset password.
Is there any type of user i can setup on the oracle side which does not require full dba access but still can get to password maintenance.
cheers
Our helpdesk require oracle user access to take the burden of resetting passwords for users off our hands.
Is there any secure way of giving them an oracle user which only has this permissions and nothing else, giving people outside of the dba team admin permissions is something I do not want...
package UTL_RECOMP is in a invalid state and will not recompile.
How can i get this back to a valid state.
Where can i get the package recreated from ?
thanks
I have rsh setup but what files require amending to be able to use from one server to another.
I have the server I.P in /etc/hosts, what other steps to i need to do so i can execute commands.
thanks
/tpp/oracle/general/9.2.0/bin:/tpp/oracle/general/6.0.8/bin:/usr/bin:.:/usr/local/bin:/opt/bin
This is the $PATH echo from the script when executed from the application.
/usr/bin on path is there anything missing to affect ksh ?
thanks
Trying to run a script from a 3rd party application.
When execute script from command line works fine, runs in ksh enviroment using typset function.
When running through third party application fails
typset not found & integer: not found.
First line of script is #!/usr/bin/ksh
tried to echo...
What do I need to setup to achieve a clone database which will apply archieve logs.
I have 2 SUN servers adn 2 oracle 8i databses. At present I copy a cold dump from 1 database to another. We need it more up-to-date so I need to apply archive logs as they are created or even better apply rodo...
I know its running out of VirtMem ie swap space, and yes i could use another filestem for TARFILE but then i would have to run the compress after the tar file is created.
Due to space i require to compress the file at the same time as its being created ! This is the problem.
thanks
??
It doesn't seem to run the compress, the tar will complete until its used all swap space then fails.
It seems to create the .Z compressed file but does not contiue to write to it ?
I am sure its a enviroment problem also but surely if i am running a compress in the background all it requires is...
I have created a script which runs a compress in the background and then runs a tar of oracle datafiles.
This works fine from command line but when running via crontab has memory problems and does not seem to compress.
Is there any easy way to run job through crontab which will achieve this...
I have a v880 and upto recently we had a 10/100 network card working fine.
We switched to a newly installed 1gb card and we cannot establish a network connection.
We rebooted box to get new link which shows correct i.p netmask and broadcast addresses.( using same network cable originally in...
Hi,
I have 2 rollbacks online both in the same tablespace but with different size datafiles.
The smaller rollback has filled with:
ORA-1650: unable to extend rollback segment BIG_RB by 640 in tablespace
ROLLBACK_TS
Failure...
How do i secure connections into the server.
We have a user setup at present set to group usr.
How do i set permissions to stop users going down the file structure. I want to restrict them to the home directory or at least stop them accessing / and /etc and other system directory's.
Many thanks...
I have created a profile with my relevant password parameters and conditions.
How can i incorporate this profile and how do i create a form from a web base oracle application to call this profile and allow the users to action there own password change from the menu's.
The script needs to allow...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.