Re: Connect Internal
Date: Tue, 3 Oct 2000 18:55:34 GMT
Message-ID: <39DA2BA6.B8717815_at_edcmail.cr.usgs.gov>
One of your problems could be that the service can not find the password file. I'm assuming that you moved the password file as well. The other problem is that you used the incorrect procedure to move datafiles. To move the data files:
- shutdown the database
- move the datafiles with OS commands
- modify the INIT.ORA to point to the moved CTL files if necessary
- From the DOS prompt, start server manager ("svrmgr23" most likely if you are using Oracle 7)
- Issue STARTUP MOUNT command
- From the prompt, rename each datafile with the ALTER DATABASE RENAME FILE 'old file name' TO 'new file name';
HTH,
Brian
sean wrote:
>
> Hi All,
>
> I have Oracle7 installed on my WindowsNT4 on drive D, and my working
> database on drive E. Now, I have also restored my client database folder on
> drive F. In order to browse the database in drive F, I have done some
> manipulation on E:\database\initXXXX.ora to refer to the restored
> F:\database\ctrl1YYYY.ora and ctrl2YYYY.ora
>
> After I stop and start the OracleServiceXXX, and tried CONNECT INTERNAL from
> svrmgr23... But I got message "insufficient privilege..." or "SGA not
> error"...
>
> I need connect internal in order to "alter database rename..." please
> advice
> Thanks
> Sean
-- ======================================== Brian Peasland Raytheons Systems at USGS EROS Data Center These opinions are my own and do not necessarily reflect the opinions of my company! ========================================Received on Tue Oct 03 2000 - 20:55:34 CEST