์ฝ˜ํ…์ธ ๋กœ ๊ฑด๋„ˆ๋›ฐ๊ธฐ

Oracle sysdba ๊ถŒํ•œ ๋ถ€์—ฌ ๐Ÿ”ฎ

Oracle DB ์ผ๋ฐ˜ ์‚ฌ์šฉ์ž์—๊ฒŒ grant sysdba to c##user;์™€ ๊ฐ™์ด sysdba ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ๊ฒฝ์šฐ ORA-65175: ๋กœ์ปฌ์—์„œ ๋ฃจํŠธ์— SYSDBA ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

  • ๋ฐฉ๋ฒ•

  • Password file ์ƒ์„ฑ

$ orapwd file=$ORACLE_HOME/dbs/PASSWORD password='PASSWORD' entries=5

  • ์„ค์ •ํŒŒ์ผ ์ˆ˜์ •

$ vim ORACLE_HOME/dbs/initSID.ora

initSID.ora

#     thayes     11/27/91 -  Change default for cache_clone
#     jloaiza    08/13/91 -         merge changes from branch 1.7.100.1
#     jloaiza    07/31/91 -         add debug stuff
#     rlim       04/29/91 -         removal of char_is_varchar2
#   Bridge     03/12/91 - log_allocation no longer exists
#   Wijaya     02/05/91 - remove obsolete parameters
#
##############################################################################
# Example INIT.ORA file
#
# This file is provided by Oracle Corporation as a starting point for
# customizing the Oracle Database installation for your site.
#
# NOTE: The values that are used in this file are example values only.
# You may want to adjust those values for your specific requirements.
# You might also consider using the Database Configuration Assistant
# tool (DBCA) to create a server-side initialization parameter file
# and to size your initial set of tablespaces. See the
# Oracle Database 2 Day DBA guide for more information.
###############################################################################

# Change '<ORACLE_BASE>' to point to the oracle base (the one you specify at
# install time)

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
๋ชจ๋“  ๋Œ“๊ธ€๋ณด๊ธฐ