To open the database after media recovery is completed, while in sqlplus connect to the database as sys/password as sysdba and type: Alter database open; If this fails, try to shutdown and restart the database by typing: Shutdown immediate; Startup; The database should open at this poi...
Now to fix the listener (This is a one-time operation, you don't have to do this every restart.) open a Windows command prompt as Administrator (type cmd in the start menu and click "Run as administrator") Now enter the following commands exactly: sqlplus /nolog c...
9) Delete the file from its original location either per SQLPLUS or per ASMCMD: e.g.: SQL:ASM> ALTER DISKGROUP ASMDSK2 DROP FILE users.256.565313879; or: ASMCMD> rm -rf <filename> Note: Most Automatic Storage Management files do not need to be manually deleted because, as Oracle manage...
16.To allow connections from outside the server, you will need to open the following ports: 1521/TCP 5500/TCP 5520/TCP 3938/TCP As follows: # firewall-cmd --zone=public --add-port=1521/tcp --add-port=5500/tcp --add-port=5520/tcp --add-port=3938/tcp --permanent # firewall-cmd ...
INF - Putting the database in open state. INF - Using: /export/home/oracle/OraHome1/bin/sqlplus INF - Connection info: 'connect oracle/*** as SYSDBA'. INF - Start of SQLPLUS output. INF - SQL*Plus: Release 9.2.0.1.0 - Production on Fri Sep 30 15:17:49 2005 INF...
sqlplus / as sysdba No password is required. This is equivalent to the unsupported “connect internal” method. A password is required for “non-secure” administrative access. These passwords are stored in password files. Remote connections via Net8 are classified as non-secure. Look at this ...
Verify SQL*Net connectivity from source host to target PDB: [oracle@source]$ sqlplus system@<target ip>/<pdb-service-name> Verify database character set and national character set are the same: SOURCE/SALES SQL> select property_name, property_value from database_properties where...
1. Start the Oracle WebLogic Server Admin Server: Use the command prompt or terminal to navigate to the Oracle WebLogic Server installation directory. Start the Admin Server by executing the startWebLogic.sh (Unix/Linux) or startWebLogic.cmd (Windows) script. 2. Access the WebLogic Server Admini...
The steps involved in moving a datafile from a diskgroup to another is as given below. 1) Identify the data file to be moved. 2) Identify the diskgroup on to which the file has to be moved. 3) Take the file offline. 4) Copy the file to new diskgroup using Either RMAN or DBMS_FIL...