Tag Info

New answers tagged

0

When you use sqlplus a549189/myPassword@"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=identityprovisionreport.fmr.com)(PORT=1524))(CONNECT_DATA=(SID=AARCER1)))" then you don't need any tnsnames.ora file. Your entry in tnsnames.ora file should be like this: AARCER1 = (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= identityprovisionreport.fmr.com)(PORT=1524)) ...


0

I succeeded to connect after these instructions in cmd: SQL> connect sys/manager as sysdba Connected. SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. ..... ORA-01172:... ORA-01151:.... SQL> recover database; Media recovery complete. SQL> alter database ...


0

Restart your database and that may clear up your issue. Any more relevant advice will require alert logs or trace files from the database.


0

Below will show temp file size. select sum(bytes)/1024/1024 as sizemb,tablespace_name from dba_temp_files order by tablespace_name;


0

You need to check whether the file physically present at mount point. As you created pfile from spfile, retry with startup pfile='/u01/app/oracle/product/11.2.0/dbhome_1/dbs/init.ora' Side by side tail -f ALERT LOG see if there is more information for the issue you are facing.



Top 50 recent answers are included