Search results for query: *

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...

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...

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

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 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...

Can i run multiple table imports on a database. I understand it might be a bit slower but is it possible. What problems if any might i encounter and if any what solutions! cheers

I think this is an OS problem and not ORACLE but the problem i have is.. When i do a query on dates it brings back anything from 01-49 as a 2000 date and 50-99 as a 1900 date. All good and well you might say. But i want it to reflex 01-99 as 2000 dates .... How this be changed. It works fine on...

How do i achieve this action. I have a table on the 8i database and when i export it and try to import onto the oracle 7.3.4 database i get error's. How can i achieve this action, is there any export parameters i use to then allow me to import in again on a different db? cheers

Is there a compatablity problem with forms 6 and oracle 8.1.7. The application keeps freezing. Should we be using froms 6i only with 8.1.7 thanks for help in advance [2thumbsup]

Upgrade to sp4 now when boots comes up with FAT32 error. Goes through the motions of repair says everything is ok and no repairs made then re-boots again. Goes to Fat32 at point when normally the 'Alt ctrl del' option should apprear. Have not got a boot disk. Cannot seem to load in safe mode to...

I've recently upgraded my P.C from 98 to 2k. I created a seperate restricted user on the P.C for my daughter. Now when she tries to access her WOrd docs it fails with a permission, doc type error.This is also true of excel etc. Any ideas. I have tried to give her admin rights but still get...